Reporting & Analytics Lead

Expion Health•Remote, OR

1d•Remote

About The Position

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. We're looking for a Reporting & Analytics Lead to head up our reporting and analytics function - someone who's equally at home writing SQL, shaping a data strategy, and presenting insights to executives. In this role, you'll lead a talented team of report developers and analysts, partner with leaders across the business, and turn complex questions into clear, trusted answers that drive real decisions. This is a hands-on leadership role. You'll set the technical direction, mentor your team, and deliver analytics solutions that scale - all while championing a culture of curiosity, quality, and continuous improvement.

Requirements

Master's degree in Computer Science (or 8+ years of equivalent industry experience in data solutions)
5+ years in reporting, analytics, or business intelligence, with at least 2 years of team leadership.
A track record of growing analytical teams - mentoring, coaching, and developing strong talent.
Strong analytical instincts and a practical, business-first approach to solving problems.
Hands-on expertise with SQL and cloud data warehouses (Snowflake, Redshift, or similar).
Experience with dbt, MySQL, PostgreSQL, and AWS data services (S3, Glue, Athena, Redshift).
Solid grounding in data modeling - star schemas, data marts, and semantic layers.
Proven experience delivering BI solutions using Qlik, Tableau, Power BI, Alteryx, or equivalent.
Experience applying AI and ML tools to enhance analytics workflows (LLM-based analysis, predictive modeling, or AI-powered automation).
Excellent communication skills - you can bridge technical and business conversations with ease and present to executives with confidence.
Comfort working in Agile or similar delivery frameworks.

Nice To Haves

Experience in healthcare, pharmacy, or insurance data (claims, eligibility, payment flows).
Exposure to CDC pipelines and cloud-based ETL/ELT processes.
Python for analytical automation or advanced analysis.
Knowledge of data governance and data quality frameworks.
Qlik or Snowflake certifications.

Responsibilities

Lead the team. Mentor, grow, and develop a team of report developers and data analysts. Set clear goals, manage performance, and recruit top talent as we scale.
Deliver trusted analytics. Own end-to-end delivery of dashboards, reports, and self-service analytics across the business - primarily in Qlik, with SQL and modern cloud data platforms under the hood.
Partner with the business. Be the go-to person for business leaders who need data to make decisions. Translate ambiguous questions into structured analysis and actionable insight.
Build for scale. Oversee the development of data models, pipelines, and BI solutions on Snowflake, dbt, and AWS data services - ensuring everything is accurate, consistent, and built to last.
Drive self-service. Empower non-technical users across the organization to answer their own questions through well-designed, well-governed analytics tools.
Bring AI into the workflow. Identify opportunities to apply AI/ML and LLM-based tools to automate, accelerate, and elevate the way we deliver analytics.
Present with impact. Communicate findings, recommendations, and project updates clearly to executive audiences and cross-functional partners.