Senior Data Analyst

DrFirst is a Healthcare IT company focused on medication management and secure communications platforms. The Senior Data Analyst will maintain and expand AWS QuickSight reporting and monitoring assets, perform ad-hoc analyses, write optimized SQL, and develop AI-enabled reporting and business intelligence solutions for internal stakeholders.

Responsibilities:

• Work closely with our reporting lead to build and maintain AWS QuickSight dashboards tracking product health, KPIs, and growth; support anomaly detection and monthly Pharma program reports
• Scope and deliver ad-hoc reports and analyses for internal stakeholders across teams such as product, commercial, and finance
• Write efficient, optimized SQL against large datasets in Redshift and Athena
• Apply AI across the reporting function — automated narrative summaries, anomaly explanations, and self-serve natural-language query tools — using AI coding assistants (e.g., GitHub Copilot, Claude Code) to build them efficiently
• Build AI directly into our BI product, such as automated written insights layered on top of QuickSight dashboards or a text-to-SQL layer other stakeholders can query directly
• Present findings clearly to the reporting lead and broader team, and to internal stakeholders as needed

Requirements:

• • Bachelor's or Master's degree in statistics, math, computer science, economics, or a related quantitative field
• • 5+ years of experience writing efficient, production-quality SQL, including query optimization and performance tuning on large datasets
• • Hands-on proficiency with AWS analytics services, including Redshift, Athena, and QuickSight; familiarity with the AWS Glue Data Catalog for locating and understanding queryable data
• • 3+ years of experience with Python (particularly the pandas library) for data analysis and pipeline development
• • Experience building and maintaining dashboards and recurring reports; QuickSight experience strongly preferred, Tableau/Power BI experience also considered
• • Comfortable with Excel and working knowledge of probability and statistics
• • Comfortable using AI coding assistants and LLM tools (e.g., GitHub Copilot, Cursor, Claude Code) to accelerate SQL/Python development, and applying generative AI to reporting tasks such as text-to-SQL, automated summarization, or narrative generation
• • Sound judgment for where AI is reliable enough to ship in leadership-facing or Pharma client reporting, and where it isn't — particularly given the sensitivity of healthcare and Pharma client data
• • Track record of shipping an AI-assisted analytics workflow or tool that other stakeholders actually used, not just prototypes or personal experimentation
• • Strong communication skills, with the ability to explain technical/data concepts to a variety of business stakeholders and senior leadership
• • Preferably a background in Healthcare IT, with experience working on Rx data and patient adherence or Pharma program reporting
• • 90% desk and phone work
• • 10% travel across DrFirst and customer locations in the US