Analyst, Data Management (CMS Network - MA HealthPlan)

Molina Healthcare•Long Beach, CA

17d

About The Position

This role will support the Massachusetts Health Plan Job Summary Under general supervision, this position has lead responsibilities for accessing, integrating, data compilation, data management, data analysis, data quality controls and reporting from various Molina Healthcare systems (e.g., QNXT, and Med Insight) and/or related external systems (e.g. CMS and State-specific) and direct ownership of files for CMS regulatory submissions. This position will conduct exploratory and discovery studies that include assessing requirements, current state gap analysis, comparison to best practices and presenting the finding and recommendations to management. The Data Analyst will be responsible to provide insight into data trends, drawing broad conclusions and create actionable management reports that can be used to identify opportunities to improve data quality and ensure data governance principles, rules, use and practices are maintained. The Data Analyst will run investigative queries, help identify root causes to data issues and support strategic and contractual network management. This resource may also be utilized for ad hoc data requests and/or assistance with special project management activities. Additional responsibilities may include creating presentations and other collateral in support of those same business requests. Knowledge/Skills/Abilities

Requirements

Strong knowledge of CMS Network Adequacy and regulatory submission requirements
Extract and compile various sources of information and large data sets from various systems or applications.
Contribute and adhere to all phases of the data development lifecycle including – capture data requirements, solution design, specifications, code and test phases (unit, acceptance).
Develop test plans and test cases, report test results and test analysis; analyze and recommend improvements based on testing results.
Develop and demonstrate ongoing support data controls that detect data defects.
Set up process for monitoring, tracking and trending information and data using various systems or applications.
Gather and monitor Data Quality KPIs in relation to Master Data Management requirements and Data Quality Controls tolerances
Research perform profiling tasks on data quality dimensions and analyze report results identifying opportunities and trends.
Prepare well organized, easily understood reports, analysis, and summary of findings for use by management
Work with internal, external, and enterprise individuals as needed to research, develop and document new standard reports or processes.
Consolidate data from multiple sources using industry based tools or manually be able to process and profile data.
Conduct Peer Reviews.
Support team members and others when additional analytics are required.
Participates in special projects and initiatives that are designed to improve data quality.
Keeps abreast of industry best business practices and makes suggestions to management on how to improve current practices.
Performs special projects upon request.
Bachelor's degree (BA or BS) in related field.
At least 5 years in related data management field.
Experience with MS Office applications, SQL and relational database required.
Basic level of programming skill with SQL, scripting language such a as Python and/or PERL, or SAS.
Alternate programming experience may substitute.

Nice To Haves

BA or BS in Business, Statistics, Mathematics, Computer Science, Information Management, Information Technology or a related data management field. A Master's degree or certification as Certified Data Management Professional (CDMP), Microsoft SQL Server, Oracle Enterprise Management or related information management field.
Experience with multiple data systems, data conversion, data migration, data profiling, data modeling.
Ability to use data cubes to extract data.
Experience with Master Data Management (MDM), ETL, and/or Data Quality Management (DQM) platforms a plus
Knowledge of Massachusetts provider network and state-specific regulatory requirements related to provider data management.

Responsibilities

Accessing, integrating, data compilation, data management, data analysis, data quality controls and reporting from various Molina Healthcare systems (e.g., QNXT, and Med Insight) and/or related external systems (e.g. CMS and State-specific)
Direct ownership of files for CMS regulatory submissions
Conduct exploratory and discovery studies that include assessing requirements, current state gap analysis, comparison to best practices and presenting the finding and recommendations to management.
Provide insight into data trends, drawing broad conclusions and create actionable management reports that can be used to identify opportunities to improve data quality and ensure data governance principles, rules, use and practices are maintained.
Run investigative queries, help identify root causes to data issues and support strategic and contractual network management.
Ad hoc data requests and/or assistance with special project management activities.
Creating presentations and other collateral in support of those same business requests.