Senior Data Analyst
About The Position
The Senior Data Analyst is a key member of the Patient Solutions Data Science team, analyzing complex data from DrFirst’s medication management and secure communications platforms. The role supports understanding provider and patient behavior around prescriptions and pharmacy pickup. Working closely with the reporting lead, this analyst maintains and grows AWS QuickSight reporting and monitoring assets used by internal leadership and commercial teams, and fulfills ad-hoc analytical requests from product, commercial, finance, and other internal stakeholders. The position emphasizes ownership of deliverable quality, continuous improvement, efficient and reliable SQL, and proficiency across the AWS analytics stack. The analyst builds and maintains dashboards and recurring reports, writes optimized queries, uses AI tools to accelerate development, and applies generative AI to reporting workflows and BI products. They communicate findings to the reporting lead, broader team, internal stakeholders, and senior leadership. DrFirst describes itself as a Remote-First company; the role includes desk and phone work and travel across DrFirst and customer locations in the US.
Requirements
- Bachelor's or master's degree in statistics, mathematics, computer science, economics, or a related quantitative field.
- At least 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.
- At least 3 years of experience with Python, particularly pandas, for data analysis and pipeline development.
- Experience building and maintaining dashboards and recurring reports.
- Comfort with Excel and working knowledge of probability and statistics.
- Comfort using AI coding assistants and LLM tools (such as GitHub Copilot, Cursor, or Claude Code) to accelerate SQL and Python development, and applying generative AI to reporting tasks such as text-to-SQL, automated summarization, or narrative generation.
- Sound judgment about where AI is reliable enough for leadership-facing or Pharma client reporting and where it is not, particularly given the sensitivity of healthcare and Pharma client data.
- A track record of shipping an AI-assisted analytics workflow or tool that other stakeholders used, rather than only prototypes or personal experimentation.
- Strong communication skills and ability to explain technical and data concepts to business stakeholders and senior leadership.
Nice To Haves
- QuickSight dashboard experience is strongly preferred; Tableau or Power BI experience is also considered.
- Background in Healthcare IT, preferably including Rx data, patient adherence, or Pharma program reporting.
Responsibilities
- Build and maintain AWS QuickSight dashboards tracking product health, KPIs, and growth in collaboration with the reporting lead.
- Support anomaly detection and prepare monthly Pharma program reports.
- Scope and deliver ad-hoc reports and analyses for internal stakeholders, including product, commercial, and finance teams.
- Write efficient, optimized SQL queries against large datasets in Redshift and Athena.
- Apply AI to reporting, including automated narrative summaries, anomaly explanations, and self-service natural-language query tools.
- Use AI coding assistants such as GitHub Copilot or Claude Code to develop reporting capabilities efficiently.
- Build AI features into the BI product, such as written insights on QuickSight dashboards or a text-to-SQL layer for stakeholders.
- Present findings clearly to the reporting lead, broader team, and internal stakeholders as needed.
Benefits
- Competitive base salary of $130,000–$180,000, with exact compensation varying based on skills and experience.
- Eligibility for a company performance-based bonus program based on individual and company performance.
- Medical, dental, and vision insurance.
- 401(k) eligibility after 3 months, with a 50% company match up to the first 5% of salary contributed and a 3-year vesting schedule.
- HSA for eligible employees enrolled in the HDHP, with company contributions up to $500 annually for individual coverage and $1,000 for family coverage.
- Company-paid short- and long-term disability, AD&D, and group life insurance.
- Accrued annual PTO of 18 days for the first 3 years of service, increasing thereafter, plus 7 paid holidays.
- Employee Assistance Program.
- Continuing education funds up to $1,500 annually for eligible programs after 1 year of service.
- Voluntary benefits including FSA, hospital indemnity, accident, and critical illness insurance.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
