Senior Data Analyst at DrFirst

Job description

Here is a remarkable chance for you to join a thriving Healthcare IT company with established products, prestigious clients, substantial revenue, blue-chip institutional investors, and continuous growth. At DrFirst, you will collaborate with brilliant minds, tackling unique healthcare challenges on an unprecedented scale. Our culture is entrepreneurial, collaborative, and fast-paced—ideal for those who seek personal and professional growth while working alongside intelligent colleagues. If you're enthusiastic about pushing your limits, unlocking your potential, and thriving in a dynamic team, we're eager to connect with you! The Senior Data Analyst will be a key member of the Patient Solutions Data Science team, which finds ways to digest, understand, and analyze the complex data derived from our medication management and secure communications platforms. This data combines provider and patient information, allowing our team to understand both the doctor's intentions and the patient's actions. Since our products intervene at the critical time between when a doctor writes a prescription and when the patient picks it up at the pharmacy, we can uniquely identify and influence patient behavior. This role will work closely with our reporting lead to maintain and grow our AWS QuickSight reporting and monitoring assets — used by internal leadership and commercial teams alike — while also handling ad-hoc analytical requests from internal stakeholders across teams such as product, commercial, and finance. Our ideal candidate drives continuous improvement, brings a strong sense of ownership over the quality of their deliverables, writes efficient and reliable SQL, and is comfortable navigating the AWS analytics stack end to end. Who will love this job • A Scrupulous builder : who pays attention to the smallest of details, takes pride in clean, well-documented dashboards, and appreciates the power of good data visualization. • A Self-starter : well-organized and able to work effectively across multiple recurring reports and ad-hoc requests, promptly and with limited management oversight. • A Team Player : able to collaborate closely with reporting and analytics teammates, and communicate effectively with both technical and business audiences. • Reporting & Monitoring: 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. • Ad-hoc Analysis: Scope and deliver ad-hoc reports and analyses for internal stakeholders across teams such as product, commercial, and finance. • SQL & Querying: Write efficient, optimized SQL against large datasets in Redshift and Athena. • AI-Enabled Reporting: 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. • AI in the BI Product: 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. • Communication: Present findings clearly to the reporting lead and broader team, and to internal stakeholders as needed. • 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. #LI-GF1 #LI-Remote • Competitive compensation, with a base salary of $130,000 - $150,000 (Exact compensation may vary based on skills and experience) • Eligible for Company Performance-based Bonus Program, based on individual and company performance • Medical, dental, and vision insurance • 401K eligible after 3 months of employment, with 50% company match up to first 5% of salary contributed to the plan with a 3-year vesting schedule • HSA for eligible employees enrolled in the HDHP, with a generous company contribution up to $500 for individual coverage and $1000 for family coverage per year • 100% company paid short and long-term disability, AD&D, and group life insurance • Accrued annual paid time off (PTO) of 18 days for the first 3 years of service, increasing thereafter and 7 paid holiday days • Employee Assistance Program • Continuing Education funds up to $1500 annually for eligible programs after 1 year of service • Voluntary benefits including FSA, Hospital indemnity, Accident and Critical Illness insurances DrFirst is committed to being a Remote-First company, creating a dynamic and flexible workplace where everyone can thrive, no matter where they log in from. Check out our approach to remote work: drfirst.com. Our recruitment process at DrFirst is straightforward and secure. You will only be contacted by our recruitment team through an official @drfirst.com email address. We will never ask you for payment or sensitive personal information, such as your social security number or banking details, at any stage of the hiring process. Additionally, we will not request that you purchase equipment or accept e-checks or checks for deposit. If you encounter any communications claiming to be from DrFirst that seem suspicious, please contact our recruitment team directly at recruiter@drfirst.com to verify the message's authenticity. Your security is important to us! Learn more about our benefits and professional development opportunities: drfirst.com.

Requirements

Must-haves

Who will love this job
A Scrupulous builder : who pays attention to the smallest of details, takes pride in clean, well-documented dashboards, and appreciates the power of good data visualization.
A Self-starter : well-organized and able to work effectively across multiple recurring reports and ad-hoc requests, promptly and with limited management oversight.
A Team Player : able to collaborate closely with reporting and analytics teammates, and communicate effectively with both technical and business audiences.
Reporting & Monitoring: 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.
Ad-hoc Analysis: Scope and deliver ad-hoc reports and analyses for internal stakeholders across teams such as product, commercial, and finance.
SQL & Querying: Write efficient, optimized SQL against large datasets in Redshift and Athena.
AI in the BI Product: 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.
Communication: Present findings clearly to the reporting lead and broader team, and to internal stakeholders as needed.
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.
Comfortable with Excel and working knowledge of probability and statistics.
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.
#LI-GF1 #LI-Remote
HSA for eligible employees enrolled in the HDHP, with a generous company contribution up to $500 for individual coverage and $1000 for family coverage per year

Nice-to-haves

Experience building and maintaining dashboards and recurring reports; QuickSight experience strongly preferred, Tableau/Power BI experience also considered.
Eligible for Company Performance-based Bonus Program, based on individual and company performance

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

awssqlaipythonllm

Platform: icims
Effort: medium

Benefits

Benefits detected in the listing.

Dental

Vision

401k

Pto

Paid Time Off

Professional Development