Company:
University of Massachusetts Medical School
Location: Charlestown
Hours: Full Time
Type: Permanent
Job Requirements / Description
Overview:
GENERAL SUMMARY OF POSITION:
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
Responsibilities:
MAJOR RESPONSIBILITIES:
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.
Qualifications:
REQUIRED QUALIFICATIONS:
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:
PREFERRED QUALIFICATIONS:
Master’s degree in Public Health, Biostatistics, or Informatics.
GENERAL SUMMARY OF POSITION:
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
Responsibilities:
MAJOR RESPONSIBILITIES:
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.
Qualifications:
REQUIRED QUALIFICATIONS:
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:
PREFERRED QUALIFICATIONS:
Master’s degree in Public Health, Biostatistics, or Informatics.
Share this job
Useful Links