Business Intelligence Analyst - REMOTE

Business Intelligence Analyst - REMOTEThe 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 DevelopmentDevelop 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 ReportingDesign, 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 IntelligenceBuild 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 SupportDevelop 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 & GovernanceAutomate 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 PartnershipServe 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 CompetenciesAdvanced 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. Preferred QualificationsExperience 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 WorkFull-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 OfferOur 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 TravelThis position requires minimal travel. Required Education and ExperienceUndergraduate degree in Information Systems or similar Preferred Education and ExperienceFamiliarity 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