Macpower Digital Assets Edge
Senior Azure Data Engineer - Insurance/Reinsurance Analytics
Macpower Digital Assets Edge, Princeton, New Jersey, us, 08543
Job Summary:
We are seeking a highly skilled
Senior Azure Data Engineer
with deep expertise in Azure BI technologies and strong experience in data engineering and data warehouse development. The ideal candidate will be well-versed in Microsoft Azure data services and have a working knowledge of insurance or actuarial data, particularly in the reinsurance and analytics space. This role requires an individual capable of driving end-to-end data solutions from ingestion to insights while collaborating in an Agile team environment. Location: Princeton, NJ (Hybrid - 3 Days Onsite Per Week)
Technical Skills Required: Business Intelligence & Big Data: zure Data Factory (ADF), Azure Databricks, Azure Analysis Services (SSAS) zure Data Lake Analytics, Azure Data Lake Store (ADLS) zure Integration Runtime, Azure Event Hubs, Azure Stream Analytics DBT (Data Build Tool) Databases:
zure 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
zure 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
ctuarial 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
gile/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
zure 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.
We are seeking a highly skilled
Senior Azure Data Engineer
with deep expertise in Azure BI technologies and strong experience in data engineering and data warehouse development. The ideal candidate will be well-versed in Microsoft Azure data services and have a working knowledge of insurance or actuarial data, particularly in the reinsurance and analytics space. This role requires an individual capable of driving end-to-end data solutions from ingestion to insights while collaborating in an Agile team environment. Location: Princeton, NJ (Hybrid - 3 Days Onsite Per Week)
Technical Skills Required: Business Intelligence & Big Data: zure Data Factory (ADF), Azure Databricks, Azure Analysis Services (SSAS) zure Data Lake Analytics, Azure Data Lake Store (ADLS) zure Integration Runtime, Azure Event Hubs, Azure Stream Analytics DBT (Data Build Tool) Databases:
zure 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
zure 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
ctuarial 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
gile/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
zure 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.