Data Analyst
The Actuarial Systems Data & Reporting team is looking for a Business Intelligence Analyst to help support US actuarial reporting, data analysis, and reporting modernization work.
The Actuarial Systems Data & Reporting team is looking for a Business Intelligence Analyst to help support US actuarial reporting, data analysis, and reporting modernization work. This role will work closely with the US Reporting Steward, Actuarial teams, and Global Systems & Data partners to understand business needs, investigate data issues, and deliver practical reporting solutions.
The work will include querying and analyzing data using SQL, Qlik, and Power BI; improving existing reports and controls; and helping build new solutions that support Quarter-end and Year-end valuation processes. The role will also help manage change requests by supporting intake, prioritization, tracking, and follow-up through JIRA.
Position Responsibilities:
Technical (Data, Analytics, and Reporting)
• Write, review, and optimize SQL queries to pull, transform, and validate large datasets from warehouse and data lake environments • Review Quarter-end and Year-end valuation data to identify trends, explain variances, and investigate data anomalies • Build and maintain data models that support QlikView and Power BI reporting • Create and improve dashboards used for reporting, reconciliations, and variance analysis • Validate and reconcile data across source systems, reporting layers, and downstream outputs • Help automate recurring data checks and controls to improve accuracy and reduce manual effort • Troubleshoot data issues by tracing logic across ETL steps, source data, and reporting dependencies • Support SIT and UAT by validating results, documenting findings, and confirming that business requirements are met • Document data lineage and source-to-target mappings so logic is clear, traceable, and audit-ready • Work with platforms such as Azure SQL, Data Lake, and Databricks as part of reporting and data analysis work • Use Python where helpful for analysis, automation, or repeatable data checks
Project / Change Management / Coordination
• Work with business and technical teams to turn reporting needs into clear, actionable requirements • Help manage enhancement requests in JIRA, including intake, prioritization, tracking, and follow-up • Participate in Agile ceremonies such as backlog refinement, sprint planning, and status updates • Coordinate SIT and UAT activities with business users, developers, and other partners • Communicate data issues clearly, explain the impact, and help identify practical next steps • Support release readiness, deployment validation, and post-release checks • Look for opportunities to simplify reporting processes, reduce manual work, and improve controls • Keep documentation current for requirements, testing, decisions, and governance needs
Required Qualifications:
Posted July 27, 2026