
and Advance with Us.
SEARCH CAREER OPPORTUNITIES
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
Salary Grade: 46
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.
HR Blog
UMass Chan Medical School was among 23 companies that stood out as 2023 “DEI champions,” according to The Boston Globe.
“2023 BEST MEDICAL GRAD SCHOOL”
for Primary Care and Research

