Data Engineer

Job#: 3032349

Job Description:
Data Engineer

Location: Phoenix, Arizona (Partial Remote)

Employment Type: Contract-to-Hire

Role Overview

As a Data Engineer, you will contribute to a team that supports the data infrastructure of a large organization's digital platform. Your responsibilities will include the design, construction, and maintenance of data pipelines that transport and transform health plan data within Azure-based systems. This role ensures data is delivered with accuracy and timeliness for use in APIs, analytics, and member-facing applications. You will work with SQL Server, Azure Data Factory, Cosmos DB, and Python in a healthcare setting where data quality and compliance are priorities.

Key Responsibilities

• Build and maintain ETL/ELT pipelines using Azure Data Factory and SSIS.
• Write T-SQL and Python to extract, transform, and load data across SQL Server, Azure SQL, and Cosmos DB.
• Implement delta loading, deduplication, and idempotency patterns for reliable pipeline execution.
• Design Slowly Changing Dimension (SCD) logic to track member and plan data history.
• Apply data quality checks and validation rules during ingestion and transformation.
• Monitor pipeline runs, investigate failures, and implement observability into data flows.
• Follow Git and Azure DevOps workflows, including branching, pull requests, and CI/CD pipeline integration.
• Document data flows, field mappings, and transformation logic.
• Handle healthcare data in compliance with HIPAA requirements.

Required Qualifications

Experience: 2-5 years in data engineering, ETL development, or a related data-focused role. Demonstrated experience with Git, including branching, commits, and pull request workflows.

Technical Skills: Hands-on experience writing T-SQL queries (SELECT, JOINs, WHERE filters, aggregations). Experience building or maintaining ETL pipelines using SSIS or Azure Data Factory (ADF). Experience with SQL Server or Azure SQL as a primary data store and experience working in cloud technologies such as Azure, AWS, or Google Cloud Platform.

Professional Competencies: Proficiency in T-SQL for data extraction, transformation, and validation. Understanding of core data engineering concepts such as delta loading, deduplication, and idempotency. Familiarity with development tools including SSMS, Visual Studio, VS Code, and the Azure Portal. Knowledge of the data pipeline lifecycle, data validation, and source-to-target mapping is required. Familiarity with Agile/Scrum methodology and knowledge of HIPAA requirements are necessary.

Preferred Qualifications

• Experience with Python for data transformation and pipeline scripting, including libraries like pandas.
• Familiarity with Azure Cosmos DB or another NoSQL data store.
• Understanding of delta loading, deduplication, and idempotency patterns in data pipelines.
• Exposure to bulk load strategies and partitioning for large data volumes.
• Experience integrating pipelines into Azure DevOps CI/CD workflows.
• Exposure to healthcare data structures (member, claims, eligibility).
• Familiarity with Azure Functions, Blob Storage, and workflow orchestration tools like Apache Airflow or Azure Logic Apps.
• Exposure to Azure OpenAI or AI/ML integration concepts.

Compensation & Benefits

The pay rate for this position is between $55.00 and $60.00 per hour. A comprehensive benefits package is available to eligible employees.

This employer is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability.

Apex uses a virtual recruiter as part of the application process. Click for more details.

If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Benefits Department at or .

Everforth Apex is a world-class IT services company that serves thousands of clients across the globe. When you join Everforth Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico. Everforth Apex uses a virtual recruiter as part of the application process. Click for more details.

Everforth Apex Benefits Overview: Everforth Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Everforth Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Everforth Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Everforth Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our 'Welcome Packet' as well, which an Everforth Apex team member can provide.