Data Warehouse Developer (SQL Server) HealthHelp, Inc.
At HealthHelp, you?ll find a fast-paced, technically challenging work environment. We are seeking a hands-on (SQL Server) Data Warehouse Analyst to assist in the implementation of cutting-edge database technologies within the development and support of HealthHelp Data Warehouse and Data Marts. You will work within our data team to help maintain and enhance our online analytical processing (OLAP) analysis environment.
The right candidate will have strong SQL Server 2008/5 experience with specific SSIS knowledge and strong MS Analysis Services understanding with 3+ years of OLAP development experience (cube design, fact, dimension structure, Data Mart development, etc).
Create, modify, document, and enhance data specifications including identifying and mapping data elements from source systems into the dimensional data warehouse; Translate requirements into technical specifications, Validate that the data warehouse meets specified requirements
Ability to function and contribute in a team environment.
Work with other members of the MEI department so that a single version of business terminology is maintained within the existing reporting architecture.
Work with customers to define and document the scope and functional requirements for data and reporting needs.
Understand and balance business requirements and user expectations.
Ability to work independently on data warehouse tasks with a minimal amount of supervision.
Use of deductive reasoning and analytic ability to transform data into information for key decision makers within the organization verifying that consistent information is always delivered.
Advanced ability with hands on MDX
Experience with relational database systems in an operational environment and particularly with Microsoft SQL Server.
Knowledge of the Kimball data warehouse lifecycle and strong dimensional data modeling experience, star schemas including an understanding of extraction, transformation, and load processes from operational source systems into the data warehouse.
Knowledge of how the Kimball approach has been implemented in the Microsoft BI tool stack including the use of Excel PivotTables or similar reporting tools to fulfill ad hoc data requests when required.
Experience with OLAP and SQL Server Analysis services & SSIS
Collaborate on the global data architecture design and planning for the physical structure and implementation of new module on data warehouse cubes and creation of new data marts.
Extensive experience with MDX desired.
Experience with the challenges of implementing and managing many to many relationships within MS Analysis Services
Knowledge of health system functions strongly desired including terminology and coding.
Must be authorized to work in the United States on a full-time basis for any employer
||Houston, TX |