Business Data Analyst (RAS)
Job Summary
The Business Data Analyst position helps drive data-informed decision-making
across the organization. Responsible for collecting, processing, and analyzing
data to uncover insights, trends, and opportunities. The ideal candidate will
have a strong command of SQL, data visualization tools, & AI frameworks, and
will work closely with stakeholders to translate data into actionable
recommendations. Operates under general supervision, with latitude for
independent judgment.
Key Duties
Collect, process, and analyze pharmacy-related datasets — including pharmacy
claims, MediSpan, clinical program data, and healthcare metrics — to uncover
trends, opportunities, and program outcomes.
Write and optimize complex SQL queries to extract and transform data from
multiple sources, including Snowflake, databases, APIs, and spreadsheets.
Ensure data quality and consistency across platforms by identifying,
investigating, and correcting discrepancies.
Collaborate with data engineers to design and maintain reliable data
pipelines that support repeatable, scalable reporting.
Design and develop operational-grade dashboards, visual reports, and KPIs
using Power BI, Sigma, and other visualization tools.
Lead assigned projects end-to-end, including scoping, stakeholder
communication, and timely delivery of complex analytical work.
Harness the power of AI to achieve efficiency and highest-quality outputs.
Education/Training
Bachelor’s Degree in Computer Science, Information Technology, Business,
Healthcare Administration, or a related discipline, or equivalent education
plus technical experience (3-5 years).
Required Work Experience/Skills
Advanced proficiency in SQL: query optimization, joins, CTEs, window
functions, and working with complex, large-scale data structures in Snowflake
or equivalent cloud data platforms.
Demonstrated ability to build operational-grade reports and dashboards using
Power BI and Sigma.
Strong presentation and storytelling skills — able to synthesize data into
clear, concise narratives for senior leadership, partners, and customers.
Experience presenting analytical findings to non-technical stakeholders,
including in external partner or customer-facing settings.
Detail-oriented with a high standard of quality, especially in outputs
intended for executive or external audiences.
Effective professional communication — written, verbal, and visual — across
technical and non-technical audiences.
Excellent interpersonal and organizational skills, with the ability to
self-manage, prioritize competing assignments, and work collaboratively.
Skilled at gathering business requirements, conducting process analysis, and
framing problem resolution in business terms.
Ability to lead projects independently and manage stakeholder expectations
throughout.
Proficiency in Microsoft Office Suite, including Power BI.
Ability to learn, adopt, and contribute to new technologies and analytical
frameworks related to RedSail’s AI infrastructure.
Preferred Work Experience/Skills
Experience with pharmacy and/or healthcare data, including claims, clinical
programs, reimbursement metrics, or PBM dynamics.
Prior experience in a customer-facing, partner-facing, or consulting
analytics role.
Proficiency with modern analytics stack tooling.
Proficiency with AI tools used in analytics settings (Snowflake Cortex,
Claude).
Discretionary Judgment
Uses independent judgment and discretion based upon the employee’s experience
and knowledge of pharmacy data, analytical methods, and stakeholder needs.
Exercises sound judgment in determining how to frame, present, and
communicate findings to diverse audiences, including external partners.
Possesses ethical work values and handles sensitive business and patient data
with appropriate discretion.
Physical Demands, Working Conditions, and General Employment Guidelines
Moderate levels of stress may be experienced in the performance of the job.
Position is performed in a general office environment, home office, or
approved remote workspace where physical work includes, but is not limited
to, sitting, standing, reaching, kneeling, bending, and lifting to 25 lbs.
Occasional travel may be required for team meetings, partner engagements,
customer site visits, conferences, or strategic sessions.
Equipment
Daily use of Microsoft Teams (messaging, calling, video), computer, and other
routine office equipment.
Must have internet access.
Safety to Self and Others
Little responsibility for the safety of others. Job is performed in an office
setting where there are no hazardous materials or equipment.
Working Conditions/Hazards
Position is performed in an open office environment or approved remote work
location.
Work Location
Remote
The above job description outlines the general details considered necessary to
describe the essential functions of this job. It is not a listing of all work
requirements or duties that may be a part of the job. Employees may be required
to perform duties outside of their normal responsibilities from time to time, as
needed. If requested, reasonable accommodations may be made to enable employees
with disabilities to perform the essential functions of the job, absent undue
hardship.