Reporting Analyst at TrueScripts Management Services

Washington, Indiana, United States -

Full Time

Start Date

Immediate

Expiry Date

11 Jun, 26

Salary

0.0

Posted On

13 Mar, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Analysis, Reporting, Power BI, SQL Server, Excel, PowerPoint, Data Auditing, Claims Analysis, Business Intelligence, CRM Systems, Communication, Problem-Solving, Attention To Detail, Prioritization, PBM Industry Knowledge, SQL Querying

Industry

Pharmaceutical Manufacturing

Description

Description TrueScripts Management Services is a pharmacist-founded, fully transparent Prescription Benefit Manager that has been revolutionizing the PBM industry since 2014. Our mission is to build lasting relationships by providing prescription benefit expertise at a personal and customized level to ensure optimum value at the lowest possible cost. We are committed to lowering prescription drug spending, achieving clinically effective outcomes, and always delivering Amazing Care.Did we mention Amazing Care? Good! Because this is so much more than just our tagline. It is the foundation upon which our business was built. We believe that Amazing Care starts from within, and our culture is reflective of this philosophy. Our team members enjoy: A wide range of health insurance options including medical, dental and vision A strong salary and bonus program A robust 401k and company match Truescripts is transitioning to an ESOP, a team member owned company! Each year team members are allocated shares of stock through our ESOP, a Qualified Retirement plan! A flexible work environment A 5-star wellness program including financial incentives, chiropractic and massage services, and fitness stipends Dream Manager Program (yes, it’s a real thing!) A cohesive, family-based culture Charitable contributions and volunteer time Ok, enough about us. Here’s what we need from you: A future team members' values need to align with TrueScripts' core values of Integrity, Respect, Innovation, and Service. This match in value systems is critical for our team's chemistry and continued success. Our culture is positive, and our people possess a ‘can do, proactive attitude. Honesty and transparency are the foundation that we build upon. What sets us apart from our competitors is the programs that we bring, the education that we provide, and the utmost respect for clients and their members to assist them when and where needed. Position Overview: The Reporting Analyst plays a key role in supporting Client Success, Business Development, Member Care, and Executive leadership. This role is responsible for analyzing health insurance claims, client data, and member information within our Microsoft Business Intelligence ecosystem. You will deliver clear, actionable insights that help clients understand their data, identify cost drivers, and achieve better healthcare outcomes. Primary Responsibilities • Prepare, analyze, and deliver reporting for client requests, standard client Rx review reports, new client repricing, Power BI dashboards, and quality audits. • Build a deep understanding of PBM industry operations and client data environments. • Leverage both business and technical skills to work effectively across Business Intelligence, CRM systems, and transactional claims data. • Conduct thorough quality audits on all analyses and reports prior to department distribution. • Partner with business process owners to recommend and implement continuous improvements. Repricing Analysis & Reporting • Analyze legacy PBM claims for accuracy and completeness. • Prepare repricing analyses for broker review and support accurate claims ingestion into I.R.I.S. Analytics. • Document and refine repricing processes to increase speed and consistency. Client Rx Review Reporting • Analyze Rx review reporting for accuracy and completeness • Provide clear analysis to help clients understand key cost drivers. • Create polished summary reports and presentations in PowerPoint and/or Excel. Data & Technical Work • Work closely with cross-functional teams to understand business requirements. • Utilize Power BI to develop and maintain reporting and dashboards. • Deliver reports in Excel, PDF, and PowerPoint formats, tailored to stakeholder needs. • Utilize SQL Server to query, prepare, and analyze datasets within I.R.I.S. Analytics. Requirements Education • Associate degree and 2+ years of experience as a Reporting Analyst, with education focused on data analytics or business management. Communication Skills • Comfortable working directly with senior leadership as a subject-matter expert. • Skilled at translating complex technical information for non-technical audiences. • Clear, concise verbal and written communication across all organizational levels. • Willingness to ask questions—even difficult ones—to ensure clarity and accuracy. • Strong ability to prioritize and manage multiple tasks in a fast-paced environment. • Team-oriented mindset with a collaborative work style. Technical Skills • Strong analytical thinking, problem-solving, and attention to detail. • Understanding of database concepts and ability to communicate with BI developers. • Ability to write and interpret SQL queries (or ability to learn quickly). • Advanced proficiency in Microsoft Excel and PowerPoint (or ability to learn quickly). • Strong overall Microsoft Office 365 skills. • Ability to learn PBM industry concepts and workflows. • Awareness and appreciation of information security best practices

Responsibilities

The Reporting Analyst will prepare, analyze, and deliver various reports, including client requests, standard Rx reviews, and Power BI dashboards, while supporting Client Success and Executive leadership. This role involves analyzing health insurance claims and client data to deliver actionable insights on cost drivers and healthcare outcomes.