Senior Data Analyst Must Have (Master Data Management)

Overview

Hybrid
$50 - $60
Full Time

Skills

Azure
MDM
Master Data Management
SQL
CRM
Database
Data Warehouse
Db2
MongoDB

Job Details

Data Analyst 10+ years of experience (MDM Must)
Columbia, TN
Long Term

Job Summary:

We are seeking a highly experienced Data Analyst with 10+ years of experience in the insurance domain. We are initiating a Data Warehouse implementation project for a leading insurance client. The goal is to design and build a centralized Data Warehouse (DWH) in the Azure data ecosystem to consolidate insurance quote data sourced from multiple systems including Db2, SQL Server, and MongoDB.

The DWH will serve as a unified analytical and operational data store, with downstream integrations into an MDM (Master Data Management) solution for customer and policy master data synchronization.

Role Summary

The Data Analyst will play a key role in analyzing, validating, and transforming data to support the design and implementation of the new Azure-based Data Warehouse. The ideal candidate will have hands-on experience with Azure data services, strong analytical skills, and familiarity with MDM systems and data quality processes.

Key Responsibilities:

  • Collaborate with business stakeholders and technical teams to elicit, document, and validate data requirements for the Data Warehouse (DWH).
  • Analyze source systems (Db2, SQL Server, MongoDB) to document data structures, quality, and transformation needs.
  • Define data mapping, transformation rules, and cleansing logic for integrating data from heterogeneous sources.
  • Identify data gaps, redundancies, and inconsistencies across multiple insurance data sources.
  • Implement data quality checks, deduplication, and harmonization processes for MDM alignment.
  • Participate in defining data marts, aggregations, and data hierarchies for insurance quotes, policy, and customer data.
  • Lead the team as one of the product owners driving the project from start to finish.

Required Qualifications:

  • 10+ years of professional experience in data analysis, reporting, or related roles.
  • Insurance industry experience, specifically with policies, quotes, claims, or related domains.
  • Strong experience with CRM systems and MDM platforms, supporting data integration and quality initiatives.
  • Proven ability to analyze, model, and validate data for data warehouse and analytics projects.
  • Familiarity with SQL.
  • Experience with different DB technologies like Relational and Non-Relational.
  • Expertise in data transformation, cleansing, and preparation for reporting and analytics.
  • Ability to work independently while guiding stakeholders on data requirements, quality, and insights.
  • Willingness to relocate or travel as required.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.