Data Engineer (13494-1) Princeton, NJ

ESR Healthcare; Princeton (NJ); On-site; USD 100,000 - 130,000; Full time

Job summary

A leading company in the insurance sector is seeking a Data Engineer in Princeton, NJ. This role involves developing data integration solutions and working with various Azure technologies to enhance data processing and analysis capabilities. The ideal candidate will have extensive experience in data engineering principles, particularly within the insurance domain, and demonstrate strong interpersonal and analytical skills.

Qualifications

• 10 years of experience in data engineering.
• Strong understanding of Microsoft BI/Azure BI solutions.
• Bachelor's degree required.

Responsibilities

• Develop data pipelines and implement data integration solutions.
• Design and develop SSAS tabular databases and deploy in Azure.
• Execute ETL processes using Azure Data Factory.

Skills

Business Intelligence

Data Engineering

Data Warehouse Development

Analytical Skills

Education

Bachelor’s Degree

Tools

Azure Data Factory

Azure Databricks

SQL Server

MongoDB

PySpark

Job description

Data Engineer (13494-1) Princeton, NJ

Microsoft BI/Azure BI solutions like Azure Data Factory, Azure Databricks, Azure Analysis Services, SQL Server Integration Services, SQL Server Reporting Services,

If you post this job on a job board, please do not use company name or salary.
Experience level: Mid-senior Experience required: 10 Years Education level: Bachelor’s degree Job function: Information Technology Industry: Insurance Pay rate : View hourly payrate Total position: 1 Relocation assistance: No Visa sponsorship eligibility: No
Role : Data Engineer

Location: Princeton 3 days a week

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
Metarisk: