Liviniti is a company focused on providing strategic data and analytics solutions. The Business Intelligence Analyst will lead data-driven initiatives across RxCompass and Variable Copay programs, automating reporting solutions and developing executive dashboards to enhance performance visibility and decision-making.

Responsibilities:

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
Standardize KPI definitions and reporting frameworks across both programs
Apply strong data storytelling and visualization best practices to enhance decision-making clarity
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
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
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
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

Requirements:

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
Undergraduate degree in Information Systems or similar
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)
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

Liviniti

Open Positions (1)

Data

Business Intelligence Analyst - REMOTE