Senior Data Modeler (Level III)

Senior Data Modeler (Level III)

Req #: GNWJP00000882
Location: Remote (U.S.)
Duration: Contract (04/01/2026 - 12/31/2026)
Pay Rate: $62 - $66/hour (flexible for highly qualified candidates)
Employment Type: W2 Only
Eligibility:U.S. Citizens or Green Card Holders Only (No sponsorship / No C2C)

Overview

We are seeking a Senior Data Modeler to design and optimize scalable data models that power enterprise analytics and business intelligence. This role sits at the intersection of data architecture, analytics, and business strategy, translating complex data into actionable insights.

You will play a critical role in shaping data structures within a modern Lakehouse environment, enabling high-quality, governed, and performant data solutions across the organization.

Key Responsibilities

• Design conceptual, logical, and physical data models for analytics, reporting, and advanced data use cases
• Translate business requirements into scalable, high-performance data structures
• Partner with stakeholders, analysts, and engineers to define data requirements and solutions
• Develop and optimize schemas using medallion architecture (bronze/silver/gold layers)
• Integrate data across multiple sources ensuring accuracy, consistency, and reliability
• Establish and maintain data lineage, metadata, and data governance standards
• Support master data management (MDM) to create a single source of truth
• Optimize data models for performance, scalability, and usability
• Ensure compliance with data privacy, security, and regulatory standards
• Drive continuous improvement of data modeling practices and frameworks

Required Qualifications

• Bachelor's degree in Computer Science, Data Science, Information Systems, or related field
• 3+ years of data modeling experience in a Lakehouse or modern analytics environment
• Experience within the insurance industry (P&C, Life, or Healthcare)
• Strong expertise with data modeling tools (e.g., ER Studio)
• Hands-on experience with Databricks (Delta tables) and PostgreSQL
• Advanced proficiency in SQL and DDL development
• Experience with cloud platforms and big data technologies (Databricks, Spark, AWS, Azure)
• Strong understanding of data governance, metadata, and data quality frameworks

Preferred Qualifications

• Knowledge of PII/PHI data governance and security practices
• Experience working in Agile environments
• Familiarity with BI tools (Power BI, Spotfire)
• Understanding of insurance data models, taxonomies, and data quality challenges
• Experience with ETL processes and data lake architectures

Day-to-Day

• Collaborate with stakeholders to define analytics and reporting needs
• Design and document data models, relationships, and schemas
• Partner with engineering teams on data pipelines and integrations
• Validate and test data structures for accuracy and performance
• Maintain data dictionaries, lineage, and metadata repositories
• Support business users with data understanding and best practices
• Ensure alignment with governance, compliance, and quality standards

What Success Looks Like

• Delivering high-quality, scalable data models that drive business insights
• Enabling trusted, governed data across the organization
• Improving data accessibility, performance, and usability
• Effectively bridging business needs and technical solutions