Business Analyst Job in Horsham 19044, Pennsylvania Us
- Provide onsite development including responsibility for the day-to-day performance, maintenance, and monitoring of the Data Warehouse system and its technical interfaces.
- Design architecture, map business rules and processes into technical solutions.
- Designing and leading the development of production SQL and database changes as well as assistance with the design of efficient database and storage structures.
- Perform analysis, development, and evaluation of data mining in a data warehouse environment that includes data design, database architecture, metadata, and repository creation.
- Hands-on ETL development and Review ETL load jobs for consistency and quality.
- Provide ETL design, development and testing estimations based business requirements and research into data that is currently sourced.
- Design of Data Mart solutions including cube designs.
- Implement Data Management strategies which include validation of source data and the use of data in management reporting.
- Develop design specifications, unit test plans, and troubleshoot client issues. Work with a diverse project team with an emphasis on repeatable processes and technical documentation
- Perform hands-on design, development and testing within the ETL tool environment using a mixture of GUI driven tools and hands-on SQL.
- Analyze, design and implement User Interface (reports and dashboards).
- Educate client management and business users on business value and capabilities of data warehousing and business intelligence.
- Provide advice and guidance on data warehousing approaches and solutions, and use of data warehousing methodology.
- Assist in identifying and prioritizing business information needs, and defining business benefit of data warehousing
- Assist in evaluating and selecting data warehousing tools for business intelligence, data population, data management, metadata management, and warehouse administration.
- Responsible for supporting the architecture and design of the data warehouse, data marts and BI reports which will support various data initiatives.
- Performs table and interface design, development of logical and physical data model/database, ETL processes, BI reporting/OLAP cubes/OLAP reporting, and population and tuning of databases/ETL processes/BI reports/queries while meeting business/user requirements
- Must have experience with Data Warehouse, SQL, ETL, Data Mart.
CIBER, Inc. is a global information technology consulting, services and outsourcing company applying practical innovation through services and solutions that deliver tangible results for both commercial and government clients. Services include application development and management, ERP implementation, change management, project management, systems integration, infrastructure management and end-user computing, as well as strategic business and technology consulting. Founded in 1974 and headquartered in Greenwood Village, Colorado, CIBER has more than 8,000 employees. We operate in 19 countries, serving clients from 14 Global Solution Centers and 70 local offices in North America, Europe and Asia/Pacific. Annual revenue in 2009 exceeded $1.0 billion. CIBER trades on the New York Stock exchange (NYSE: CBR), and is included in the Russell 2000 Index and the SP Small Cap 600 Index. For more information, visit www.ciber.com.
Just as we have built our business on the success of our clients, our continued company growth and achievements are built on the success of our team members. At CIBER we believe our employees are our most valuable asset. Upon contact, a CIBER Recruiter will discuss our benefits package in more detail as it pertains to your individual needs. Some highlights of our full benefits package include: paid time off, paid holidays, retirement savings plan, employee stock purchase plan, medical, dental, vision, life disability insurance, and tuition reimbursement. CIBER, Inc. is an Equal Opportunity Employer.