Senior Data Modeler
Jimmy Technologies
WorldwideremotePosted 7 days ago
J
Skill Required
Data-ModelerData-ArchitectData-Warehouse-DeveloperHealth-Data-AnalystBI-Data-EngineerData-Modeling-EngineerData-Modeling-SpecialistData-Model-ArchitectQuery Optimizationdata engineeringtroubleshootingBusiness AnalysisEngineeringSnowflakedebugginganalyticsbuildingdesignjQuerySQLandContract
Key highlights
- Senior Data Modeller role for a Fortune 500 company
- Building analytics-ready data architectures for a healthcare client
- Kimball methodology expertise required (star/snowflake schemas, SCDs)
- Specialized focus on Healthcare Encounters data
- Remote-first long-term contract with US time zone overlap (2-6 PM CET)
- Consultancy mindset expected for client solutions
Role overview
Our partner, a Fortune 500 company, is building scalable, analytics-ready data architectures for a client in the healthcare sector. They are seeking a Senior Data Modeller to design and maintain dimensional data models using Kimball methodology that power reporting and analytics at scale.
Responsibilities
- Design and maintain data models using Kimball methodology (star and snowflake schemas, fact and dimension tables, SCDs)
- Model Healthcare Encounters data, ensuring accuracy and alignment with business and regulatory requirements
- Develop and optimize complex queries for data extraction, transformation, and validation
- Collaborate with data engineering teams to implement models within the data warehouse/lakehouse environment
- 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 ensure models support downstream reporting needs
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
Nice to have
- Have a consultancy mindset → always try to find a solution for the client
Additional details
- Long-term, remote-first contract position with required US working hours overlap (2-6 PM CET, ideally until 7 PM CET)
- Contract with EU LLC
- Start Date: ASAP
- Role focused on Healthcare Encounters data
- Building scalable, analytics-ready data architectures for a healthcare sector client