Share This Page
Explore the Possibilities
and Advance with Us.

When you join the UMass Chan Medical School team, you join us in advancing together to improve the health and well-being of our diverse communities throughout Massachusetts and across the US and the world. Together, we lead in education, research, health care delivery, and public service. Your life’s work is more than a career. It’s an expression of your passion, intellect, skill, and drive. UMass Chan's commitment to excellence, innovation, competitive benefits, and work-life integration will allow you to build a professionally rewarding career as we work together to better or improve the health of people around the globe.

Sr Healthcare Data Analyst - HCFS - Hybrid
Job Number: 2022-40584
Category: Administrative Professional
Location: Shrewsbury, MA
Shift: Day
Exempt/Non-Exempt: Exempt
Business Unit: ForHealth Consulting
Department: Commonwealth Medicine - PPR - W407625
Job Type: Full-Time
Union Code: Non Union Position -W60- Non Unit Professional
Num. Openings: 1
Post Date: July 3, 2022

Under the general direction of the Director or designee, the Sr. Healthcare Data Analyst - HCFS needs to be insightful, detail-oriented professional with excellent analytical skills who is able to apply that skill set to data analysis, data mining and data management within a medically-oriented, dynamic analytic team.

• Conduct advanced data mining as required by the program.
• Lead analyses and produce standard reports using healthcare claims encounter, financial eligibility and/or other data to support the development, implementation, and monitoring of client services programs.
• Develop and/or utilize SAS/SQl code to support analyses-of large datasets from multiple systems and produce desired data or report outputs.
• Utilize strong analytic consulting skills, and a customer service focus in order to design and deliver analytic projects to client specifications.
• Assist in the use of qualitative and quantitative analysis techniques.
• Utilize and create testing measures to analyze large amounts of data.
• Create algorithms to test and analyze multiple, large databases.
• Run ad hoc queries and data analysis investigations.
• Create, troubleshoot and maintain program and project databases for ongoing operations.
• Develop analyses and present information using various tools including SAS, Business Objects, SQL and Cognos and MS Office.
• Independently identify and report data patterns and abnormalities.
• Provide analysis of key metrics and data trends.
• Demonstrate exceptional analytic and problem-solving skills.
• Test, track and monitor data for quality, integrity and trends.
• Work with managers to develop PowerPoint presentations for clients and/or trainings as necessary.
• Draft and prepare quarterly project reports and monthly Key Metric and revenue management reports.
• Merge multiple databases and data sources to produce answers to complex business questions or needs.
• Develop queries and reports that will assist managers with monitoring the productivity of staff.
• Assist with all systems-related technical issues and transitions, support routine IT work including business unit testing, and attend systems related meetings.
• Demonstrate attention to detail and deliver quality work products.
• Other responsibilities and projects as assigned.

REQUIRED EDUCATION
Bachelor’s Degree in healthcare, health business administration, public health, public policy, statistics or similar discipline or equivalent experience.

REQUIRED WORK EXPERIENCE
5-7 years related or equivalent experience with proficiency in Medical Claims Analysis, Financial Data Analysis, and/or Transaction-Based Data Analysis
Advanced knowledge of data mining software tools such as SAS, SQL, BO, Cognos or similar
Advanced SAS/SQL programming skills
Demonstrated knowledge of Microsoft Office Applications
Ability to merge multiple databases and data sources to produce answers to complex business questions
Familiarity with coding systems (i.e., CPT, ICD9, ICD10) and hospital billing systems (DRGs)
Demonstrates intellectual curiosity, takes initiative and focuses on continuous improvement
Ability to learn quickly and multi-task in a fast paced, work environment
Ability to communicate verbally and in writing in English in a clear, professional manner
Ability to travel between locations

- Position is in Public Provider Reimbursement unit within HCFS, which performs revenue claiming, coding and benefits work for 10 Commonwealth Human Service agencies. 

- Position will specifically work with revenue and benefit data related to Department of Developmental Services (DDS) clients, which serves approximately 35,000 clients annually.  

- Primary duties include database creation and documentation, query using Meditech and MMARS data warehouse, data analysis, report writing and remit reconciliation, while ensuring data integrity are.

- Ability to work with large amount of data using DDS program knowledge.

- Ability to work independently and prioritize work tasks based on department needs.

- Hybrid work - majority of work will be remote, but some in person meetings may be necessary to work with staff who have data needs as safety allows.

-  COVID vaccine and booster required.

Posting Disclaimer:
This job posting outlines the primary responsibilities and qualifications for the role but is not intended to be an exhaustive list. Duties and expectations may evolve in response to the needs of the department and the broader institution.

In alignment with our commitment to pay transparency, the base salary range for this position is listed above (exclusive of benefits and retirement). At UMass Chan Medical School, final base salary offers are determined based on a combination of factors, including your skills, education, and relevant experience. We also consider internal equity to ensure fair and consistent compensation across our teams.

Please note that the range provided reflects the full base salary range for this position. Offers are typically made within the midrange to allow for future growth and development within the role.

In addition to base pay, UMass Chan offers a comprehensive Total Rewards package, which includes paid time off, medical, dental, and vision coverage, and participation in a 401(a)-retirement plan, with the option to contribute to a voluntary 403(b) plan.

UMass Chan welcomes all qualified applicants and complies with all state and federal anti-discrimination laws.