Excel Data Analyst Jobs in Utah (NOW HIRING)

Who We Are:

SmithRx is a rapidly growing, venture-backed Health-Tech company. Our mission is to disrupt the expensive and inefficient Pharmacy Benefit Management (PBM) sector by building a next-generation drug acquisition platform driven by cutting edge technology, innovative cost saving tools, and best-in-class customer service. With hundreds of thousands of members onboarded since 2016, SmithRx has a solution that is resonating with clients all across the country.

We pride ourselves for our mission-driven and collaborative culture that inspires our employees to do their best work. We believe that the U.S healthcare system is in need of transformation, and we come to work each day dedicated to making that change a reality. At our core, we are guided by our company values:

• Integrity: Our purpose guides our actions and gives us confidence in the path ahead. With unwavering honesty and dependability, we embrace the pressure of challenging the old and exemplify ethical leadership to create the new.
• Courage: We face continuous challenges with grit and resilience. We embrace the discomfort of the unknown by balancing autonomy with empathy, and ownership with vulnerability. We boldly challenge the status quo to keep moving forward—always.
• Together: The success of SmithRx reflects the strength of our partnerships and the commitment of our team. Our shared values bind us together and make us one. When one falls, we all fall; when one rises, we all rise.

Job Summary:

As a Financial Analyst on the Account Management team, you will serve as the primary data subject matter expert (SME) and the strategic bridge between our client-facing teams and the Data Analysis/Reporting department. Your mission is to translate complex pharmacy benefit data into actionable financial insights for our clients. You will be a trusted advisor to both internal Account Management leadership and client financial teams, ensuring that every strategic decision is backed by rigorous analysis and a deep understanding of SmithRx financial components.

What you will do:

• Support the resolution of complex client scenarios by conducting deep-dive data research and root-cause analysis.
• Partner with the account team to identify cost drivers, utilization shifts, and clinical opportunities within a client's portfolio to recommend plan design changes that mitigate spend.
• Serve as the primary liaison between Account Management and the Reporting/Data Analyst teams to ensure client reporting needs are technically feasible and strategically sound.
• Interpret pharmacy claims data, trend analysis, and rebate projections to provide "the story behind the numbers" for client presentations and Quarterly Business Reviews (QBRs).
• Oversee the integrity of client-facing financial reports, ensuring data aligns with contractual obligations and client expectations.
• Work on behalf of the Account Management team, collaborating with internal technical teams to improve automated reporting tools and identify product gaps based on client feedback and data limitations.
• Assess financial data for indicators of client attrition risk and work with Account Managers to develop data-driven mitigation strategies.
• Act as a data mentor to Account Managers, coaching them on how to interpret financial metrics and present data-heavy slides effectively.
• Participate in existing and prospective client meetings.

What you will bring to SmithRx:

• Deep fluency in the pharmacy benefits space, including an understanding of AWP, NADAC, rebates, formulary impact, and pharmacy network modeling.
• 5+ years of experience in data analysis, financial underwriting, or actuarial support within the healthcare and/or PBM industry.
• Strong command of data visualization tools (e.g., Looker, Tableau, PowerBI) and advanced Excel skills (VLOOKUPs, Pivot Tables, modeling).
• The unique ability to translate "data-speak" into executive-level insights for C-suite leadership and non-technical stakeholders.
• A passion for solving difficult problems in partnership with both technical developers and account managers.
• An obsession with data accuracy and a disciplined work ethic that ensures deliverables are met with little to no direction.
• Ability to observe scenarios from the client's financial point of view and provide proactive, honest, and transparent recommendations.
• Bachelor's degree in Finance, Healthcare Administration, or equivalent experience required.
• Ability to travel approximately 15-20% to client meetings

What SmithRx Offers You:

• Highly competitive wellness benefits including Medical, Pharmacy, Dental, Vision, and Life Insurance and AD&D Insurance
• Flexible Spending Benefits
• 401(k) Retirement Savings Program
• Short-term and long-term disability
• Discretionary Paid Time Off
• Paid Company Holidays
• Wellness Benefits
• Commuter Benefits
• Paid Parental Leave benefits
• Employee Assistance Program (EAP)
• Well-stocked kitchen in office locations
• Professional development and training opportunities