Pharmacy Data Analytics BA | SQL & Reporting

Scriptwellrx; Mission (KS); On-site; USD 65,000 - 90,000; Full time

Benefits offered by this job

Health insurance

401(k) with employer contributions

Unlimited PTO

Career development opportunities

Job summary

Scriptwellrx is seeking a curious Business Analyst to help turn client and internal needs into clear requirements for product and engineering teams. You’ll gather requirements, document current workflows, validate data and reports, and ensure what we ship solves the problem.

You’ll work at the center of pharmacy analytics, comfortable with SQL, and eager to learn the pharmacy data domain. This role offers collaboration with product, engineering, and operations.

Qualifications

• 1–2 years of professional experience in a business analyst, reporting, operations, or similar analytical role.
• Strong written and verbal communication, with the ability to explain technical details to non-technical audiences and vice versa.
• Highly organized and detail-oriented, with a habit of documenting your work.
• A demonstrated appetite for learning — courses, certifications, side projects, or any other evidence you pursue skills on your own initiative.
• Strong communication and remote collaboration skills.

Responsibilities

• Gather requirements from clients, product, and internal stakeholders, and translate them into clear user stories, acceptance criteria, and process documentation.
• Document current-state workflows, business rules, and data definitions so the team has a shared, reliable source of truth.
• Write and run SQL queries to answer stakeholder questions, validate data, and investigate discrepancies — with support and code review as you build the skill.
• Perform user acceptance testing on reports, dashboards, and application features, verifying they meet the documented requirements before they reach clients.
• Perform weekly reviews of client programs, tracking performance against expected results, and summarizing findings for the account and product teams.
• Partner with engineering and analytics throughout the sprint to clarify requirements, answer questions, and keep work traceable from initial request through release.
• Help triage incoming client requests and issues, gathering the detail needed to prioritize them with the Product Manager.
• Build a working understanding of pharmacy, 340B, and PBM data, and grow into a go-to resource for how our data fits together.
• Bring forward ideas for improving our processes, documentation, and reporting.

Skills

SQL

Requirements gathering

Documentation

Data analysis

Communication

Remote collaboration

Education

Bachelor’s degree

Tools

Power BI

Tableau

Azure DevOps

Jira

Confluence

Job description

Scriptwellrx is seeking a curious Business Analyst to help turn client and internal needs into clear requirements for product and engineering teams. You’ll gather requirements, document current workflows, validate data and reports, and ensure what we ship solves the problem.

You’ll work at the center of pharmacy analytics, comfortable with SQL, and eager to learn the pharmacy data domain. This role offers collaboration with product, engineering, and operations.