Senior Benefits Analyst

Reporting directly to the Director of Total Rewards we are seeking a highly disciplined and detail-oriented Senior Data Analyst to manage complex large-scale datasets supporting our Benefits operations. This role requires advanced Excel expertise a strong focus on data integrity and accuracy and the ability to navigate incomplete or messy data environments while building robust scalable processes.

This is an ideal role for someone who thrives in structured problem-solving demonstrates intellectual curiosity and is motivated to deeply understand systems data flows and benefits administrationeven without prior direct experience.

Why This Role

This role is ideal for someone who enjoys working behind the scenes to build strong data foundations values accuracy over speed and wants to grow expertise in benefits administration and cross-system data management.

Key Responsibilities

Data Management & Integrity

• Manage and maintain large complex datasets across multiple systems with a focus on completeness accuracy and redundancy.
• Build and maintain structured files and processes designed for scalability and repeatability.
• Develop and implement built-in data validation checks to ensure data accuracy and consistency.
• Identify troubleshoot and resolve data discrepancies across systems and platforms.
• Work effectively with imperfect or unclean data creating logic and controls to improve reliability.

Systems Integration & Coordination

• Support integrations and data flow between HRIS and other external platforms.
• Ensure smooth communication and reconciliation between systems with differing structures and data quality levels.

Analytics

• Utilize advanced Excel capabilities (e.g. complex formulas pivot tables Power Query data modeling) to analyze and transform data.
• Generate reports and insights as needed to support decision-making.

Learning & Continuous Improvement

• Develop a strong understanding of benefits administration (no prior experience required).
• Ask thoughtful probing questions to fully understand data systems and processes.
• Continuously seek opportunities to improve data quality processes and system integration.

Qualifications

• Bachelors Degree in Finance Engineering or other analytical programs
• 5 years experience in analytical data-focused role
• Advanced Excel skills (e.g. nested formulas data validation pivot tables macros/Power Query strongly preferred).
• Demonstrated experience managing large datasets with a high degree of accuracy.
• Strong attention to detail and commitment to data integrity.
• Experience working with incomplete inconsistent or dirty data.
• Structured process-oriented mindset with strong organizational discipline.
• Ability to work independently and drive clarity in ambiguous situations.

Preferred

• Exposure to HRIS systems and data integrations.
• Experience building data validation frameworks and audit controls.
• Familiarity with benefits administration (or strong willingness to learn quickly).

Success Profile

• Highly detail-oriented and methodical.
• Skilled problem solver who drives to discover and correct root cause issues.
• Curious and driven to deeply understand how systems and data work.
• Comfortable asking questions and challenging assumptions.
• Able to navigate complexity and ambiguity with a structured approach.
• Strong written and verbal communication skills particularly in translating data across systems and stakeholders.