Job Description:

• 3+ years of experience in the analysis, design, documentation, build and maintenance of complex data models in a data warehouse environment required.
• Strong background in health care source systems evaluation and data profiling.
• Knowledgeable in Data Modeling software (i.e. ER Studio, Erwin), Microsoft SQL Server
• Expertise in relational and dimensional data model design for Data Warehouse and Business Intelligence environments, including the ability to design and execute data models using industry best practice approaches for extensibility, ease of use, and performance in the Microsoft SQL Server / BI Stack environment.
• Expertise in source systems data structures, transaction systems processing events, and change data capture practices.
• Expertise in problem-solving with the ability to profile and analyze various data sources leading to solutions to complex data related issues.
• Ability to translate business needs into technical solutions. Expertise in communicating and collaborating on the design and physical implementation of data models with the Data Architect and Database Administrator.
• Other data warehousing and business intelligence skills include working knowledge of: SDLC practices, BI reporting concepts, server and database environment management, data warehouse and BI architecture, data cleansing and data quality management, ETL processing, data governance, master data management.
• Working knowledge of Managed Care information systems including QNXT and associated health care specific subject areas for Medical and Pharmacy Claims, Membership, Enrollment, Providers, etc. is strongly preferred.