Expion Health
Posted 19 days agoVerified live 9h ago
Analyst, Production Support
Brief overview
Remote
UndergradOr in progress
4+ yrsMinimum
Qlik Sense/QlikViewSnowflakeMySQLSQLPythonETL/ELTData Pipeline ArchitectureAWSJira/ServiceNowdbtHealthcare DataGit and CI/CDDatadogSnowflake SnowPro CertificationWritten and Verbal Communication
About the company
Expion Healthexpionhealth.com
Expion Health leverages technology to deliver medical claim and pharmacy cost management solutions.
Job description
Summary
Expion Health is building pharmacy economics solutions that align cost, clinical decisions, and performance through data-driven strategies. The Analyst, Production Support will monitor and resolve production issues across data pipelines, dashboards, and reporting platforms, perform root-cause analysis, maintain data workflows, automate support tasks, and improve system reliability.
Responsibilities
- 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
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
Qualifications
Must Haves
- • 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
Nice to Haves
- • 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
- A company that is genuinely investing in AI, and in you!
