Job Description
Note: The job is a remote job and is open to candidates in USA. Milliman is undertaking a major business transformation program to modernize various systems, and they are seeking a skilled Data Analyst to ensure the integrity and quality of data during this transition. The role involves collaborating with teams to support data mapping, migration, validation, and integration activities. 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. Skills • 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. • 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 • Employee Assistance Program (EAP) – Confidential support for personal and work-related • 401(k) Plan – Includes a company matching program and profit-sharing • Discretionary Bonus Program – Recognizing employee • 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 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 • Family Building Benefits – Includes adoption and fertility • Paid Parental Leave – Up to 12 weeks of paid leave for employees who meet eligibility • Life Insurance & AD&D – 100% of premiums covered by • Short-Term and Long-Term Disability – Fully paid by Company Overview • Milliman is a risk management, benefits, and technology firm that offers insurance and retirement services. It was founded in 1947, and is headquartered in Seattle, Washington, USA, with a workforce of 1001-5000 employees. Its website is Apply tot his job