Senior Data Modeler

Jimmy Technologies

. Design and maintain dimensional data models using Kimball methodology, including star and snowflake schemas, fact and dimension tables, and SCDs .

Posted 10/14/2026full-timeRemote • CzechiaSenior💰 €35 - €42 per hourWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and maintaining dimensional data models using Kimball methodology, with a strong focus on healthcare data, including Encounters data and claims processing workflows. Proficient in advanced SQL for data extraction and transformation, while collaborating effectively with cross-functional teams to support reporting and analytics.

Highest-signal resume keywords

Kimball Dimensional ModelingAdvanced SQL SkillsHealthcare Industry ExperienceData Warehouse/Lakehouse DesignData Profiling and Quality Checks

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Dimensional Data ModelingSQL Query DevelopmentData Extraction and TransformationData ValidationData ProfilingGap AnalysisFact and Dimension TablesSlowly Changing Dimensions (SCDs)Performance TuningData Mapping Specifications

Soft Skills

Problem-Solving SkillsAttention to DetailCollaborationConsultancy MindsetSolution-Oriented Approach

Industry Keywords

Healthcare Data StandardsClaims Processing WorkflowsPayer/Provider Data StructuresBusiness IntelligenceAnalytics

Tech Stack

Tools & technologies

SQL

About the role

Key responsibilities & impact

Design and maintain dimensional data models using Kimball methodology, including star and snowflake schemas, fact and dimension tables, and SCDs
Model healthcare Encounters data accurately and align it with business and regulatory requirements
Develop and optimize complex SQL queries for data extraction, transformation, and validation
Collaborate with data engineering teams to implement models in data warehouse/lakehouse environments
Perform data profiling, quality checks, gap analysis, and troubleshooting across source and target systems
Maintain data models, data dictionaries, and mapping specifications
Partner with BI and analytics teams to support downstream reporting needs

Requirements

What you’ll need

Healthcare industry experience, including hands-on knowledge of Encounters data (must-have)
Experience working with claims, member, or provider data in a healthcare payer or provider setting (must-have)
Strong Kimball dimensional modeling background, including star/snowflake schemas, fact and dimension tables, and slowly changing dimensions (SCDs)
Advanced SQL skills, including 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
Familiarity with healthcare data standards, claims processing workflows, and payer/provider data structures is a strong plus
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
Consultancy mindset and solution-oriented approach

Benefits

Comp & perks

Long-term contract position
Remote-first work arrangement
Required US working hours overlap (2–6 PM CET, ideally until 7 PM CET)