Data Analyst II

State of careers Rhode Island

6d • Onsite

About The Position

At a significant level of expertise, to undertake professional special and recurring assignments involving conducting full lifecycle activities of data analytics to include requirements and design, data cleaning, developing analysis and reporting capabilities, linking databases and datasets, and continuously monitoring performance and quality control plans to identify improvements in models; and to do related work as required. Works under the general supervision of a superior with considerable latitude for the exercise of independent judgement and initiative. Work is subject to review for conformance with prescribed state policies and procedures. May supervise less experienced personnel assigned to assist on a regular project basis or; ensures that work products are developed in a qualitative and timely manner.

Requirements

• A thorough knowledge of data models, regression analysis, database design development, data mining and segmentation techniques.
• A thorough knowledge of sophisticated reporting packages, databases and programming.
• A thorough knowledge of statistical methodologies and techniques utilized for analyzing large datasets.
• The ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
• The ability to conduct queries, draw conclusions, prepare written reports and present findings in a clear and concise manner.
• The ability to mentor and/or supervise less experienced analysts as required.
• The ability to establish and maintain effective working relationships with state and municipal officials, superiors, subordinates and the public.
• Possession of a Master’s Degree from a college of recognized standing in Mathematics, Economics, Computer Science, Information Management, Statistics, or a closely related field with similar technical and computational emphasis.
• OR Graduation from a four-year college of recognized standing with a Bachelor’s Degree in Mathematics, Economics, Computer Science, Information Management, Statistics, or a closely related field with similar technical and computational emphasis; and considerable employment in a professional capacity as a data analyst.
• Access to Federal tax Information (FTI) requires a national fingerprint background screening.
• Employment eligibility must be validated through E-Verify.

Nice To Haves

• Knowledge of best analytic practices to determine data quality.
• Extensive experience in delivering detailed assessments of perceived data trends, issues and quality metrics surrounding Medicaid data.
• Proven expertise in Health care more specifically having worked on claims-based data.
• Experience working with states in implementation of Large System Enhancements (MMIS).
• Knowledgeable of state data systems.
• Understand Power BI tools querying languages.
• Strong SQL Programming experience is preferred.
• Strong ability to investigate data to find patterns and trends.
• Detail-oriented and have excellent verbal and written communications skills, leadership skills, and organization skills.
• Ability to work independently, and as a team member.

Responsibilities

• Conduct full lifecycle activities of data analytics to include requirements and design, data cleaning, developing analysis and reporting capabilities, linking databases and datasets, and continuously monitoring performance and quality control plans to identify improvements in models.
• Assure the integrity of project data, including data extraction, storage, manipulation, processing and analysis.
• Provide a high level of expertise to query and interpret data, analyze results using statistical techniques, develop predictive models using administrative datasets and provide ongoing reports.
• Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality.
• Work closely with management to prioritize business and information needs.
• Provide data visualization and presentation of analytical findings to program owners and other stakeholders.
• Acquire data from primary or secondary data sources and maintain databases/data systems.
• Identify, analyze, and interpret trends or patterns in complex datasets.
• Link databases and datasets to generate integrated datasets.
• Filter and “clean” data, and review computer reports, printouts, and performance indicators to locate and correct code problems.
• Participate in ongoing decisions concerning data collections, study design, methodology, and data analysis.
• Locate and define new process improvement opportunities.
• Develop models, visualizations, and reports of utilization and outcomes in Microsoft Power BI.
• Evaluate and perform analysis on systemic data quality issues that may impact management and CMS reporting.
• Provide briefing and guidance on best practices for management and submission of data to CMS and other federal entities.
• Deliver detailed assessments of perceived data trends, issues and quality metrics surrounding Medicaid data.
• Untangle claims data to identify trends.

Benefits

• For information regarding the benefits available to State of Rhode Island employees, please visit the Office of Employee Benefits' website at http://www.employeebenefits.ri.gov/.
• Direct deposit for all employees is required.
• Public service with purpose and impact.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 501-1,000 employees