Data Analyst

TrueScripts Management Services; Washington (IN); On-site; USD 70,000 - 100,000; Full time

Benefits offered by this job

Health insurance

Bonus program

401k with match

ESOP ownership

Wellness program

Team celebrations

Job summary

TrueScripts Management Services is a pharmacist-founded, fully transparent Prescription Benefit Manager that has been revolutionizing the PBM industry since 2014. This Data Analyst role focuses on health insurance claims data, client and member data, and drug data to identify trends and drive decisions.

You will wrangle data, build Power BI dashboards, create client reports, and develop program metrics. The position works remotely with a collaborative, value-driven culture emphasizing integrity,

Qualifications

• Bachelor’s degree with 2+ years’ data analysis experience or a related Master’s degree.
• Strong SQL skills and ability to build complex queries.
• Experience with Power BI or Tableau and Azure Analysis Services.
• Advanced Excel skills including formulas and pivot tables.
• Ability to collaborate with technical and non-technical stakeholders.
• Understanding of data warehousing principles.
• Strong data validation and quality assurance capabilities.
• Experience leveraging AI tools to improve productivity.

Responsibilities

• Collect, analyze, and interpret large datasets to identify trends.
• Build Power BI dashboards and client reports.
• Develop metrics and insights for program development.
• Collaborate with cross-functional teams to support business goals.
• Perform quality assurance reviews of reports and data.
• Leverage AI tools to improve reporting and analytics workflows.
• Document data processes and maintain data quality standards.

Skills

SQL

Power BI

Azure Analysis Services

Excel (Advanced)

Data analysis

Data warehousing

QA & validation

Stakeholder collaboration

AI tools

Education

Bachelor’s degree + 2+ years data analysis experience

Master’s degree in related field

Tools

Power BI

Tableau

Azure Analysis Services

Excel

SQL

Job 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

• 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 wellness program including financial incentives, chiropractic and massage services, and fitness stipends
• A cohesive, family-based culture
• Charitable contributions and volunteer time
• Lots of celebrations!

Job Type

Full-time

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 wellness program including financial incentives, chiropractic and massage services, and fitness stipends
• A cohesive, family-based culture
• Charitable contributions and volunteer time
• Lots of celebrations!

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.

What you’ll do

The Data Analyst at TrueScripts Management Services deals with data related to health insurance claims, client, drugs and members on a daily transactional level. The Data Analyst will collect, analyze, and interpret large datasets to identify trends and insights that inform business decisions. Responsibilities include data wrangling, building PowerBi dashboards, creating client reports, developing metrics and insights for program development. The role also involves collaborating with cross-functional teams to ensure data-driven approaches to support business goals.

Principal Roles And Responsibilities

• Build and maintain the company's data and analytics dashboards.
• Perform analyses that support business decisions, identify opportunities, and guide development of new programs and initiatives.
• Create custom reports and data extracts to support client, compliance, and internal business needs.
• Support continuous improvement efforts by developing and enhancing data solutions, including simple SQL views, tables, and other reporting assets.
• Build and maintain process documentation, reporting standards, and team knowledge resources.
• Troubleshoot complex data issues and perform exploratory data analysis to identify inconsistencies, trends, and opportunities for improvement within the data warehouse.
• Demonstrate curiosity and a willingness to learn new business concepts, industry trends, and analytical techniques.
• Work collaboratively across departments and communicate effectively with team members, business partners, and leadership.
• Perform quality assurance reviews of reports, analyses, and data deliverables to ensure accuracy, consistency, and adherence to team standards.
• Leverage AI tools and emerging technologies to improve productivity, streamline reporting and analytics processes, and support innovative problem-solving.

Requirements

Education:

• Bachelor’s degree with 2+ years’ experience as a Data Analyst or related role; or a Master’s degree in a related field.

Technical Skills

• Strong SQL skills with the ability to build complex queries and perform data analysis.
• Experience with Power BI/Tableau, Azure AAS, or similar reporting and analytics tools.
• Advanced Excel skills, including formulas, pivot tables, and reporting.
• Strong analytical, problem-solving, and data troubleshooting skills.
• Understanding of database concepts and data warehousing principles.
• Ability to collaborate effectively with technical and non-technical stakeholders.
• Strong quality assurance, data validation, and attention-to-detail skills.
• Ability to leverage AI tools to improve productivity, reporting, and analytical workflows.

Work Environment

This role is a remote job with a flexible "8-5" 40 to 45-hour workweek. All employees of TrueScripts must understand and adhere to Confidentiality and Personal Health Information (PHI) Guidelines as stated in the Employee Handbook.

Physical Demands

While performing the duties of this job, the employee is frequently required to sit, use hands and fingers and to type for up to eight hours in a workday.