Data Engineer (Health Benefits)

Company Background

Our client is a leading third-party administrator for health benefits in the U.S., offering self-funded medical, dental, FSA, and HRA plans. They provide a comprehensive suite of online tools for members, employers, consultants, brokers, and providers to manage and pay healthcare claims.

Project Description

The project focuses on refactoring Machine Readable Files (MRFs) and rebuilding the EZChoice application. Upon completion, developers may transition to contribute to the Datahub platform.

Technologies

• Microsoft Azure
• Azure Data Factory
• Azure SQL
• SQL Server
• Azure Functions
• Azure DevOps
• Power BI
• C#
• Python
• Spark
• SparkSQL
• Notebooks
• Microsoft Fabric
• Hive

What You’ll Do

• Redesign and optimize existing ETL pipelines for MRFs and EZChoice
• Write efficient Spark jobs and Python scripts to support scalable data processing
• Build and monitor pipelines using Azure Data Factory
• Transform and integrate data from various sources into Azure-based data stores
• Write and maintain complex SQL scripts (DDL, DML) for analytics and reporting
• Collaborate with stakeholders to create technical documentation and user manuals
• Perform code reviews, unit testing, and data validation
• Analyze current system architecture and tools, and recommend improvements
• Participate in CI/CD workflows using Azure DevOps
• Contribute to Power BI dashboard development for data visualization

Job Requirements

• 3+ years of experience as a BI Developer or Data Engineer
• Experience with Azure Data Factory and other Microsoft Azure services
• Experience with SQL Server, Azure SQL, and complex SQL query development
• Experience with ETL/ELT pipeline development and optimization
• Experience with Power BI for reporting and dashboards
• Experience with Spark, SparkSQL, and Python notebooks
• Familiarity with .NET/C# is a plus
• Comfortable working with Azure DevOps for version control, task tracking, and CI/CD
• Experience with Microsoft Fabric and Hive is an advantage
• Strong problem-solving and communication skills
• English level: B1+ (spoken and written)

What Do We Offer

The global benefits package includes:

• Technical and non-technical training for professional and personal growth;
• Internal conferences and meetups to learn from industry experts;
• Support and mentorship from an experienced employee to help you professional grow and development;
• Internal startup incubator;
• Health insurance;
• English courses;
• Sports activities to promote a healthy lifestyle;
• Flexible work options, including remote and hybrid opportunities;
• Referral program for bringing in new talent;
• Work anniversary program and additional vacation days.