As a Data Analyst at SmithRx, your day-to-day responsibilities bridge the gap between raw data engineering and strategic business execution. You will be a core member of a high-impact data team, working to ensure that data is trustworthy, accessible, and highly actionable.

Your primary responsibilities will include:

• Partnering directly with product managers, clinical operations, and client success teams to design and implement key business metrics and interactive dashboards.
• Writing clean, robust SQL and utilizing dbt to query, transform, and validate complex, large-scale healthcare datasets.
• Collaborating closely with Data and Analytics Engineers to influence the architecture of dimensional data models, ensuring data integrity and reliable delivery pipelines.
• Conducting rigorous root-cause analyses to uncover operational inefficiencies, forecast financial outcomes, and drive product improvements.
• Mentoring emerging analytical talent within the team, fostering intellectual curiosity, and championing world-class data governance and code quality standards across the organization.

SmithRx looks for analytical professionals who possess a strong technical foundation combined with a proactive, self-starter mindset. The ideal candidate is comfortable navigating ambiguity and is passionate about transforming the healthcare industry.

• Must-have skills – Advanced technical proficiency in SQL (writing complex queries, CTEs, and window functions) and deep experience with data visualization tools (such as Tableau, Looker, or Power BI). Strong foundational skills in Excel are also required.
• Nice-to-have skills – Hands-on experience with dbt (data build tool) for data transformation, familiarity with Python or R for advanced statistical analysis, and direct domain experience in healthcare, pharmacy benefit management (PBM), or health-tech.
• Experience level – A Bachelor's degree in an analytical field (STEM, Economics, Finance) is required, with a Master's or Ph.D. preferred. For mid-to-senior levels, 3 to 8+ years of hands-on experience influencing business decisions through data is expected.
• Soft skills – Exceptional storytelling and communication skills, with the ability to translate complex statistical findings into clear business strategies for executive stakeholders. Proven ability to take complete ownership of projects from conception to delivery.

Q: What is the typical timeline for the SmithRx interview process? A: The process is relatively streamlined but thorough, typically taking between 2 to 4 weeks from the initial recruiter screen to the final decision. However, candidates should stay proactive and follow up if there are scheduling delays between technical rounds.

Q: How difficult is the live SQL assessment? A: Candidates describe the SQL test as average to challenging. It is highly practical, focusing on real-world data manipulation scenarios rather than obscure algorithmic puzzles. Practicing window functions, joins, and aggregations on platforms with real-world business datasets is highly recommended.

Q: Does SmithRx require specific working hours? A: Yes. Regardless of your physical location, SmithRx teams coordinate closely and typically require employees to maintain a full 8-hour overlap with Pacific Time (PT) working hours to facilitate real-time collaboration.

Q: What is the company culture like for the data team? A: The culture is mission-driven, highly collaborative, and intellectually curious. You will find supportive team members who are willing to guide you during the interview process and direct you toward the right solutions during technical discussions.

To maximize your chances of securing an offer at SmithRx, keep these practical, insider tips in mind throughout your preparation:

• Prepare for Live Technical Environments: If you are neurodivergent or require specific accommodations for live, timed coding environments, do not hesitate to ask the recruiting team in advance. They are accommodating, but you must advocate for your needs early.
• Understand the PBM Business Model: Take the time to research how Pharmacy Benefit Managers make money, what a formulary is, and how drug pricing tiers work. Having even a basic understanding of the healthcare ecosystem will set you apart from other candidates.
• Over-Communicate During Live Coding: When writing SQL live, talk through your thought process before you start typing. If you get stuck, explain your logic; the interviewers are friendly and often try to guide you in the right direction if they see how you are structuring your thoughts.
• Align Your Answers to Pacific Time: Since SmithRx requires a strong overlap with Pacific Time, mention your comfort level and experience working across different time zones if you are applying from the East Coast or Central regions.

The Data Analyst position at SmithRx is an exceptional opportunity to leverage your analytical talents to drive meaningful, systemic change in the healthcare sector. By transforming complex pharmacy data into actionable business intelligence, you will directly support the company's mission of making healthcare more transparent, affordable, and accessible.

As you prepare for your interviews, focus on mastering your core SQL and Excel skills, refining your data storytelling abilities, and aligning your personal narrative with the company's core values of Integrity, Courage, and Together. Approach the technical assessments with structured logic, and view the behavioral rounds as an opportunity to showcase your proactive problem-solving mindset.

The salary insight module above highlights the competitive compensation structure offered at SmithRx. When evaluating your target compensation, consider how your years of experience, technical expertise with tools like dbt, and domain-specific healthcare knowledge position you within this scale. For more detailed interview preparation resources, company insights, and community reviews, continue your research on Dataford to ensure you walk into your interviews with complete confidence.