AXA XL
|Business Intelligence Developer
Hartford, Connecticut, US
Summary
Developed and optimized robust ETL pipelines and Power BI solutions to enhance actuarial risk modeling, broker performance analysis, and data privacy for global underwriting teams.
Highlights
Architected end-to-end ETL pipelines using PySpark and Databricks to process high-velocity insurance records, ensuring real-time data availability for actuarial risk modeling.
Designed a suite of Power BI dashboards with Conversational BI principles, automating performance tracking and reducing manual reporting overhead by 12%.
Developed a broker performance scoring engine by extracting data from Axiom and applying a 4-criteria analytical framework that improved underwriting focus by 10%.
Optimized complex DAX measures and SQL queries, reducing report loading times by 30% for global underwriting teams.
Automated data quality auditing within PySpark ETL pipelines, identifying and flagging 95% of ingestion anomalies before reaching the actuarial modeling layer.