Data Engineer

Overview

Hybrid
$75 - $80
Contract - W2

Skills

Actuarial Science
Big Data
Analytics
Agile
Data Engineering
Business Intelligence
Collaboration
Databricks
Extract
Transform
Load
Data Extraction
KPI
Data Mining
Microsoft SQL Server
Microsoft BI

Job Details

Job Description: Azure BI/Data Engineer

We are seeking an experienced Azure BI/Data Engineer to design, develop, and support robust data solutions using Microsoft and Azure technologies. The ideal candidate will have deep technical expertise in Azure-based data engineering and business intelligence solutions, along with a solid understanding of data warehousing, ETL processes, and domain experience in the insurance or actuarial space.

Key Responsibilities:

  • Design and implement Microsoft BI and Azure BI solutions, including Azure Data Factory, Azure Databricks, Azure Analysis Services, SSIS, and SSRS.

  • Utilize Azure big data technologies such as Azure Data Lake Analytics, Azure Data Lake Store, and Azure Data Factory to ingest, store, and process large-scale datasets.

  • Build and maintain scalable data pipelines using Databricks notebooks, moving data efficiently from raw to curated zones (staging, bronze, silver, gold).

  • Develop and optimize U-SQL jobs for data extraction and transformation from flat files and SQL Server sources.

  • Create and deploy complex tabular models using Azure Analysis Services and schedule automated refreshes via Azure Automation Runbooks.

  • Design, develop, and manage SSAS tabular and multidimensional cubes, including KPIs, measures, partitions, aggregations, and data mining models.

  • Apply advanced data modeling techniques, including normalization and denormalization, to support business intelligence and analytics requirements.

  • Implement business rules and ETL processes across homogenous and heterogeneous data sources using Azure Data Factory.

Preferred Domain Knowledge:

  • Experience with actuarial or insurance data, including exposure to placement data, treaty structures, client hierarchies, and renewal workflows.

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

  • Proven ability to develop data pipelines that support actuarial analytics, pricing models, and reporting needs for brokers and clients.

Team & Project Management Skills:

  • Strong collaboration and communication skills with the ability to lead and work effectively within Agile/SCRUM teams.

  • Proficient in documenting technical processes and writing clear, concise reports.

  • Comfortable working independently or as part of a team to achieve critical business goals.

  • Strong decision-making capabilities, particularly in high-pressure and complex project environments.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.