Business Data Reporting Analyst

Who We Are

Point32Health is a leading health and wellbeing organization, delivering an ever-better personalized health care experience to everyone in our communities. At Point32Health, we are building on the quality, nonprofit heritage of our founding organizations, Tufts Health Plan and Harvard Pilgrim Health Care, where we leverage our experience and expertise to help people find their version of healthier living through a broad range of health plans and tools that make navigating health and wellbeing easier.

We enjoy the important work we do every day in service to our members, partners, colleagues and communities. To learn more about who we are at Point32Health, click here.

Job Summary

This multifaceted position allows the individual to participate in all aspects of analytics including extraction/transforming/loading, analyzing and visualizing data. Analytics projects support the goal of providing a value based product that is competitively priced and increases the quality of care provided to our members. Workload focus includes consulting with our partners in Sales & Marketing to gather requirements, data wrangling, data shaping and data loading to support trend analysis. The individual will meet these needs through the use of various software packages including Alteryx, Tableau, SQL, Salesforce, MS Excel and Access. Day-to-day work is a combination of new projects, maintaining existing projects, standard reporting, and business analysis to aid in the Sales & Marketing process. This role will work closely with a variety of THP departments including Sales, Marketing, Product and Strategy.

Key Responsibilities/Duties – what you will be doing

KEY RESPONSIBILITIES/ESSENTIAL FUNCTIONS* (in order of importance)

Evaluate and analyze healthcare sales and marketing data; use Tableau, Alteryx, MS Excel and Access to design and develop reports by extracting, shaping and loading data from various well-defined sources

Work with Salesforce CRM system as key source of sales and marketing data, creating reports both within the Salesforce system and outside it

Ensure that all reports and analyses are accurate, complete, and produced within required timeframes. Support continuous improvement through iterative processes by being proactive to reduce ad hoc requests.

Work with large amounts of raw data to cleanse and transform data into clean, useable workflows utilizing tools such as Alteryx, SQL, Excel and Access.

Identify, analyze, and interpret trends or patterns in complex data sets identifying return on investment

Communicate complex ideas via dashboards and reporting visualizations to Sales and Marketing teams

Build connections between disparate data sources ensuring data integrity is maintained, modify existing workflows to add new data points as they become available and/or necessary for the business.

Review numbers, trends, and data to discover actionable conclusions based on findings, and later present those findings to business partners at various levels within the company

WORKING CONDITIONS AND ADDITIONAL REQUIREMENTS: Fast paced office environment handling multiple demands. Exercise appropriate judgment as needed. Normal office conditions.

• Hybrid to fully on-site position, on-site setting is open cubicle. Works on personal computer approximately 80% of the time.

CONFIDENTIAL DATA:  All information (written, verbal, electronic, etc.) that an employee encounters while working at Tufts Health Plan is considered confidential.  Exposed to and required to deal with highly confidential and sensitive material and must adhere to corporate compliance policy, department guidelines/policies and all applicable laws and regulations at all times.

What we build together changes our customer's health for the better.  We are looking for talented and innovative people to join our team.  Come join us!

As of Nov. 1, 2021, full vaccination against COVID-19 is required to enter any Point32Health office or if, on behalf of Point32Health, you are meeting in-person with individuals outside of a Point32Health office. As of Dec. 8, 2021, all employees — including remote employees — must be fully vaccinated. This position will require the successful candidate to show proof of full vaccination against COVID-19. Point32Health is an equal opportunity employer, and will consider reasonable accommodation to those individuals who are unable to be vaccinated consistent with federal, st