Business Data Analyst

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.