Data Engineer - Data Modeling, Governance & Quality

Required Skills & Experience

Advanced SQL and Microsoft SQL Server experience.

Strong relational and dimensional data modeling capabilities.

Experience with ETL/ELT, ODS and enterprise data warehouse solutions.

Experience defining data quality rules, reconciliations and source-to-target mappings.

Ability to translate business concepts into scalable technical data models.

Strong collaboration, documentation and problem-solving skills.

Nice to Have Skills & Experience

Databricks, Python, PySpark or Spark experience.

Experience implementing data governance, metadata, lineage or data catalog practices.

Experience with automated data quality frameworks.

Experience in a SOX-controlled or regulated environment.

Property and casualty insurance industry knowledge, including policy, billing, claims or underwriting data, is a strong plus.

Experience working with Guidewire applications or data, including Guidewire ClaimCenter (GWCC), Guidewire BillingCenter (GWBilling) or related policy systems.

Experience designing governed, feature-ready data for predictive modeling or machine learning.

Understanding of quality, lineage, privacy and control considerations for analytical models and AI solutions.

Familiarity with generative AI, LLMs, RAG, vector data or unstructured data governance.

Job Description

We are seeking a Senior Data Engineer with strong data modeling, governance and data quality capabilities to transform a fragmented data estate into a trusted enterprise foundation. This role will design ODS and DWH models, establish consistent data definitions and quality controls, and ensure that governance and SOX requirements are incorporated into both the current SQL Server environment and the future Databricks platform. pay ranges from $60-68/hr based on years of experience.