Data Warehouse/Business Intelligence Developer (SQL Server) HealthHelp, Inc.
Position: DW/BI Developer (SQL Server)
Supervisor: Manager of Business Intelligence
Salary Status: Salary Exempt
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 2012/2008 experience with specific SSIS knowledge and MS Analysis Services understanding with 1+ years of OLAP development experience (Data warehouse concepts, 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 team members so that a single version of business terminology is maintained within the existing reporting architecture.
Work with customers internal and external 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
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
This job operates in a professional office environment. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines.
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.
While performing the duties of this job, the employee is regularly required to talk and hear. The employee frequently is required to stand; walk; use hands to finger, handle or feel; and reach with hands and arms.
As business needs dictate
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.
HealthHelp provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws.
Houston, Texas, United States
||Houston, TX |