Description

You will own complex data analysis, dimensional modeling, and enterprise data governance initiatives.

This role is remote.

Responsibilities

• Develop and maintain SQL and T-SQL queries for reporting, analytics, and operational analysis.
• Design and implement dimensional models, star schemas, and source-to-target mappings.
• Establish and operationalize MDM frameworks for Person, Agency, Vehicle, and Member domains.
• Design Microsoft Purview governance frameworks including cataloging, lineage, and classification.
• Support data quality initiatives, validation reporting, and compliance with audit requirements.

Required Skills

• 5+ years of experience in data analysis, reporting, or business intelligence.
• Strong SQL and T-SQL development skills.
• Experience creating dimensional models and analytical data structures.
• Familiarity with Dataverse, Dynamics 365, and Power Platform integrations.
• Proficiency in Power BI or Tableau for reporting and visualization.
• Experience with data profiling, reconciliation, and validation activities.
• Bachelor's degree in a relevant field.

Preferred Skills

• Experience authoring Error Triage Protocols and structured resolution processes.
• Collaboration with SMEs across Risk, Benefits, Fiscal, HR, and IT divisions.
• Support for migration validation and reconciliation testing.

Key Skills

Education

Bachelor's degree