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, state, and local law. 

Qualifications – what you need to perform the job

Requirements

JOB QUALIFICATIONS: KNOWLEDGE/SKILLS/ABILITIES

EDUCATION: BS in Mathematics, Computer Science, Information Management, Statistics or similar.

EXPERIENCE:  At least 1-3 years relevant experience in an analytics group, preferably related to Sales & Marketing

SKILL REQUIREMENTS:

• Effective ETL (Extract/Transform/Load), data shaping and data wrangling skills are critical to success in this role. Knowledge of tools such as Alteryx/Microstrategy is preferred but not required, while exceptional knowledge of Microsoft Excel, experience with SQL/Access will be necessary.
• Exposure to Tableau as a report/dashboard building tool required, legitimate experience is preferred.
• Effective BI and Analytic skills are critical to company growth as we move forward with our next gen performance optimization deployment.
• Seeking a candidate with excellent verbal and written communication skills to attend stakeholder meetings, gather complex requirements from business partners, present findings back out, and document work procedures.
• Should work well within a team environment and be highly motivated and self-directed.
• Mathematical problem solving, statistical, and analytical skills are required.
• Must have strong relationship building skills to channel issues effectively toward resolution.
• Knowledge and experience with different types of database structures, joins and data blending techniques.
• Developing presentation skills, presents mostly within department and to project teams
• Experience writing and modifying Python and/or VBA code is a plus.
• Increasingly applies own judgment to analytical/technical issues

Compensation & Total Rewards Overview

As part of our comprehensive total rewards program, colleagues are also eligible for variable pay. Eligibility for any bonus, commission, benefits, or any other form of compensation and benefits remains in the Company's sole discretion and may be modified at the Company’s sole discretion, consistent with the law.

Point32Health offers their Colleagues a competitive and comprehensive total rewards package which currently includes:

• Medical, dental and vision coverage

• Retirement plans

• Paid time off

• Employer-paid life and disability insurance with additional buy-up coverage options

• Tuition program

• Well-being benefits

• Full suite of benefits to support career development, individual & family health, and financial health

For more details on our total rewards programs, visit https://www.point32health.org/careers/benefits/

Commitment to Diversity, Equity, Inclusion, Accessibility (DEIA) and Health Equity

​Point32Health is committed to making diversity, equity, inclusion, accessibility and health equity part of everything we do—from product design to the workforce driving that innovation. Our Diversity, Equity, Inclusion, Accessibility (DEIA) and Health Equity team's strategy is deeply connected to our core values and will evolve as the changing nature of work shifts. Programming, events, and an inclusion infrastructure play a role in how we spread cultural awareness, train people leaders on engaging with their teams and provide parameters on how to recruit and retain talented and dynamic talent.  We welcome all applicants and qualified individuals, who will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.

Scam Alert: Point32Health has recently become aware of job posting scams where unauthorized individuals posing as Point32Health recruiters have placed job advertisements and reached out to potential candidates. These advertisements or individuals may ask the applicant to make a payment. Point32Health would never ask an applicant to make a payment related to a job application or job offer, or to pay for workplace equipment. If you have any concerns about the legitimacy of a job posting or recruiting contact, you may contact TA_operations@point32health.org