​This is a full-time, remote Data Analyst role at Milliman, focused on supporting a major business transformation program to modernize HRIS, Finance, Legal, and Professional Services Automation systems. The analyst is a critical member of the Data Enablement Team, ensuring data integrity, quality, and seamless migration through data profiling, mapping, validation, and integration.

• ​Location: Remote (Designated location: Chicago, IL).
• ​Salary Range: $78,800 – $145,130 (specific range depends on candidate location).
• ​Experience Required: Minimum 5 years of experience in a data analyst or similar data-focused role, preferably supporting large-scale system implementations or migrations.
• ​Focus: Data profiling, mapping, ETL support, data quality, metadata/lineage documentation, and supporting data governance during a major enterprise platform overhaul (HRIS, Finance, Legal, PSA).
• ​Technical Skills: Hands-on experience with SQL, Python, and relational databases.

​Responsibilities: Data Integrity and Migration Lifecycle

​The analyst collaborates closely with business and technical teams across the entire data lifecycle for the migration, from initial profiling through post-implementation governance.

• ​Data Analysis & Profiling: Profile data and analyze source systems and data structures to assess content, quality, and structure, supporting accurate mapping and migration processes. Analyze and document existing data sources, structures, and business rules within legacy systems.
• ​Data Mapping & Transformation: Develop comprehensive data mapping documents, including source-to-target specifications and transformation logic. Ensure mappings are compatible with MDM, data hub, and integration platform configurations.
• ​ETL and Validation: 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.
• ​Documentation & Governance: Create and maintain data catalogs for consistent documentation and easy discovery. Assist in identifying data quality issues and contribute to metadata and lineage documentation.
• ​Integration Support: Assist in designing and testing data integrations between new enterprise platforms and other business applications.
• ​Stakeholder Collaboration: Collaborate with business stakeholders to gather requirements, refine business rules, and communicate data requirements for HR, Finance, Legal, and Professional Services functions.
• ​Issue Resolution: Track mapping progress, dependencies, and issues, providing timely updates and resolving blockers.

​Required Skills and Qualifications

​The successful candidate needs deep technical familiarity with data management practices and strong soft skills for collaboration within a major project environment.

• ​Experience: Minimum 5 years in a data analyst or similar role, with previous experience with data analysis, data profiling, data mapping, and ETL processes.
• ​Technical Tools: Hands-on experience with SQL, Python, and working with relational databases. Previous experience with data migration and data integration tools.
• ​Soft Skills: Excellent analytical skills with the ability to interpret and translate business requirements into technical specifications. Effective verbal and written communication, with the ability to collaborate across business and technical teams.
• ​Preferred Skills:
  • ​Experience with HRIS, Finance, Legal, or Professional Services Automation systems.
  • ​Familiarity with data governance and data quality best practices.
  • ​Experience with cloud-based data platforms (e.g., AWS, Azure, Google Cloud).