Data Engineer

Overview

On Site
Contract - W2

Skills

Microsoft SQL Server
Attention to detail
data lake
Data modeling
Microsoft Power BI
Apache Spark
Problem solving
Microsoft SSRS
Regulatory Compliance
Insurance
Financial services
Automated testing
SQL
IT service management
Continuous improvement
Data
Microsoft Azure
Analytics
Python
Agile
Communication
Mentorship
Leadership
Analytical skill
Microsoft SSAS
Cubes
Continuous integration
Continuous delivery
DevOps
HIPAA
Payment card industry
Sarbanes-Oxley
MDX
Cloud computing
Collaboration

Job Details

Data Engineer
Key Qualifications
  • Proficiency in Azure Data Factory (v2), Azure Data Lake, and Azure Synapse Analytics.
  • Experience with Microsoft SQL Server and data modeling using Power BI.
  • Experience with Python and Apache Spark.
  • Proven track record of working in an Agile environment.
  • Excellent communication skills with the ability to mentor others within the organization.
  • Strong problem-solving skills with the ability to lead others in resolving complex issues.
  • Strong analytical thinking and attention to detail.
  • Must be able to work in a collaborative environment.

Preferred Skills
  • Familiarity with SSAS Multi-Dimensional Cubes.
  • Experience in maintaining and developing SSRS reports.
  • Knowledge of CI/CD and DevOps methodologies.
  • Demonstrated ability to improve data reliability, efficiency, and quality.
  • Experience working in a regulatory compliance environment (HIPAA, PCI, SOX, etc.).
  • Bachelor's degree in a relevant discipline.

Ideal Candidate

An experienced Data Engineer, preferably with experience in the insurance industry, retirement plan providers, or financial services companies.

Your Role
  • Develop data pipelines to ingest data from multiple disparate sources into our data lake.
  • Assist in the conversion of legacy Multi-Dimensional Cubes to modern Power BI tabular models.
  • Create CI/CD pipelines that incorporate automated testing for all build and deployments.
  • Refactor MDX-based SSRS reports into SQL queries to aid in the deprecation of Multi-Dimensional Cubes.

Why Join Us?
  • Be part of a cloud-first data environment doing green-field development and support of legacy processes.
  • Collaborate in a team environment with a broad range of application and data developers, IT Services engineers, and various line-of-business end-users.
  • Contribute to the modernization of our Data Estate through continuous improvement initiatives.