Senior Data Analyst

Description

Looking for something BETTER? So were we! That’s why TrueScripts was created.But “better” didn’t stop there. That’s why we’re now looking for YOU!

What We’re About…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. And there is a reason that our company has been named the #1 Best Place to Work (for medium-sized employers) in Indiana for the past three consecutive years!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!
• Employee Assistance Program
• A 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
• 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.

In this FULLY REMOTE role, the Senior Data Analyst works with data related to health insurance claims, clients, drugs and members on a daily transactional level. This role 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. This senior level role involves taking a lead in projects and collaborating with cross-functional teams to ensure data-driven approaches to support business goals.

Responsibilities include:

· Building and maintaining the company’s data and analytics dashboards

· Performing analytics to guide development of new programs or assisting leadership in decision making.

· Promote analytics processes and standards established in the team/company.

· Creating ad hoc client reports as requested by the other departments.

· Aid in continuous improvement in data processing to respond faster to Analytics requests, such as creating simple SQL server views and tables as needed for other teams or an internal project.

· Have strong data troubleshooting or EDA skills to identify inconsistencies and errors in a complex data warehouse.

· Building and maintaining business process documentation related to the role.

· A deep understanding of the PBM industry is key for success, so the role requires willingness to learn and keep up with industry trends.

· Ability to summarize data/insights to business team members in a non-technical manner.

· Constructs data sets, monitors data quality, troubleshoots and resolves database issues to ensure data integrity.  

· Utilizes scripting and querying tools like Python, R or SQL, data visualization/BI tools, statistical methods, and data modeling to produce reports, data files, and dashboards. 

· Lead small projects independently and promote processes and standards established by the team and organization

· Collaborates with senior leadership and other departments to identify data-driven opportunities and provide insights that drive business growth.

· Mentor a team of Data Analysts, providing guidance and support to high-quality data analysis and reporting

Requirements

· Bachelor's degree in a related field.

· A minimum of 4-7 years of professional experience in a data analytics role

· Demonstrated experience leading projects

· SQL expert with ability to build complex queries, perform deep dive analytics, build basic views, stored procedures, functions etc.

· Advanced experience with PowerBI and Azure AAS or similar tools. Familiarity with complex DAX Development.

· Familiarity with Data Modelling concepts Star-vs-Snowflake Schema and data normalization.

· Familiarity with Enterprise data orchestration architectures like SSIS, ADF, Synapse, Data Lake etc.

· Excel expert for reporting and analytics using – charts and excel formulas.

· Excellent problem solving, analytical thinking, and attention to detail.

· Understanding of Database Concepts and the ability to interact technically with BI Developers and Business Analysts.