Reporting & Analytics Lead

Title: Reporting & Analytics Lead

Location: Fully Remote

Reports To: Pharmacy Data Operations Specialist

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'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.

What You'll Own

• 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.

What We're Looking For

• 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.

Bonus points for:

• 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.

Why Expion, Why Now

This is a pivotal moment to join Expion. Data is at the heart of how we operate - and we're investing in the people, tools, and platforms to make analytics a true competitive advantage. As our Reporting & Analytics Lead, you won't just be running a team; you'll be shaping how the entire organization uses data to make smarter decisions, faster.

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.