Data Analyst II

State of careers Rhode Island

6h•$106,392 - $120,670•Hybrid

About The Position

The Data Analyst II undertakes professional data analytics assignments across the full lifecycle, including requirements and design, data cleaning, analysis and reporting, linking databases and datasets, and monitoring performance and quality-control plans to identify model improvements. The role assures the integrity of project data through extraction, storage, manipulation, processing, and analysis; develops and implements data collection systems; and acquires and maintains data and databases. The analyst identifies trends and patterns in complex datasets, creates visualizations and presents findings to program owners and stakeholders, and works with management to prioritize business and information needs. The position reports to the Chief Data Analyst and is expected to work in person in Cranston, Rhode Island, five days per week for the first six months. After six months, the employee may be eligible for telework two days per week. Applicants invited to interview must complete an in-person SQL assessment. The role involves access to Federal Tax Information and requires a national fingerprint background screening and employment eligibility validation through E-Verify.

Requirements

A thorough knowledge of data models, regression analysis, database design and development, data mining, and segmentation techniques.
A thorough knowledge of sophisticated reporting packages, databases, and programming.
A thorough knowledge of statistical methodologies and techniques used to analyze large datasets.
Ability to collect, organize, analyze, and disseminate substantial amounts of information with attention to detail and accuracy.
Ability to conduct queries, draw conclusions, prepare written reports, and present findings clearly and concisely.
Ability to mentor and/or supervise less experienced analysts as required.
Ability to establish and maintain effective working relationships with state and municipal officials, superiors, subordinates, and the public.
Master’s degree in Mathematics, Economics, Computer Science, Information Management, Statistics, or a closely related field with similar technical and computational emphasis; alternatively, a bachelor’s degree in one of these fields plus considerable professional experience as a data analyst.
Strong ability to develop visualizations and summarize data trends in Microsoft Power BI.
Ability and interest in independently learning new and complex datasets and data systems in a fast-paced environment.
Prior experience creating Excel-based reports using PivotTables and Excel formulas.
Prior experience presenting perceived data trends, issues, and quality metrics relating to Medicaid data.
Expertise in healthcare, specifically experience working with claims-based data.
Interest in working independently and as a member of a team spanning technical support, project management, and analyst roles.
The position requires in-person work in Cranston, Rhode Island, five days per week for the first six months.
Applicants invited to interview must complete an in-person SQL assessment.
Must undergo national fingerprint background screening because the role provides access to Federal Tax Information.
Must have employment eligibility validated through E-Verify.
Applications must include a resume and cover letter.

Nice To Haves

Expertise in Power BI.
Strong SQL programming experience.
Prior experience with CMS reporting and large data systems.
Experience working with state Medicaid claiming systems (MMIS), other state datasets such as Department of Health or Department of Corrections data, the All-Payer Claims Database (APCD), and other integrated datasets for interagency analyses.
Experience compiling reports on Medicaid utilization, state spending, prevalence of procedure codes or services, and Medicaid cost and utilization.
Prior experience serving as a subject matter expert in key areas and collaborating with program staff.
Detail-oriented approach.
Excellent verbal and written communication, leadership, and organization skills.
Examples of relevant prior work; preference will be given to applications that include them.

Responsibilities

Conduct full-lifecycle data analytics, including requirements and design, data cleaning, analysis and reporting, database and dataset integration, and ongoing monitoring of performance and quality-control plans.
Ensure the integrity of project data, including its extraction, storage, manipulation, processing, and analysis.
Query and interpret data, apply statistical techniques, develop predictive models using administrative datasets, and provide ongoing reports.
Develop and implement data collection systems and strategies to improve statistical efficiency and data quality.
Work with management to prioritize business and information needs.
Create data visualizations and present analytical findings to program owners and other stakeholders.
Acquire data from primary or secondary sources and maintain databases and data systems.
Identify, analyze, and interpret trends and patterns in complex datasets.
Link databases and datasets to create integrated datasets.
Filter and clean data; review computer reports, printouts, and performance indicators to locate and correct code problems.
Participate in decisions about data collection, study design, methodology, and data analysis.
Identify and define process-improvement opportunities.
Compile and present reports and findings concerning Medicaid utilization, state spending, procedure-code or service prevalence, Medicaid costs and utilization, and Medicaid data trends, issues, and quality metrics.
Identify and correct systemic data-quality issues that may affect CMS reporting and data collection through the State’s integrated eligibility system.
Collaborate with program staff and cross-functional colleagues, including technical support staff, project managers, and analysts, to determine effective ways to present data and understand Medicaid programs.
Mentor or supervise less experienced analysts as required and ensure work products are timely and of appropriate quality.