Remote Excel Data Analyst Jobs in Schaumburg, IL

NOTE TO APPLICANTS: Individual(s) must be legally authorized to work in the United States without the need for immigration support or sponsorship from Milliman now or in the future

POSITION SUMMARY:

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.

SKILLS & QUALIFICATIONS REQUIRED:

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

LOCATION:

This is a remote role. The expected application deadline for this job is June 18th, 2026

COMPENSATION:

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

A combination of factors will be considered, including, but not limited to, education, relevant work experience, qualifications, skills, certifications, etc.

BENEFITS:

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

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

Milliman invests in skills training and career development and gives all employees access to a variety of learning and mentoring opportunities. Our growing number of Milliman Employee Resource Groups (ERG's) are employee-led communities that influence policy decisions, develop future leaders, and amplify the voices of their constituents. We encourage our employees to give back to their varied professions, including leadership in professional organizations. Please visit our web site (https://www.milliman.com/en/social-impact) to learn more about Milliman's commitments to our people, inclusion, and sustainability.

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.

EQUAL OPPORTUNITY:

All qualified applicants will receive consideration for employment, without regard to race, color, religion, sex, sexual orientation, national origin, disability, or status as a protected veteran.