Analyst, Data Management (Salesforce)

Molina Healthcare•Long Beach, CA

About The Position

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. Salesforce, CMS and State-specific). 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, when appropriate, to help the Quality Assurance Analyst identify root causes to data issues. 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.

Requirements

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.
Salesforce background
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

Responsibilities

Extract and compile various sources of information and large data sets from various systems or applications, Salesforce included.
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.