Sr. Data Analyst

Job#: 3021544

Job Description:
Job Title: Senior Data Analyst

Location: MN101

Work Location Type: 100% Telecommute

Work Hours: 9:00 AM - 5:00 PM ET
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.
Top 3 Required Skills

5+ years data engineering with data warehousing focus

2+ years Azure Data Factory pipeline development

3+ years stored procedure development (PL/SQL, T-SQL, or Snowflake SQL)

Team Structure

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

Interview Process

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

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join 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. Apex uses a virtual recruiter as part of the application process. Click for more details.

Apex 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 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. 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, 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. 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 Apex team member can provide.