Data Analyst (Data Governance)

About the position Milliman is undertaking a major business transformation program to replace and modernize our HRIS, Finance, Legal, and Professional Services Automation systems. As part of the Data Enablement Team, we are seeking a skilled Data Analyst to play a critical role in ensuring the integrity, quality, and seamless migration of data throughout this transformation. This role will collaborate closely with business and technical teams, supporting data mapping, migration, validation, and integration activities to enable a smooth transition to new enterprise platforms.

Responsibilities

• Collaborate with business stakeholders to gather and document requirements for prioritized data domains, ensuring a clear understanding of business needs.
• Profile data and analyze source systems and data structures to assess content, quality, and structure, supporting accurate mapping and migration processes of master data and data hub models.
• Develop comprehensive data mapping documents, including source-to-target specifications and transformation logic.
• Work with Master Data Management (MDM) and integration teams to validate mappings and ensure alignment with enterprise data models.
• Support workshops and working sessions to refine business rules, data definitions, and domain onboarding plans.
• Assist in identifying data quality issues and contribute to metadata and lineage documentation.
• Create and maintain data catalogs to ensure consistent documentation, easy discovery, and effective management of enterprise data assets.
• Coordinate with platform subject matter experts (SMEs) to ensure mappings are compatible with MDM, data hub, and integration platform configurations.
• Track mapping progress, dependencies, and issues across teams and tools, providing timely updates and resolving blockers.
• Collaborate with business stakeholders and project teams to understand data requirements for HR, Finance, Legal, and Professional Services functions.
• Analyze and document existing data sources, structures, and business rules within legacy systems.
• Develop data mapping specifications to ensure accurate migration to new systems.
• Support the extraction, transformation, and loading (ETL) of data, including profiling, cleansing, and validating migrated data.
• Perform data quality assessments and implement data validation processes to ensure completeness and accuracy.
• Assist in designing and testing data integrations between new enterprise platforms and other business applications.
• Create and maintain comprehensive documentation of data models, flows, and transformation rules.
• Identify and resolve data-related issues during migration and post-implementation.
• Provide regular updates and insights to project leaders and stakeholders regarding data migration progress and risks.
• Support ongoing data governance and quality initiatives as new systems are adopted.

Requirements

• Bachelor’s degree in computer science, Information Systems, Data Analytics, or a related field.
• Minimum 5 years of experience in a data analyst or similar data-focused role, preferably supporting large-scale system implementations or migrations.
• Previous experience with data analysis, data profiling, data mapping, and ETL processes.
• Hands-on experience with SQL, Python and working with relational databases.
• Previous experience with data migration and data integration tools.
• Excellent analytical skills with the ability to interpret and translate business requirements into technical specifications.
• Strong attention to detail and commitment to data quality.
• Effective verbal and written communication skills, with the ability to collaborate across business and technical teams.
• Ability to manage multiple tasks and priorities in a fast-paced project environment.

Nice-to-haves

• Experience with HRIS, Finance, Legal, or Professional Services Automation systems.
• Experience with cloud-based data platforms (e.g., AWS, Azure, Google Cloud).
• Familiarity with data governance and data quality best practices.
• Experience in the insurance, risk management, or financial services sectors.
• Knowledge of regulatory requirements related to data privacy and security.

Benefits

• Medical, Dental and Vision – Coverage for employees, dependents, and domestic partners
• Employee Assistance Program (EAP) – Confidential support for personal and work-related challenges
• 401(k) Plan – Includes a company matching program and profit-sharing contributions.
• Discretionary Bonus Program – Recognizing employee contributions
• Flexible Spending Accounts (FSA) – Pre-tax savings for dependent care, transportation, and eligible medical expenses
• Paid Time Off (PTO) – Begins accruing on the first day of work. Full-time employees accrue 15 days per year, and employees working less than full-time accrue PTO on a prorated basis
• Holidays – A minimum of 10 paid holidays per year
• Family Building Benefits – Includes adoption and fertility assistance
• Paid Parental Leave – Up to 12 weeks of paid leave for employees who meet eligibility criteria
• Life Insurance & AD&D – 100% of premiums covered by Milliman
• Short-Term and Long-Term Disability – Fully paid by Milliman