IRxS: Data Analyst (Pharmacy Benefits)

As a rapidly growing organization, Innovative Rx Strategies is distinguished by its commitment to advocating for clients both personally and financially while delivering measurable cost savings for employers and their employees. We are recognized for over a decade as a Best Place to Work, recipient of Healthiest Workplace awards, and The Platinum Bell Seal for Workplace Mental Health. Our team serves employers, benefits brokers, TPAs, health care systems, and health plans with deep understanding of the pharmacy benefits markets and health care industry trends. With expert knowledge, we are committed to one mission — breaking down a complex industry to save our clients' money on their benefits programs and manage their cost trends.

About the role

The Data Analyst will play a critical role in supporting the Health and Pharmacy Analytics team by ensuring data integrity, delivering actionable insights, and driving operational excellence. This position requires strong analytical skills, attention to detail, and the ability to collaborate across departments to optimize workflows and enhance client reporting. The ideal candidate will be proactive, adaptable to evolving technologies, and committed to continuous improvement in data processes and visualization, while contributing to strategic initiatives such as enterprise data modernization.

This is a remote, U.S.-based position operating primarily within the Eastern Time Zone. Travel is required for meetings, training, conferences, and/or client visits approximately 2-4 times annually, including occasional overnight stays. Preference is given to candidates in states where we currently employ team members: Indiana, Ohio, Illinois, Kentucky, Texas, North Carolina, Tennessee, and Pennsylvania.

Responsibilities

• Manage end-to-end client data ingestion, transformation, and deployment into secure cloud-based data warehouses
• Oversee onboarding of new client data feeds and maintain implementation documentation
• Collaborate with IT for secure data transfers and system enhancements
• Implement data retention and privacy protocols in collaboration with the Privacy team
• Ensure adherence to HIPAA and other regulatory requirements
• Design and optimize enterprise-level data workflows to improve efficiency and scalability
• Support enterprise migration to modern data platforms, including Microsoft Fabric, ensuring seamless integration and minimal disruption
• Convert complex datasets into actionable insights and client-friendly visualizations
• Maintain and deploy data visualizations (Power BI/Tableau) for internal and client use
• Generate ad-hoc benefit and utilization reports to support client-specific requests
• Build monthly, quarterly, and annual reports using tools like Power BI, Tableau, or SQL-based custom analysis
• Conduct annual benefit reconciliations to ensure compliance with carrier financial performance metrics
• Conduct disruption reporting for proposed benefit changes
• Partner with clinical teams and account managers to deliver actionable insights for benefit design and cost containment
• Conduct rigorous QA checks on client reporting metrics to ensure accuracy and consistency
• Develop scripts or workflows to automate recurring reporting and data validation tasks
• Track KPIs for benefit programs and provide recommendations for optimization
• Provide comprehensive support for RFP projects, including data preparation, validation, and collaboration with internal teams to ensure timely and accurate deliverables
• Coordinate timelines and deliverables for cross-functional projects involving analytics and reporting
• Perform data cleansing, normalization, and validation for RFP submissions
• Retrieve and validate Pharmacy Benefit Reports from internal systems to support Account Management and client deliverables

Requirements

• Bachelor’s degree required; Computer Science, Data Analytics, Health Informatics, Statistics, Mathematics, Information Systems, or a related field preferred
• Minimum 3 years of experience working with large datasets and performing data validation, cleansing, transformation, and reconciliation activities
• Proficient with SQL and other query-based technologies (e.g., Microsoft SQL Server, PostgreSQL, MySQL), with advanced skills in Microsoft Excel and the Microsoft 365 suite
• Knowledge of healthcare, pharmacy benefit management (PBM), prescription drug claims, health plan operations, or related healthcare data environments preferred
• Understanding of HIPAA requirements related to the collection, storage, and transmission of protected health information (PHI) preferred
• Experience gathering business requirements and translating stakeholder needs into analytical solutions preferred
• Strong attention to detail and intellectual curiosity, with a proven ability to investigate data anomalies, challenge assumptions, ensure data accuracy and quality, and continuously improve processes
• Experience creating reports, dashboards, and data visualizations using tools such as Tableau, Power BI, or similar business intelligence platforms
• Demonstrated aptitude for learning new software applications, questioning, and exploring data abnormalities
• Exceptional organizational skills; ability to manage multiple projects simultaneously; prioritize work independently; manage and meet multiple deadlines; work quickly with minimal supervision; show independent judgement, accuracy, and initiative
• Ability to learn and adapt to change quickly
• Able to demonstrate and always maintain discretion and confidentiality
• Must be able to function within a moderate noise level office environment
• Must be proficient in Word, Excel, along with project and database management

Pay

The starting salary for this position begins at $72,500. Final compensation will be determined based on experience, qualifications, internal equity, and market considerations.