Senior Data Analyst

Apex Systems; Remote; USD 80,000 - 100,000; Full time

Job summary

A leading technology company is seeking a Senior Data Analyst to support data workflows, optimize ETL processes, and resolve data quality issues. The ideal candidate will have extensive experience in data engineering, particularly within healthcare, and be proficient in Azure Data Factory and Snowflake. Responsibilities include collaborating across teams, managing ETL development, and ensuring data integrity. The role offers competitive benefits and opportunities for professional development.

Benefits

Medical, dental, and vision insurance

401(k) program with company match

Employee Stock Purchase Program

Health Savings Account (HSA)

Employee Assistance Program (EAP)

Qualifications

• 5+ years data engineering experience, with emphasis on data warehousing.
• 2+ years developing pipelines in Azure Data Factory.
• 5+ years ETL development experience using tools like Informatica and SSIS.
• Experience with HL7, FHIR, and healthcare file formats.

Responsibilities

• Support Data Management team by developing and maintaining data workflows.
• Optimize ETL processes and resolve data quality issues.
• Develop ETL pipelines using Azure Data Factory and Snowflake.

Skills

Data warehousing

ETL development

Azure Data Factory

SQL

Troubleshooting

Analytical skills

Python scripting

Education

Bachelor’s degree in IT, Computer Science, Mathematics, Statistics, Analytics, Business

Tools

Snowflake

Informatica PowerCenter

SSIS

Job description

Senior Data Analyst – MN101 Telecommute 9:00 AM – 5:00 PM ET

Job#: 3021544

Position Summary

The Senior Data Analyst will support the Data Management team and the AL DSS by developing and maintaining data workflows, optimizing ETL processes, resolving data quality issues, and supporting intrastate agency data needs. This role requires strong technical expertise in Azure Data Factory, Snowflake, data warehousing, and healthcare data (Medicaid preferred).

Key Responsibilities

• Collaborate with cross‑functional teams to coordinate data engineering and ETL activities.
• Work closely with ETL architects to understand requirements and design user‑focused data transformations.
• Participate in the overall architecture, design, and automation of ETL workflows.
• Investigate data issues within ETL pipelines; identify root causes and propose solutions.
• Develop ETL pipelines and data flows using Azure Data Factory and Snowflake toolsets.
• Build idempotent ETL processes that support error‑free restarts.
• Utilize Snowflake Virtual Warehouses and Snowpipe to automate data ingestion.
• Manage slowly changing dimensions and data versioning using Snowflake Streams and Tasks.
• Optimize data movement, processing, and storage for performance and efficiency.
• Build job orchestration solutions for scheduling workflows, running quality checks, and managing dependencies.
• Conduct testing of ETL code, data design, pipelines, and root cause analysis for production issues.
• Document implementations, test cases, and CI/CD deployment processes.

Required Qualifications

• 5+ years data engineering experience, with emphasis on data warehousing.
• 2+ years developing pipelines in Azure Data Factory (ADF).
• 5+ years ETL development experience using tools such as Informatica PowerCenter, SSIS, Azure Data Factory, etc.
• 5+ years experience with relational databases (Oracle, Snowflake, SQL Server).
• 3+ years experience writing stored procedures (PL/SQL, T‑SQL, or Snowflake SQL).
• 2+ years experience with source control tools (GitHub, SVN).
• 2+ years experience processing structured and unstructured data.
• Experience with HL7, FHIR, and healthcare file formats.
• 3+ years analyzing project requirements and developing ETL specifications.
• Strong troubleshooting, optimization, and analytical skills.
• Ability to work in evolving technological environments.
• Bachelor’s degree in IT, Computer Science, Mathematics, Statistics, Analytics, Business, or related field.

Preferred Qualifications

• 2+ years experience with batch or PowerShell scripting.
• 2+ years Python scripting.
• 3+ years data modeling experience in a data warehouse environment.
• Experience with Informatica Intelligent Cloud Services (Data Integration).
• Experience building REST or RPC APIs in Snowflake or ADF.
• Background in State Medicaid, Medicare, or healthcare applications.
• Azure data engineering or analytics certifications.

Ideal Candidate Profile

A Data Engineer with experience in Medicaid or broader healthcare data environments, combined with advanced skills in Microsoft Azure, Snowflake, and ETL pipeline development.

Team Structure

• Data Manager
• Data Modeler
• Data Engineering Lead
• Data Engineers (4)
• Business Analyst
• QA Testers
• DBA

Interview Process

• Rounds: 3
• Format: Video
• Technical Depth: High

Benefits Overview

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 Employee Stock Purchase Program (ESPP) and a 401(k) program with company match after 12 months of tenure. Additional benefits include a Health Savings Account (HSA), an Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program, and other discounts. Professional development opportunities include on‑demand training, certification prep, and a library of technical and leadership courses.

Equal Opportunity Employer

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, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. 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 [email protected] or 804‑523‑8228. (Do not submit resumes or solicit consultants to this email address).