Data Warehouse/Business Intelligence Developer HealthHelp, Inc.
THIS JOB HAS EXPIRED Job Description
HealthHelp (www.HealthHelp.com), a national specialty management firm, serves its health insurance company customers by decreasing Hi-Tech (Radiology, Radtherapy, Cardiology, etc) healthcare costs while improving enrollees? quality of care and reducing unnecessary procedures & radiation exposure.
At HealthHelp, you?ll find a fast-paced, technically challenging work environment. We are seeking a hands-on (SQL Server) Data Warehouse Developer 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, develop 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 (Data warehouse concepts, cube design, fact, dimension structure, Data Mart development, etc).
Essential Duties and Responsibilities
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.
Bachelor's degree in computer science, mathematics, engineering, information technology, business or related field required
Problem solving skills
Must exhibit good verbal and written communication skills
Excellent organizational skills
Ability to work the required overtime during critical periods
Minimum 5 + years of extensive experience in SQL Server Integration Services (SSIS) and SQL Server analysis Services (SSAS) & SQL Server programming
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.
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. Experience in Mid size to large scale Data warehouse systems.
Knowledge/Experience with MDX is a Big plus
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, Texas, United States
||Houston, TX |
THIS JOB HAS EXPIRED