Analyst, Production Support

HRGi Holdings Inc; Northern (KY); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

100% remote (US)

Medical, dental & vision insurance

HSA & FSA options

401(k) with company match

Paid Time Off

Phone & internet allowance

Job summary

Expion Health is seeking an Analyst, Production Support to be the first line of defense for production data pipelines, dashboards, and reporting environments our teams rely on daily.

You'll monitor, triage, and resolve issues across Qlik, Snowflake, and MySQL, working with data engineers, Qlik developers, analysts, and business stakeholders to keep data flowing and reports trustworthy. You’ll automate repetitive work and document root causes for lasting improvements.

Qualifications

• 4+ years in production support or related roles with a BA or 2+ years with an MS.
• Hands-on Qlik Sense/QLikView experience: load scripts, data modeling, maintenance.
• Snowflake proficiency: querying, Snowpipe, tasks, streams, time travel, access control.
• Strong MySQL SQL skills: stored procedures, optimization, indexing, data validation.
• Python scripting for automation and data validation (pandas, boto3, requests).
• ETL/ELT concepts and data pipeline architecture understanding.
• Familiarity with AWS services for data workflows (S3, SQS, Lambda, CloudWatch).
• Experience with Jira, ServiceNow or equivalent ticketing/incident tools.
• Excellent analytical, debugging, and written/verbal communication; comfortable remote work.

Responsibilities

• Keep production running across Qlik dashboards, Snowflake pipelines, and MySQL within SLAs.
• Perform root-cause analysis on data issues and document findings for fixes.
• Maintain Snowflake Snowpipes, streams, tasks, and stored procedures for continuous data ingestion.
• Write and optimize SQL queries across MySQL and Snowflake to validate fixes.
• Build and maintain Python scripts for data validation and automation of routine tasks.
• Collaborate with Qlik developers to troubleshoot load scripts and data model issues.
• Communicate incident status and post-mortems clearly to all stakeholders.
• Contribute to runbooks and monitoring improvements; participate in on-call rotations.

Skills

Analytical skills

Problem solving

Communication

Troubleshooting

Remote/asynchronous work

Education

Bachelor's degree

Master's degree

Tools

Qlik Sense

Snowflake

MySQL

Python

Jira

ServiceNow

AWS

Snowflake Snowpipe

Job description

Expion Health is building the future of pharmacy economics. As architects of prescription economics, we design how pharmacy value is created, aligning cost, clinical decisions, and performance into one accountable system that moves beyond rebates. We help organizations stay ahead of pharmacy market change with clear insight, bold thinking, and strategies built for what's next, leading the next era of prescription economics.

The Role

We are looking for an Analyst, Production Support to be the first line of defense for the production data pipelines, dashboards, and reporting environments our teams and clients rely on every day. This is a role for someone who loves solving problems under pressure, digging until they find the real cause, and leaving every system a little more reliable than they found it.

Sitting within our Data & Reporting team, you'll monitor, triage, and resolve issues across our Qlik, Snowflake, and MySQL platforms, keeping data flowing and reports trustworthy. You'll work shoulder to shoulder with data engineers, Qlik developers, analysts, and business stakeholders to fix issues fast and keep them from coming back.

If you enjoy turning a messy incident into a clean root-cause story, take pride in data people can trust, and get real satisfaction from automating away the work no one should have to do twice, you'll feel right at home here.

What You'll Own

• Keep production running. Monitor, triage, and resolve production incidents across Qlik dashboards, Snowflake pipelines, and MySQL databases within defined SLAs.
• Get to root cause. Perform root-cause analysis on data discrepancies, pipeline failures, and reporting errors, and document your findings so issues stay fixed.
• Own the pipelines. Maintain and update Snowflake Snowpipes, streams, tasks, and stored procedures to keep data ingestion and processing running continuously.
• Investigate with SQL. Write and optimize SQL queries across MySQL and Snowflake to track down data issues and validate fixes.
• Automate the routine. Build and maintain Python scripts for data validation, automation of repetitive support tasks, and lightweight ETL operations.
• Partner on dashboards. Work with Qlik developers to troubleshoot load scripts, data model issues, and visualization errors.
• Communicate clearly. Share incident status, resolution progress, and post-mortems in plain language for technical and non-technical stakeholders alike.
• Strengthen the system. Contribute to runbooks and knowledge base articles, and find ways to improve monitoring, alerting, and overall reliability.
• Be there when it counts. Participate in an on-call rotation for critical production alerts and escalations.

What We're Looking For

• 4+ years of experience with a Bachelor's degree, or 2+ years with a Master's degree, in production support, software development, data operations, or a similar technical role. Strong development experience counts in place of direct production support experience if you can show real root-cause and problem-solving ability.
• Hands-on experience with Qlik Sense or QlikView, including load scripts, data modeling, and app maintenance.
• Proficiency in Snowflake, including querying, Snowpipe, tasks, streams, time travel, and access control.
• Strong SQL skills with MySQL, including stored procedures, query optimization, index analysis, and data validation.
• Python scripting for automation, data validation, and support tooling (pandas, boto3, requests, or similar).
• A solid understanding of ETL/ELT concepts and data pipeline architecture.
• Familiarity with AWS services relevant to data workflows, such as S3, SQS, Lambda, or CloudWatch.
• Experience with ticketing and incident management tools such as Jira, ServiceNow, or equivalent.
• Excellent analytical and problem-solving skills with a systematic approach to debugging.
• Strong written and verbal communication skills, and comfort working asynchronously in a remote environment.

Bonus points for:

• Experience with dbt or other data transformation frameworks.
• Exposure to healthcare data, HIPAA compliance, or clinical and pharmacy datasets.
• Familiarity with Genesys or similar contact center or CRM platforms.
• Knowledge of Git and CI/CD practices for data pipeline deployments.
• Experience with monitoring and observability tools such as Datadog or CloudWatch.
• Snowflake SnowPro certification.

Why Expion, Why Now

This is a pivotal moment to join Expion. Our data products sit at the center of how we deliver value, and dependable production support is what keeps that engine running. As an Analyst, Production Support, you won't just close tickets; you'll shape the runbooks, monitoring, and reliability standards that keep our platforms trustworthy as we grow.

Our values say it best: Build boldly, improve relentlessly. If that resonates with how you want to work, we want to talk.

Benefits & Perks

• 100% remote, work anywhere in the US
• Medical, dental & vision insurance
• HSA & FSA options
• Access to GLP-1 weight loss program
• Short & long-term disability
• Life Insurance and AD&D
• 401(k) with company match
• Paid Time Off
• Phone & internet allowance
• Town halls & direct access to executive leadership
• A company that is genuinely investing in AI, and in you!

Expion Health is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws