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