Data Analyst

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.