Data Analyst (Data Governance)

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., * 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., Through a team of professionals ranging from actuaries to clinicians, technology specialists to plan administrators, we offer unparalleled expertise in employee benefits, investment consulting, healthcare, life insurance and financial services, and property and casualty insurance.

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

SKILLS & QUALIFICATIONS PREFERRED:

• 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.

The overall salary range for this role is $78,800 - $145,130. For candidates residing in:

• Alaska, California, Connecticut, Illinois, Maryland, Massachusetts, New Jersey, New York City, Newark, San Jose, San Francisco, Pennsylvania, Virginia, Washington, or the District of Columbia the salary range is $90,620 - $145,130
• All other locations the salary range is $78,800 - $126,200, We offer a comprehensive benefits package designed to support employees’ health, financial security, and well-being. Benefits include:
• 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

Independent for over 75 years, Milliman delivers market-leading services and solutions to clients worldwide. Today, we are helping companies take on some of the world’s most critical and complex issues, including retirement funding and healthcare financing, risk management and regulatory compliance, data analytics and business transformation.