Senior Azure Data Engineer Insurance/Reinsurance Analytics

• Azure Data Factory (ADF), Azure Databricks, Azure Analysis Services (SSAS)
• Azure Data Lake Analytics, Azure Data Lake Store (ADLS)
• Azure Integration Runtime, Azure Event Hubs, Azure Stream Analytics
• DBT (Data Build Tool)

Databases:

• Azure SQL
• MongoDB
• PySpark

• Proven experience in implementing Microsoft BI/Azure BI solutions including ADF, Databricks, SSAS, SSIS, and SSRS.
• Strong understanding of Azure Big Data technologies (ADLS, ADF, Data Lake Analytics) and data movement using U-SQL jobs.
• Expertise in data warehouse development from inception to deployment, using normalization and denormalization techniques.
• Experience developing data lake layers (staging, bronze, silver, gold) for structured and unstructured data ingestion and curation.
• Skilled in developing notebooks in Databricks to support ETL workflows and data transformation.
• Experienced in building and deploying Azure Analysis Services tabular models and automating scheduling using Azure Automation Runbooks.
• Deep knowledge in developing SSAS cubes (tabular and multidimensional), aggregations, KPIs, partitions, and data mining models.

Preferred Domain Knowledge (Insurance/Reinsurance):

• Familiarity with reinsurance broking data including placements, treaty structures, client hierarchies, and renewals.
• Understanding of actuarial rating data inputs and outputs exposures, experience data, layers, and tagging structures.
• Experience building data pipelines that support actuarial models, pricing tools, and client-facing reporting.

Soft Skills & Team Collaboration:

• Strong analytical and interpersonal skills with a clear understanding of the Software Development Life Cycle (SDLC).
• Experience working in Agile/SCRUM methodologies.
• Proven ability to work independently and collaboratively to meet business objectives.
• Effective communication and technical documentation skills.
• Excellent decision-making ability in high-pressure or complex situations.

Must-Have Qualifications:

• 5 years of experience with Microsoft Azure BI and Big Data technologies.
• Demonstrated experience with Azure Data Factory, Databricks, and SSAS.
• Hands-on in ETL design and development, especially across heterogeneous systems.
• Practical knowledge of data warehouse architecture and multi-layer data lake modeling.
• Experience in the insurance or actuarial domain is a strong advantage.