Senior Data Modeler

Jimmy Technologies; United States; Remote; USD 120,000 - 180,000; Full time

Job summary

Our partner, a Fortune 500 company, is building scalable analytics-ready data architectures for healthcare. We seek a Senior Data Modeller to design and maintain Kimball dimensional models powering reporting and analytics, including Encounters data.

You will translate requirements for data warehouses/lakehouses and collaborate across data engineers, BI, and business stakeholders. Expect a remote-first, long-term contract with US working hours overlap (2-6 PM CET).

Qualifications

• Healthcare Encounters data knowledge and regulatory awareness.
• Strong Kimball dimensional modeling background (star/snowflake, facts/dimensions, SCDs).
• Advanced SQL, data profiling, and query optimization for large datasets.

Responsibilities

• Design and maintain Kimball dimensional models (star/snowflake).
• Model Healthcare Encounters data to support reporting and analytics.
• Develop and optimize complex SQL for ETL, extraction, and validation.
• Collaborate with data engineers, BI teams, and stakeholders to implement models.
• Document data models, dictionaries, and mappings, ensuring data quality.

Skills

Kimball modeling

SQL skills

Data modeling

Healthcare data

Job description

Our partner, a Fortune 500 company , is building scalable, analytics-ready data architectures for a client in the healthcare sector. We're looking for a Senior Data Modeller to design and maintain dimensional data models using Kimball methodology that power reporting and analytics at scale. You'll translate business requirements into well-structured logical and physical models, working closely with data engineers, BI teams, and business stakeholders — with particular emphasis on healthcare Encounters data. This is a long-term, remote-first contract position with required US working hours overlap (2-6 PM CET).

Responsibilities

• Dimensional modeling: design and maintain data models using Kimball methodology (star and snowflake schemas, fact and dimension tables, SCDs).
• Healthcare Encounters data: model Encounters data, ensuring accuracy and alignment with business and regulatory requirements.
• Advanced SQL: develop and optimize complex queries for data extraction, transformation, and validation.
• Implementation: collaborate with data engineering teams to implement models within the data warehouse/lakehouse environment.
• Data quality: perform data profiling, quality checks, gap analysis, and troubleshooting across source and target systems.
• Documentation: maintain data models, data dictionaries, and mapping specifications.
• BI enablement: partner with BI and analytics teams to ensure models support downstream reporting needs.

Work Conditions

• Type: Full-time & Long-term contract work
• Start Date : ASAP
• Location : Remote
• US Time Zone Overlap : Required ( 2 PM - 6 PM CET , ideally until 7 PM CET)
• Contract with EU LLC Requirements
• Healthcare industry experience — including hands-on knowledge of Encounters data.
• Experience working with claims, member, or provider data in a healthcare payer (health insurer) or provider setting.
• Strong Kimball dimensional modeling background — star/snowflake schemas, fact and dimension tables, slowly changing dimensions (SCDs).
• Advanced SQL skills — complex query writing, performance tuning, debugging, and data profiling across large datasets.
• Proven ability to design logical and physical data models for data warehouses/lakehouses optimized for reporting and analytics.
• Excellent problem-solving skills and keen attention to detail.
• Ability to collaborate with cross-functional teams and lead technical discussions with data engineers, BI teams, and business stakeholders.
• Have a consultancy mindset always try to find a solution for the client

Highlights If you are passionate about Data Modeling , SQL , Healthcare data , and building analytics-ready data warehouses , this role with our client offers an exciting opportunity to shape healthcare analytics!

Originally posted on Himalayas