Healthcare Data Analyst II

University of Massachusetts Medical School
529 Main Street

View more

Administrative Jobs
Technology, Analysts & Programming
Employment Type
Full Time
Institution Type
Four-Year Institution

Job Details


About Health Care Finance Solutions and Benefit Coordination and Recovery Team:


Health Care Finance Solutions (HCFS) is part of Commonwealth Medicine (CWM), a division of UMass Chan Medical School.  CWM programs combine academic excellence and public health service expertise to provide health care solutions ideal for the public sector and not-for profit organizations.  CWM helps Massachusetts and many other state and local health care agencies increase the value and quality of health care expenditures and improve access and delivery of care to at-risk and uninsured populations.


HCFS helps state agencies identify opportunities to increase savings and reimbursements through federal and other third-party sources, establish effective savings and reimbursement programs, and capitalize on all possible revenue streams. At the same time, HCFS identifies opportunities for our clients to increase health care related services, reduce the net cost of delivery, and help ensure individuals receive the health and human service benefits to which they may be entitled.


Benefit Coordination and Recovery (BCR) programs, within HCFS are responsible for a wide mix of projects and initiatives that share a common link of coordinating Medicaid, Medicare and commercial insurance coverage for recipients of public health and human service benefits. Within HCFS and BCR, the Health Insurance Identification and Recovery (HIIDR) unit conducts critical operations to ensure the timely identification, verification and maintenance of commercial health insurance for MassHealth members to maximize coordination of benefits and cost avoidance. The unit is also responsible for the recovery of monies paid by MassHealth for medical services when other Third-Party Liability (TPL) resources are available and primary liability has been established. Using a data driven approach, the team is responsible for identifying, researching, developing, and implementing cost savings initiatives, through coordination of benefits on behalf of health and human service agencies.  Through each venture, BCR works to maximum benefits for recipients, while ensuring cost effectiveness for clients.


General Summary of Position:

The HIIDR unit is seeking a Healthcare Data Analyst II to support the unit’s data and reporting needs. Under the general direction of the Senior Manager or designee, the Healthcare Data Analyst II position will be responsible for the overall performance of the unit’s critical audit databases with focus on the data integrity and accuracy of commercial health information for MassHealth members. The role will be expected to maintain current queries and identify new opportunities for development making recommendations for such improvements. The role will perform data analyses for assigned projects and develop/ produce all related reports using various data sources. The Healthcare Data Analyst II will be expected to apply analytic consulting skills and utilize a customer service focus to design and deliver analytic products that meet or exceed client expectations. This position will be required to work on multiple concurrent projects while managing to successfully complete deliverables with an increasing level of independence. The position will also conduct information gathering to provide leadership with the necessary tools to determine the best data analytic practices to position the business unit for addressing client needs. The successful candidate will possess strong analytical and problem-solving ability, with attention to detail and accountability for work product. 



  • Conduct advanced data mining in a timely and accurate manner as required by the program/project.
  • Produce standard and adhoc analyses and reports using a variety of data which support the development, implementation and monitoring of programs/projects.
  • Integrate/manipulate large datasets from data sources (e.g. claims and encounter data) to support analyses using MS Excel, Access, SAS, SQL, COGNOS, and Business Objects.
  • Deploy standard qualitative and quantitative analysis techniques utilizing software packages such as SAS, SQL or Atlas.ti.
  • Contribute to the design of project-specific analytic plans, data manipulation and collection efforts; may include: claims analysis, interviews, focus groups, and surveys involving clients, state agency personnel, and other key informants.
  • Utilize and create standard testing measures and/or algorithms to test and analyze large amounts of data.
  • Design and develop data collection instruments, databases and procedure manuals based on thorough knowledge of data files, related databases, and systems integration.
  • Participate in the design and implementation of data management strategies/techniques and quality control procedures, including writing technical requirements and documentation of data sets.
  • Produce and submit data analysis reports. Develop methods and results narratives to be included in broader scientific reports developed by senior staff.
  • Ensure accuracy of all data analyses, reports and other deliverables by conducting thorough quality control checks and resolving discrepancies.
  • Provide interpretation of data for key stakeholders and leadership; including identifying and reporting data patterns and abnormalities. May be required to produce tabular and graphic summaries of analyses in a form suitable for inclusion in manuscripts for publication in peer reviewed scientific journals as well as for presentation at scientific meetings.
  • Schedule, coordinate, and review activities related to data collection and analysis in order to meet deadlines.
  • Communicate with all appropriate parties to ensure that the project’s objectives, scope, and expected deliverables of each project phase are understood. Facilitate communication of the project’s status, budget, costs, issues, and related information to same.
  • May provide guidance and training to more junior data staff as needed to help ensure accuracy and timeliness of deliverables.
  • Review and monitor compliance with the federal and state regulations.
  • Perform other duties as required.


  • Bachelor’s degree in a business, health sciences, or a related field; or equivalent
  • 4 years of related experience; including at least one year of healthcare data analysis
  • Demonstrated experience/skills in appropriate computer, statistical or database applications including SAS/SQL, Business Objects, Cognos or similar
  • Strong attention to detail and time management/organization skills to manage multiple priorities
  • Demonstrated ability to research issues and resources
  • Demonstrated ability to write reports, journal articles and/ or other technical documents
  • Excellent communication skills, both oral and written
  • Interpersonal skills necessary to interact successfully with a wide range of individuals.
Additional Information

Preferred Qualifications:


  • Knowledge in Health Insurance services utilization, reimbursement concepts, industry standard terminology and metrics relevant to Coordination of Benefits for Medicaid, Medicare and Commercial Payers.
  • Knowledge of Secure File Transfer protocols, Electronic Data Interchange (EDI) and HIPAA transactions.
  • Demonstrated experience/skills with Data Warehouse concepts and Cognos or other reporting tools.
  • Experience with the Medicaid Management Information System (MMIS).



Realize Your Opportunities – A Career at UMASS Medical School

Inside Workings at UMASS Medical School

The University of Massachusetts Medical School (UMMS), the Commonwealth's only public medical school, is proud of our role in serving the people of Massachusetts. Although, its the inside workings of UMMS that makes the difference.

Mission and Culture

  • We’re serious about our mission and about our people. 
  • Real World Impact - Our people get excited about our mission of real-world impact in health sciences education, research and public service.
  • International Prominence and New Opportunities - As this institution has grown to national – and international – prominence, we’ve found new opportunities to train tomorrow’s physicians, nurses and scientists,  discover causes of and cures for disease and help improve the quality of health care.
  • Deep Commitment - With our clinical partner, UMass Memorial Health Care, and our other teaching affiliates, we share a deep commitment to national distinction in patient care.
  • Valued Partnerships – UMMS partners with Commonwealth Medicine, the health care consulting arm of UMMS. Also, UMMS partners with MassBiologics in scientific collaborations, technology management and creating partnerships for the development of products for the benefit of patients.  These valued partnerships help us to provide services and programs to help meet our needs at UMMS and the public.
  • Proud Contributors - People at UMMS enjoy the feeling of going to work every day knowing what they do is truly important and worthwhile.
  • Complementary and Inseparable - These varied parts of our mission and culture are complementary and inseparable.                 


UMMS, the state’s first and only public academic health sciences center, educates physicians, scientists and advanced practice nurses to heal, discover, teach and care, with compassion.  UMMS is a world-class institution with opportunities to match. 

Competitive Compensation – UMMS offers salaries that are competitive with Worcester-area employers. When combined with our generous benefits, perks, and paid time off, many job seekers are surprised to find a total rewards package that matches or exceeds their current situation.

Targeted Hiring Process – At UMMS, there are actually multiple hiring processes for different segments of our workforce.  In nearly all cases, UMMS hiring process is decentralized, with qualified candidates screened and referred to an academic officer or manager with hiring authority.

24/7 Access to Employment Opportunities – iCIMS is our online job search and application system.  iCIMS is available 24/7 to provide you with a convenient and up-to-date view of the available employment opportunities across our campuses. Updates are made daily and include all faculty and non-faculty position listings from every school and department within the UMMS. When you identify a position you are interested in and qualified for, apply online. New opportunities become available frequently so it pays to check back often!


With outstanding benefits, competitive pay, extensive learning opportunities, and a stimulating and attractive work environment, UMMS may be exactly the employer you’ve been looking for.

• Superior Benefits - UMMS offers a wide range of benefits and perks that invite comparison with the best employers in the Worcester area – and with academic institutions anywhere. UMMS provides superior medical and dental coverage for you and your family, fully funded retirement plans, generous time off, a Tuition Assistance Plan – and much more.

• People Centered - UMMS is an employer, but it is also a community. Its comprehensive medical and dental benefits, retirement plans, and even paid holidays reflect an institution built around people, with a deep respect for their differences and needs.

• Commitment to Healthy Living - UMMS provides resources to help you balance work and life and encourages healthy living through great programs and discounts for fitness, physical activity, weight management, nutritional counseling and general wellness available through our health insurance plans.

• Breadth of Offerings - Above all, the breadth of UMMS offerings set the School apart and makes it an environment favored by all sorts of smart, career-savvy people.

Apply for a Job

As an equal opportunity and affirmative action employer, UMMS recognizes the power of a diverse community and encourages applications from individuals with varied experiences, perspectives and backgrounds.

Online - To view all job opportunities and apply online, visit and click on the “Careers” tab.

Start Now and Realize Your Opportunities!

A History of Making Vital Improvements - UMASS Medical School Milestones

1962: Legislation establishes University of Massachusetts Medical School
1970: First medical students begin classes in Shaw Building
1974: First class graduates 16 MDs
1979: PhD program begins
1986: Graduate School of Nursing opens
1986: PhD program becomes Graduate School of Biomedical Sciences
1994: Graduate School of Nursing initiates PhD program
1998: UMass Clinical System and Memorial Health Care merge to form UMass Memorial Health Care
2001: Lazare Research Building opens
2002: Campus Modernization begins on the University Campus
2004: Graduate Entry Pathway Program established at the Graduate School of Nursing
2005: PhD Program in Clinical & Population Health Research established at the Graduate School of Biomedical Sciences
2005: Massachusetts Biologic Laboratories opens new manufacturing and filling facility in Mattapan
2006: Craig Mello, PhD, Blais University Chair in Molecular Medicine and Howard Hughes Medical Institute Investigator, is awarded the Medical School's first Nobel Prize. Dr. Mello shared the 2006 Nobel Prize in Physiology or Medicine with Andrew Fire, PhD, of Stanford University, for their discoveries related to RNA interference.
2007: Michael F. Collins, MD, is named chancellor and Terence R. Flotte, MD, is named dean of the School of Medicine.  
2009: Groundbreaking for the Albert Sherman Center, a 500,000-square-foot research and education facility slated for completion in 2012.
2010: Ambulatory Care Center opens
2012: The Albert Sherman Center, a 500,000-square-foot research and education facility, completed and opens

Get job alerts

Create a job alert and receive personalized job recommendations straight to your inbox.

Create alert