Senior Data Analyst - AI-Driven BI & AWS Analytics

DrFirst

United States

On-site

USD 130,000 - 150,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Medical, dental, and vision insurance

401K with company match

HSA contributions

Disability and life insurance

Paid time off and holidays

Education reimbursement

Job summary

DrFirst is seeking a Senior Data Analyst to join the Patient Solutions Data Science team. You will enhance AWS QuickSight dashboards, write production SQL, and partner with product, commercial, and finance teams on analytics and reporting.

The role emphasizes ownership of data quality, scalable analytics, and the use of AI tools to automate narratives and insights across Pharma programs. Expect collaborative, detail‑driven work with some travel in the US.

Qualifications

5+ years of experience writing efficient, production‑quality SQL with performance tuning on large datasets.
3+ years of experience with Python (pandas) for data analysis and pipeline development.
Hands‑on proficiency with AWS analytics services (Redshift, Athena, QuickSight).
Experience building and maintaining dashboards and recurring reports; QuickSight preferred, Tableau/Power BI also considered.

Responsibilities

Reporting & Monitoring: 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 for internal stakeholders across teams.
SQL & Querying: write efficient, optimised SQL against large datasets in Redshift and Athena.
AI‑Enabled Reporting: apply AI across the reporting function with automated narratives and self‑serve NLQ tools.
AI in the BI Product: build AI features into the BI product, e.g., written insights or text‑to‑SQL layers.
Communication: present findings clearly to leadership and internal stakeholders.