Healthcare SQL Programmer - REMOTE

Company:  University of Massachusetts Medical School
Location: Charlestown
Hours: Full Time
Type: Permanent
Job Requirements / Description


Under the general direction of the Manager or designee, the Sr Data File Architect will lead and develop data analyses for assigned projects and develop/deliver all related reports.  This position will be responsible for creating detailed Fraud Analytic Queries and Reports to identify aberrant claims paid to Medicaid providers. Interacting with business users, and communicating business needs, this position will have the general responsibility for generating files, reports and datasets upon requests, which may entail generating code in SQL or SAS to extract data from the Data Warehouse and generate output files in a format as requested by users or others, as directed.  This position will also support other CHCF as needed


Perform Comprehensive data analytics.

Provide subject matter expertise of MassHealth Data.

Execute DW projects, help create a project plan and deliver solutions.

Gather requirements through JAD sessions, manage scope, verify requirements through data analysis and develop business requirement document.

Develop excellent quality business and technical documentation for DW users, QA and Development team.

Responsible for setting expectations of the stakeholders after proper verification of the requirements.

Utilize strong analytic consulting skills, and a customer service focus to design and deliver analytic projects to client specifications.

Develop work flows, data flows and business process flow etc. diagrams.

Use alternative techniques to dissect, analyze and present data.

Manage/deliver workstreams from start to finish.

Document SQL code and process that can be used by DW team and power users of DW.

Mentor other analysts and provide query writing support and data explanation to end users.

Thorough knowledge of data warehouse principles and techniques.

Have experience with data warehouse-based operations, analytic functions and query generation

Command of data warehouse concepts

Use data modeler to create Entity relationship diagrams.

Create Data Linage based on Source to target objects.

Strong knowledge of Cognos cubes and query packages

Demonstrate exceptional analytic and problem-solving skills

Extensive experience working with Medicaid Management Information System (MMIS)

Create appropriate agenda for the meetings and get the right resources for productive work sessions/meetings.

Strong knowledge of MMIS tables.

Other responsibilities and projects as assigned.


Bachelor's degree in healthcare, health business administration, public health, public policy, statistics or similar discipline; or equivalent.

10 years related or equivalent experience with proficiency in Medical Claims Analysis, Financial Data Analysis, and/or Transaction-Based Data Analysis

10 years of Advanced knowledge of data mining software tools such as SAS, SQL, BO, Cognos or similar

10 years of 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

Additional Information:

Master’s degree in Public Health, Biostatistics, or Informatics.

Apply Now
Share this job
  • Similar Jobs

  • Healthcare Auditor - REMOTE

    View Job
  • Audit Manager - Fraud Waste and Abuse - REMOTE

    View Job
  • Regional Contract Manager - REMOTE - MUST LIVE IN MA!

    View Job
An unhandled exception has occurred. See browser dev tools for details. Reload 🗙