MD
Senior Azure Data Engineer – Insurance/Reinsurance Analytics
Macpower Digital Assets Edge Private Limited
🇺🇸 United States
On-site
Senior
5 days ago
$70 – $80 / hour
- Azure
- Agile
- Azure Data Factory
- Azure Databricks
- dbt
- Azure SQL
- MongoDB
- PySpark
- Databricks
- SSIS
- SSRS
- SQL
- ETL
- Scrum
5 days ago
Location: Princeton, NJ (Hybrid – 3 Days Onsite Per Week)
Technical Skills Required:
Business Intelligence & Big Data:
- 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)
- Azure SQL
- MongoDB
- PySpark
Experience Requirements:
- 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.
Senior Azure Data Engineer – Insurance/Reinsurance Analytics · Macpower Digital Assets Edge Private Limited