Data Engineering (Hybrid - Princeton, NJ)

With roots dating back to the 1800s, our Customer is a global professional services firm HQ’d in New York City with businesses in insurance brokerage, risk management, reinsurance services, talent management, investment advisory, and management consulting. Today, they are a unique group of businesses with many enduring competitive advantages. Among them are the quality of their colleagues, deep client relationships, vast global footprint, depth of intellectual capital, and cohesive and collaborative culture.

We are seeking a contract Data Engineer with hands-on experience in building scalable Business Intelligence and Data Engineering solutions using Microsoft Azure technologies. This role is critical in supporting actuarial modernization and analytical platforms for enterprise-level insurance and reinsurance applications. This role is hybrid (3 days onsite, 2 days remote/week) in Princeton, NJ.

This position is within the Technology group of a global risk and reinsurance business, contributing to the development of actuarial modernization applications used by analysts and clients globally. The role is part of a product-centric technology team supporting data infrastructure for analytics and advisory functions.

Qualifications

• 10 years of experience
• Proven expertise in implementing Microsoft BI and Azure BI solutions, including ADF, Azure Databricks, Azure Analysis Services, SSIS, and SSRS.
• Strong understanding of big data solutions in Azure, especially ADF pipelines, U-SQL jobs, ADLS, and Data Lake Analytics.
• Proficient in designing and developing data warehousing systems and ETL processes using normalization and de-normalization techniques.
• Experience with developing data pipeline layers (staging, bronze, silver, and gold) to support enterprise-level analytics.
• Developed and maintained Databricks notebooks for moving data across pipeline layers.
• Hands-on experience creating and deploying complex Azure Analysis Services tabular models; leveraging Azure Automation for scheduling.
• Background in building tabular and multidimensional SSAS cubes, defining KPIs, measures, aggregations, and partitions.
• Familiarity with designing and implementing robust ETL pipelines using ADF to extract data from diverse sources.
• Exposure to insurance/reinsurance data models, especially reinsurance broking data (e.g., placements, treaty structures, client hierarchies), preferred.
• Familiarity with actuarial data elements, including rating inputs/outputs, exposure data, and experience datasets preferred.
• Experience building data pipelines to support actuarial models, pricing analytics, and downstream broker/client reporting tools preferred.
• Demonstrated ability to work effectively both independently and as part of a collaborative Agile/Scrum team.
• Strong interpersonal and analytical skills; experienced in cross-functional communication and technical documentation.
• Proficient in Agile methodologies and SDLC best practices.
• Effective in high-pressure environments requiring timely decision-making and complex problem-solving.

Technical Skills:

Business Intelligence Technologies:

• 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)

Database Technologies:

• Azure SQL
• MongoDB
• PySpark

We offer a competitive salary range for this position. Most candidates who join our team are hired at the median of this range, ensuring fair and equitable compensation based on experience and qualifications.

Contractor benefits are available through our 3rd Party Employer of Record (Available upon completion of waiting period for eligible engagements) Benefits include: Medical, Dental, Vision, 401k.

An Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability.