Data Engineer

Intersources Inc.
Princeton, United States of America
7 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Junior

Job location

Princeton, United States of America

Tech stack

Agile Methodologies
Data analysis
Azure
Big Data
Databases
Information Engineering
ETL
Data Mining
Data Warehousing
Microsoft SQL Server
SQL Azure
MongoDB
Scrum
Power BI
Azure
Runbook
Software Engineering
SQL Server Reporting Services
SQL Server Integration Services
SQL Server Analysis Services
Data Streaming
Azure
Azure
PySpark
Cloud Integration
Stream Analytics
Data Pipelines
Databricks

Requirements

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 of 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 zones, bronze, silver, and gold layers of data
  • Good knowledge in implementing various business rules for Data Extraction, Transforming, and Loading (ETL) between Homogeneous 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 areas below

  • 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

Apply for this position