Sr. Data Analyst

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

Job#: 3021544

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).

• 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.

• 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 Power Center, 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 (Git Hub, 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.

• 2+ years experience with batch or Power Shell 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.

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

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

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

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.

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).