Sr. Data Engineer

Overview

Job Description:
Senior Data Analyst

Cannot accept candidates that require sponsorship now or in the future.

6 month contract to hire.

Job#: 3020608

Work Arrangement: 100% Remote

Schedule: Monday–Friday, 8:00 a.m. – 5:00 p.m.

The Senior Data Analyst will support the full software development and implementation lifecycle within the Program Integrity (PI) team. This role focuses on building and managing cloud-based data engineering solutions that power fraud, waste, and abuse (FWA) detection capabilities. The ideal candidate has strong technical expertise, excellent analytical skills, and the ability to collaborate effectively with cross-functional teams.

• Support the full software development and implementation lifecycle.
• Lead the design, development, and management of ETL processes for Program Integrity data marts in Snowflake and SQL Server.
• Build and maintain data pipelines using Azure Data Factory (ADF), supporting ETL operations and Peer Group Profiling outputs.
• Implement and manage Dev Ops practices to improve data loading, efficiency, and workload balancing within the PI data mart.
• Collaborate with cross-functional teams to ensure seamless data integration and consistent data flow.
• Monitor, troubleshoot, and optimize data pipelines to ensure reliability and performance.
• Independently identify and resolve complex technical issues.
• Communicate effectively across teams to support project execution and alignment.
• Apply strong analytical skills and attention to detail to maintain data accuracy and quality.
• Lead cloud‑based project delivery, ensuring adherence to timelines, scope, and performance expectations.
• Ensure compliance with data security and industry standards.

• 5+ years of hands-on experience in cloud-based data engineering and data warehousing, with a focus on scalable data solutions.
• 5+ years of experience with Snowflake, including design, development, and automated data ingestion using Snowflake SQL and Python.
• 5+ years of experience with Azure data tools:
  Azure Data Factory (ADF), SQL Server, Blob Storage.
• 2+ years of experience with Python or other scripting languages.

• Azure or Snowflake certifications.
• Experience with data modeling and database design.
• Knowledge of data governance and data quality best practices.
• Familiarity with AWS, GCP, or other cloud platforms.
• Recent experience with medical claims processing systems and healthcare data structures.
• Experience in data science or advanced analytics.

The Program Integrity team is seeking a data-focused engineer/analyst to develop a strong understanding of FWA detection software and methodologies. This role will work closely with business analysts, data engineers, software engineers, and report developers across multiple phases of implementations and operational projects. The analyst will become familiar with database structures, testing workflows, and documentation practices, playing a key role in launching new projects and supporting existing initiatives.

• Experience working with healthcare data and understanding the lifecycle of a medical claim.
• Strong SQL and data mapping skills.
• Comfortable working in cloud environments and open to incorporating AI-driven tools.

• Cloud-based data engineering & data warehousing (5+ years).
• Snowflake development, automation, and SQL/Python (5+ years).
• Azure Data Factory (ADF), SQL Server, and Blob Storage (5+ years).

• Strong curiosity and willingness to continuously learn.
• Excellent communication skills with both technical teams and business analysts.

• 3 Data Engineers
• 2 Report Developers (Power BI & Cognos)
• 10 Data Analysts
• 2 Managers
• 1 Director

Supporting state government program integrity initiatives.

• Rounds: 2
• Format:
  Video
• Technical Level: Includes SQL‑related and technical skill questions

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, protected veteran status, or any other characteristic protected by law. If you require an accommodation in using our website for a search or application, please contact our Benefits Department.