Business Intelligence Analyst - REMOTE at Southern Scripts

Mid

Advanced SQL

Snowflake

Power BI

+5 more

Job Description

Business Intelligence Analyst - REMOTE

Role and Responsibilities

The Business Intelligence Analyst – RxCompass & Variable Copay serves as the strategic data and analytics lead across both programs, providing clear visibility into performance, savings, drug list management, and operational execution. Reporting directly to the Director of RxCompass and Variable Copay, this role is responsible for designing and automating advanced reporting solutions that support capture rate optimization, drug list governance, savings opportunity identification, vendor performance oversight, and scalable program growth.

This position leverages Snowflake, advanced SQL, SSRS, and Power BI to develop executive-level dashboards and performance frameworks that translate complex pharmacy and operational data into actionable insights. The Analyst will establish reporting governance across capture rates, savings realization, drug pipeline impacts, financial trends, and performance management metrics to ensure data integrity, transparency, and accountability.

Success in this role is measured by increased reporting automation, stronger KPI standardization, improved capture rate and savings visibility, and the ability to deliver accurate, decision-ready intelligence that informs strategic and operational leadership.

Data Architecture & Advanced Query Development

• Develop and optimize advanced SQL queries within Snowflake and SQL Server environments.
• Design scalable data models supporting capture rate, savings, drug list management, and performance analytics.
• Extract, transform, and validate pharmacy claims, eligibility, savings, and operational datasets.
• Ensure reconciliation accuracy and reporting consistency across multiple systems and data sources.

Dashboard Development & Executive Reporting

• Design, build, and maintain automated Power BI dashboards for RxCompass and Variable Copay.
• Develop executive-ready visualizations supporting SLA performance, workforce metrics, vendor oversight, capture rate tracking, and savings realization.
• Standardize KPI definitions and reporting frameworks across both programs.
• Apply strong data storytelling and visualization best practices to enhance decision-making clarity.

Capture Rate, Savings & Drug List Intelligence

• Build and maintain reporting frameworks to measure and improve capture rates across programs.
• Identify savings opportunities through trend analysis and financial modeling.
• Analyze drug list performance, pipeline impacts, and program optimization opportunities.
• Provide data-driven recommendations to support program growth and financial performance.

Performance Analytics, Root Cause & Remediation Support

• Develop reporting visibility into vendor performance, SLA adherence, and operational execution.
• Lead structured root cause analysis on performance gaps, reporting discrepancies, and savings variances.
• Quantify operational and financial impact of identified issues.
• Partner with Operations and Business Integration to develop data-informed remediation strategies.
• Track and validate post-remediation performance to ensure sustainable correction and measurable improvement.

Reporting Automation & Governance

• Automate recurring operational and executive reporting to reduce manual processes and improve reliability.
• Develop SSRS reports and implement scheduled refresh and distribution pipelines.
• Build anomaly detection and validation logic to proactively identify data inconsistencies.
• Maintain documentation of reporting logic, KPI definitions, and governance standards.

Strategic Partnership

• Serve as the primary analytics advisor to the Director of RxCompass & Variable Copay.
• Partner cross-functionally with Operations, Business Integration, IT, Claims, Finance, and Vendor Management teams.
• Translate complex business questions into scalable reporting and analytical solutions.
• Support strategic planning, growth initiatives, and financial performance oversight.

REQUIRED SKILLS AND COMPETENCIES

Advanced SQL required (complex joins, CTEs, large dataset querying, performance optimization).
Strong experience in Snowflake or similar cloud data warehouse environment highly preferred.
Advanced Power BI required (data modeling, DAX, dashboard automation).
Advanced Excel required, including Power Query and complex data transformation.
Demonstrated ability to build automated dashboards and eliminate manual reporting processes.
Strong analytical skills with the ability to translate complex data into executive-ready insights.
Experience developing performance, capture rate, and savings reporting frameworks.

Excellent time management skills and ability to work independently and effectively prioritize tasks
Excellent interpersonal skills; must be a team player
Strong written and verbal communication skills with a positive, patient, and professional demeanor
Ability to maintain confidentiality of sensitive medical information; knowledge of HIPAA Privacy and Security Rules
Flexibility to understand, appreciate and embrace that this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee. Duties, responsibilities and activities may change, or new ones may be assigned at any time with or without notice.

PREFERRED QUALIFICATIONS

Experience working in Snowflake or other cloud data warehouse environments.
Experience in healthcare, PBM, specialty pharmacy, or pharmacy claims analytics.
Experience developing capture rate, savings, or performance reporting frameworks.
Experience supporting executive-level reporting and KPI governance.
Familiarity with pharmacy claims components (ingredient cost, accumulators, pricing logic).

Position Type and Expected Hours of Work

Full-time/Salaried/Exempt.
Some flexibility in hours is allowed, but the employee must be available during the “core” work hours of 8:00AM to 5:00PM CT. We cover clients from West to East Coast, work times must be adjusted to cover meetings in all time zones. Ability to work extended hours, weekends and holidays pursuant with industry demands.

What We Have to Offer

Our benefits package is designed to keep our employees happy and healthy - physically, mentally and financially.

Medical, Dental, Vision insurance
Disability and Life insurance
Employee Assistance Program
Remote work options
Generous Paid-Time Off
Annual Reviews and Development Plans
Retirement Plan with company match immediately 100% vested

Travel

This position requires minimal travel.

Required Education and Experience

Undergraduate degree in Information Systems or similar

Preferred Education and Experience

Familiarity with pharmacy claims coding terminology preferred
Degree or equivalent experience; preferably in a technology or technical business discipline
Intermediate level knowledge with any of the following: SQL Server or other RDMS, SSRS, or Power BI

RxCompass, LLC provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, RxCompass, LLC complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

RxCompass, LLC expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of RxCompass, LLC employees to perform their job duties may result in discipline up to and including discharge. EOE M/F/D/V

Requirements

Develop and optimize advanced SQL queries within Snowflake and SQL Server environments.
Design scalable data models supporting capture rate, savings, drug list management, and performance analytics.
Extract, transform, and validate pharmacy claims, eligibility, savings, and operational datasets.
Ensure reconciliation accuracy and reporting consistency across multiple systems and data sources.
Design, build, and maintain automated Power BI dashboards for RxCompass and Variable Copay.
Develop executive-ready visualizations supporting SLA performance, workforce metrics, vendor oversight, capture rate tracking, and savings realization.

Benefits

Dental Insurance
Vision Insurance
Disability Insurance
Life Insurance
Employee Assistance Program
Paid Time Off
Retirement Plan

Skills

Advanced SQL

Snowflake

Power BI

SSRS

Data Modeling

DAX

Power Query

Advanced Excel

About AI-Estimated Salary

The salary range shown was not provided by the employer. Our AI has estimated it based on the job title, required experience, location, and industry standards (confidence: 70%). This estimate should be used as a general guide only and may not reflect the actual compensation. Always confirm salary details directly with the employer during the application process.

Ready to Apply?

Join Southern Scripts today

Salary Range (AI-Estimated)*

$80,000 - $150,000

70% confidence

Posted 6 months ago

More Data roles you might like

Discover similar opportunities from companies that are also hiring remotely.

Chief Financial Analyst

Renmoney

Full Time

6 days ago

Who we are We’re a passionate team determined to challenge the status quo and make financial inclusion count for the millions of under-banked individuals and small business owners in Nigeria. We provide loans, savings, and fixed deposit solutions to our customers.

Worldwide

Data Science

Senior

Financial Modeling

Quantitative Analysis

Business Strategy

+5 more

Chief Financial Analyst

Renmoney

Full Time

6 days ago

Worldwide

Data Science

Senior

Financial Modeling

Quantitative Analysis

Business Strategy

+5 more

Nutrition Data Management and Analysis Consultant, Global Practice for Nutrition, 9.5 months, COE, Nairobi, Kenya (Remote) #595196

UNICEF

Contract

6 days ago

UNICEF works in over 190 countries and territories to save children’s lives, defend their rights, and help them fulfill their potential, from early childhood through adolescence. At UNICEF, we are committed, passionate, and proud of what we do for as long as we are needed.

Worldwide

Powerhouse Retail Services LLC

Data Science

Senior

Data Management

Database Development

epidemiology

+5 more

Explore more remote openings

Browse fresh listings from our global community of remote-friendly teams.

Project Manager - Commercial Construction

Full Time

6 days ago

Project Manager at Powerhouse Supercharge Your Career at Powerhouse! Powerhouse is looking for a motivated and detail-oriented Project Manager to join our growing team.

United States

Powerhouse Retail Services LLC

Senior

Project Management

Client Relationship Management

Construction Management

+5 more

Project Manager - Commercial Construction

Full Time

6 days ago

Project Manager at Powerhouse Supercharge Your Career at Powerhouse! Powerhouse is looking for a motivated and detail-oriented Project Manager to join our growing team.

United States

Cohen Law Group-Florida PA

Senior

Project Management

Client Relationship Management

Construction Management

+5 more

Insurance Litigation Attorney

Full Time

$150k - $250k

6 days ago

Help Us Build Our Arizona Practice What if your next opportunity wasn't just another job? Cohen Law Group is expanding its Arizona practice and looking for an Arizona-licensed attorney who is excited about the opportunity to help shape and grow our presence in the state.

United States

Legal

Mid

Litigation

Insurance Law

Case management

+5 more

Weekend Customer Service Representative (Part Time)

DIRAD TECHNOLOGIES INC

Part Time

6 days ago

This Part Time Customer Service Representative position will assist inbound callers with program inquiries and website utilization. Reliability and flexibility are both crucial for this role. Full training is provided!

United States

Entry

Customer Service

Verbal communication

Written Communication

+5 more

Technical Program Manager - Embedded Software

EnCharge AI

Full Time

$200k - $250k

6 days ago

EnCharge AI is building a new generation of AI compute systems designed to deliver dramatically higher energy efficiency for AI inference. Our technology combines innovative compute architectures with a full-stack software platform spanning silicon, firmware, drivers, compilers, runtimes, and AI…

United States

Staff

Technical Program Management

Embedded Software

Silicon Bring-up

+5 more

💥 Make an Impact Become a Life Insurance Producer

GIA Legacy Planning

Full Time

6 days ago

💥About Us: We are a forward-thinking life insurance agency that’s revolutionizing the way producers build their careers. Our mission is to provide outstanding protection for families while creating meaningful opportunities for individuals to grow their businesses within the life insurance industry.

United States

Entry

Sales

Insurance

Client Relationship Management

+5 more

Head of Growth

Richpanel

Full Time

$160k - $200k

6 days ago

Make Richpanel the company every CX leader knows before they need us. Richpanel is the AI-native helpdesk. We replace the old helpdesk and the next few support hires. We are profitable, backed by Sequoia Capital, and trusted by 3,000+ paying brands. Our team is small by design.

United States

Marketing

Growth Marketing

Senior

Product Marketing

Brand Marketing

Category Creation

+5 more

Creative Designer

Freebird

Full Time

6 days ago

Do you get the same charge from concepting a full campaign as you do from turning around a killer Amazon listing before the end of day? Can you jump from a paid social ad, to an email build, to a landing page, and make all of them feel unmistakably on-brand?

Canada

Design

Product Design

Senior

Visual Design

Figma

Campaign Concepting

+5 more

Senior Full-Stack Developer (Canada)

Proof

Full Time

CAD 135k - CAD 165k

6 days ago

About Proof We're Proof , a high growth company in the legal tech industry founded in 2017. We've built a best-in-class legal services platform used by thousands of law firms with a sustained average growth rate of over 10%.

Canada

Full Stack Engineering

Mid

React

TypeScript

+5 more

Senior Full-Stack Developer (Canada)

Proof

Full Time

CAD 135k - CAD 165k

6 days ago

Canada

Disability Management Institute

Full Stack Engineering

Mid

React

TypeScript

+5 more

Claims Coordinator (12-Month Contract)

Full Time

CAD 45k - CAD 55k

6 days ago

Claims Coordinator (12-Month Contract) Who We Are At Disability Management Institute (DMI), we deliver innovative, end-to-end disability and absence management solutions that transform how employers support their teams.

Canada