Data Engineer

Location: Princeton, NJ (Hybrid 3 days on-site)
Type: Long Term Contract

Hybrid, Long Term Contract opportunity supporting a client in the insurance and risk analytics sector. Seeking a highly skilled Data Engineer to lead Azure-based data architecture and support actuarial analytics and reporting functions. Ideal for professionals with deep experience in Microsoft BI, data warehousing, and Azure big data technologies.

• Architect and build scalable data pipelines using Azure Data Factory, Databricks, and SQL-based technologies.
• Design and implement data layers (staging, bronze, silver, gold) in a robust data lake architecture.
• Develop and schedule Azure Analysis Services tabular models and cubes via Automation Runbooks.
• Support business intelligence efforts through development of tabular/multidimensional SSAS cubes and custom reporting metrics (KPIs, partitions, data mining models).
• Translate business logic into ETL workflows across varied data sources and formats.
• Collaborate with cross-functional teams using Agile and SCRUM methodologies to support advanced analytics projects.

10+ years of experience in data engineering and business intelligence architecture.

Deep hands-on experience with Azure services including:

• Data Factory (ADF)
• Databricks
• Analysis Services (SSAS)
• Azure SQL and Data Lake tools
• Integration and Reporting Services (SSIS, SSRS)
• Proficient in building notebooks to support raw-to-curated data processing.
• Strong understanding of normalization/de-normalization and data warehouse design principles.
• Experience supporting actuarial systems, pricing models, and reporting workflows is a plus.

• Familiarity with reinsurance structures, client hierarchies, and analytics-ready data
• Experience developing tools that feed downstream broker reporting and actuarial pricing functions

No relocation assistance provided

Must be able to work onsite 3 days/week in Princeton, NJ