Senior Data Modeller [ul375]

As a Senior Data Modeller, you will bridge the gap between complex business requirements and technical execution. You will lead the design of logical and physical models within a remote-first, collaborative engineering environment, ensuring our data warehouse remains optimized for advanced reporting.

Tech Stack

• Core Stack: Kimball methodology, Star schema, Snowflake schema, Fact and dimension table modeling, Slowly changing dimensions (SCDs)
• Data & SQL: Advanced SQL, Query optimization, Data profiling, Data quality troubleshooting, Data dictionaries, Mapping specifications
• Domain Specifics: Healthcare Encounters data, Medical claims, Member encounters, Provider interactions, Payer/provider data structures
• Tools & Documentation: Mermaid, Data modeling tools, Data warehouse/lakehouse environments

What You’ll Do

• Architect and maintain robust dimensional data models using Kimball methodology to support large-scale healthcare analytics.
• Design specialized structures for Encounters data, ensuring alignment with healthcare regulatory requirements and claims processing workflows.
• Develop and tune complex SQL queries to ensure high performance across massive, distributed datasets.
• Perform rigorous data profiling and gap analysis to resolve quality issues across source and target systems.
• Collaborate with Data Engineers to implement physical models and partner with BI teams to ensure downstream reporting accuracy.
• Document technical specifications, including data dictionaries and Mermaid diagrams, to maintain architectural clarity.

• Extensive experience in dimensional modeling (Star/Snowflake schemas) and managing SCDs.
• Mastery of SQL for extraction, transformation, and performance tuning.
• Deep domain expertise in Healthcare data, specifically with medical claims, member, or provider datasets.
• Proven ability to translate ambiguous business needs into structured logical and physical data models.
• Strong analytical mindset with a focus on data integrity and engineering best practices., * SQL: 5 years (required)
• Data modelling: 5 years (required)

• Attractive salary
• Large freedom and real influence
• No unhealthy competition, team approach to meeting challenges
• Remote-first, flexible working culture
• Company apartments in cool cities across Europe: work and enjoy a memorable getaway

We are a software house with 18 years of experience and a global portfolio of projects. We help businesses modernize, scale, and innovate through custom software solutions. Our team embraces unconventional ideas and new technologies, delivering solutions with real impact. If you value professionalism, creativity, and a strong engineering culture, you’ll feel at home here.