Business Data Analyst

Francisco Partners; United States; Remote; USD 90,000 - 135,000; Full time

Job summary

RedSail Technologies seeks a Business Data Analyst (RAS) to drive data-informed decision-making. You will collect, process, and analyze datasets to uncover insights, write complex SQL queries, and develop dashboards using Power BI and Sigma.

You will work with data engineers to maintain pipelines and leverage AI frameworks to enhance outputs. The role requires a Bachelor’s degree and 3–5 years of experience, with strong SQL skills and the ability to translate data into actionable recommendations

Qualifications

• Bachelor’s degree or equivalent education plus technical experience (3–5 years).
• Advanced SQL proficiency including joins, CTEs, window functions and large-scale data structures.
• Experience building operational-grade reports and dashboards in Power BI and Sigma.

Responsibilities

• Collect, process, and analyze datasets to uncover trends, opportunities, and program outcomes.
• Write and optimize complex SQL queries to extract data from Snowflake, databases, APIs, and spreadsheets.
• Ensure data quality and consistency across platforms by identifying and correcting discrepancies.
• Collaborate with data engineers to design and maintain data pipelines for repeatable, scalable reporting.
• Design dashboards and KPIs using Power BI, Sigma, and other tools.
• Lead projects end-to-end with stakeholder communication and timely delivery.
• Leverage AI to improve efficiency and output quality.

Skills

SQL

Data visualization

Stakeholder communication

AI frameworks

Presentation skills

Excel

Microsoft Office

Education

Bachelor’s Degree in Computer Science, Information Technology, Business, Healthcare Administration, or related discipline

Tools

Power BI

Sigma

Snowflake

APIs

Job description

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.