LHH is working with a client based in Midtown Manhattan and Princeton, NJ that is looking to hire a Sr./Lead Azure Data Engineer to join our team for a 6+ month project (very strong possibility of extension). The role will require 3 days onsite at either their Midtown Manhattan office, Princeton, NJ, or a combination of both.

• Candidates MUST be local to the NY/NJ/CT area to be considered for this role or can easily relocate upon offer. Candidates MUST be willing to work as a W2 employee of LHH to be considered (No C2C Please).

Candidates should have at least 5-10 YOE to be considered. Required property/reinsurance insurance experience required. Data experience needed, need someone to understand catastrophe modeling, premium losses/limits/deductibles/terminology. Business Domaine Knowledge Work close with the product owning, document mapping, and doing data engineering when timing allows. Work close with dev ops and determine if data is needed and/or moved to the cloud. A lot of opportunity to build this application from ground up – designing and making a big difference in the actions. All work is mainly in the Azure space.

Technical Skills:

Business Intelligence: 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

Database Technologies: Azure SQL, MongoDB, PySpark

Experience Required:

Data Engineering

Experience in implementing Microsoft BI/Azure BI solutions like Azure Data Factory, Azure Databricks, Azure Analysis Services, SQL Server Integration Services, SQL Server Reporting Services. Strong Understanding in Azure Big data technologies like Azure Data Lake Analytics, Azure Data Lake Store, Azure Data Factory and in moving the data from flat files and SQL Server using U-SQL jobs.

• Expert in data warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles using Normalization and De-Normalization techniques. Experience in developing staging zone, bronze, silver and gold layers of data


• Good knowledge in implementing various business rules for Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous Systems using Azure Data Factory (ADF).


• Developed notebooks for moving data from raw to stage and then to curated zones using Databricks.


• Involved in developing complex Azure Analysis Services tabular databases and deploying the same in Microsoft azure and scheduling the cube through Azure Automation Runbook.


• Extensive experience in developing tabular and multidimensional SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, deploying and Processing SSAS objects.

Domain Knowledge (Preferred)

Experience with actuarial tools or insurance is preferred. The intent is familiarity with the data terminologies and the hierarchy of data in the Insurance domain, specifically in the below areas

• Familiarity with reinsurance broking data, including placements, treaty structures, client hierarchies, and renewal workflows.


• Understanding of actuarial rating inputs and outputs, including exposure and experience data, layers, tags, and program structures.


• Experience building data pipelines that support actuarial analytics, pricing tools, and downstream reporting for brokers and clients.

Team skills

• Team builder with strong, analytical & interpersonal skills with good knowledge in Software Development Life Cycle (SDLC) and Proficient in technical writing.


• Experience in Agile software development and SCRUM methodology.


• Ability to work independently and as part of a team to accomplish critical business objectives as well as good decision-making skills under high pressure complex scenarios

Benefit offerings available for our associates include medical, dental, vision, life insurance, short-term disability, additional voluntary benefits, EAP program, commuter benefits and a 401K plan. Our benefit offerings provide employees the flexibility to choose the type of coverage that meets their individual needs. In addition, our associates may be eligible for paid leave including Paid Sick Leave or any other paid leave required by Federal, State, or local law, as well as Holiday pay where applicable.

Equal Opportunity Employer/Veterans/Disabled

To read our Candidate Privacy Information Statement, which explains how we will use your information, please navigate to https://www.lhh.com/us/en/candidate-privacy

The Company will consider qualified applicants with arrest and conviction records in accordance with federal, state, and local laws and/or security clearance requirements, including, as applicable:

• The California Fair Chance Act
• Los Angeles City Fair Chance Ordinance
• Los Angeles County Fair Chance Ordinance for Employers
• San Francisco Fair Chance Ordinance