You are using the web browser we don't support. Please upgrade or use a different browser to improve your experience.
"icon arrow top"

Healthcare SQL Programmer - REMOTE


UMass Med School


Charlestown, United States

United States

Healthcare & Medical




Not specified

Permanent | Full Time

Minimum Salary

Job Location
3 days ago(10/4/2023 8:41 AM)

Requisition Number

# of Openings

Posted Date


Exempt/Non-Exempt Status
Non Union Position -W60- Non Unit Professional


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


  • Master's degree in Public Health, Biostatistics, or Informatics.

  • Loading please wait...