Note: The job is a remote job and is open to candidates in USA. Expion Health is building the future of pharmacy economics by aligning pharmacy cost, clinical decisions, and performance through prescription economics. The Analyst, Production Support will monitor, troubleshoot, and maintain production data pipelines, dashboards, and reporting environments across Qlik, Snowflake, and MySQL while conducting root-cause analysis, automating support tasks, and improving system reliability.
Responsibilities
- Monitor, triage, and resolve production incidents across Qlik dashboards, Snowflake pipelines, and MySQL databases within defined SLAs
- Perform root-cause analysis on data discrepancies, pipeline failures, and reporting errors, and document your findings so issues stay fixed
- Maintain and update Snowflake Snowpipes, streams, tasks, and stored procedures to keep data ingestion and processing running continuously
- Write and optimize SQL queries across MySQL and Snowflake to track down data issues and validate fixes
- Build and maintain Python scripts for data validation, automation of repetitive support tasks, and lightweight ETL operations
- Work with Qlik developers to troubleshoot load scripts, data model issues, and visualization errors
- Share incident status, resolution progress, and post-mortems in plain language for technical and non-technical stakeholders alike
- Contribute to runbooks and knowledge base articles, and find ways to improve monitoring, alerting, and overall reliability
- Participate in an on-call rotation for critical production alerts and escalations
Skills
- 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
- 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
Benefits
- 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
Company Overview
Company H1B Sponsorship