Description

You will design and implement data models and ETL processes to support complex data management and business intelligence requirements.

Responsibilities

• Design and submit logical, physical, and dimensional data models, including entity relationship diagrams and metadata.
• Develop, create, and modify ETL processes and physical dimensional models for data cubes.
• Facilitate requirements analysis sessions and document data sets to improve query and reporting functionality.
• Perform testing and validation cycles on databases, ETLs, and data cubes.
• Design and develop dashboards, reports, and ad-hoc reports while providing technical support to end users.

Required Skills

• 5+ years of experience in data modeling, data management, and data transformation.
• 5+ years of experience with SQL Server (2008 and above) and advanced SQL technologies.
• 5+ years of experience developing OLTP and OLAP databases.
• 5+ years of experience with data warehousing, Integration Services, Analysis Services, and Reporting Services.
• 5+ years of experience with Dimensional Modeling (star schema, snowflake schema, data cubes).
• 5+ years of experience with SDLC support tools and techniques.
• 2+ years of experience developing using XML, HL7, Schematron, JSON, and XPath.
• 2+ years of experience with medical data standards including ICD10, SNOMED, and RxNorm.
• 2+ years of experience developing reports using SAS/SPSS.
• 2+ years of experience with state government change management and security standards.
• Bachelor’s Degree required.

Key Skills

Education

Bachelor’s Degree