Data Analyst II

State of Rhode Island; United States; On-site; USD 106,000 - 121,000; Full time

Job summary

State of Rhode Island's Executive Office of Health and Human Services, Division of Information Technology/Computers, seeks a Data Analyst II to perform full lifecycle data analytics on Medicaid and related datasets. You will design data collection systems, clean and integrate data, and develop analyses to support program decisions.

Strong Power BI visualization and SQL skills are essential. Master’s degree in a related field and substantial data analyst experience are required.

Qualifications

• A Master’s Degree from a college of recognized standing in Mathematics, Economics, Computer Science, Information Management, Statistics, or a closely related field.
• Considerable employment in a professional capacity as a data analyst.
• Strong ability to develop visualizations and summarize data trends in Microsoft Power BI.
• Proven expertise in health care, specifically having worked on claims-based data.
• Ability to mentor and/or supervise less experienced analysts as required.

Responsibilities

• Develop full lifecycle data analytics including requirements, design, data cleaning, and reporting capabilities.
• Query, interpret data, analyze results using statistical techniques, and develop predictive models from administrative datasets.
• Create data visualization and present findings to program owners and stakeholders.
• Acquire data from primary or secondary sources and maintain databases/datasets.

Skills

Power BI

Data analysis

Data interpretation

Education

Master’s Degree in Mathematics, Economics, Computer Science, Information Management, Statistics, or closely related field

Tools

SQL

Job description

Department

Executive Office of Health and Human Services

Division

Information Technology/Computers

Salary

$106,392.00 - $120,670.00

Job Profile

JC-02623404-99 - Data Analyst II (Non-Union Executive Branch)

Scheduled Work Days & Work Hours

Monday - Friday, 8:30am - 4:00pm

35 Hours - Non-Standard

Job Requisition Number

JR104168 Data Analyst II (Open)

Pay Grade

C00138 A

Classification

Data Analyst II

Class Definition

GENERAL STATEMENT OF DUTIES

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.

SUPERVISION RECEIVED

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.

SUPERVISION EXERCISED

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.

ILLUSTRATIVE EXAMPLES OF WORK PERFORMED

• 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.
• With a significant level of latitude and independence, to assure the integrity of project data, including data extraction, storage, manipulation, processing and analysis.
• To 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.
• To develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality.
• To work closely with management to prioritize business and information needs.
• To provide data visualization and presentation of analytical findings to program owners and other stakeholders.
• To acquire data from primary or secondary data sources and maintain databases/data systems.
• To identify, analyze, and interpret trends or patterns in complex datasets.
• To link databases and datasets to generate integrated datasets.
• To filter and “clean” data, and review computer reports, printouts, and performance indicators to locate and correct code problems.
• To participate in ongoing decisions concerning data collections, study design, methodology, and data analysis.
• To locate and define new process improvement opportunities.
• To do related work as required.

REQUIRED QUALIFICATIONS FOR APPOINTMENT

KNOWLEDGES, SKILLS AND CAPACITIES

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; and related capacities and abilities.

EDUCATION AND EXPERIENCE

Education

Such as may have been gained through: 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.

Experience

Such as may have been gained through: considerable employment in a professional capacity as a data analyst.

Supplemental Information

This position will report to the Chief Data Analyst.

• Strong ability to develop visualizations and summarize data trends in Microsoft Power BI.
• For examples of Power BI Dashboards created by this team, please see:
• https://eohhs.ri.gov/initiatives/medicaid-initiatives/medicaid-data-dashboard
• https://eohhs.ri.gov/health-workforce-dashboard
• https://eohhs.ri.gov/consumer/families-children/early-intervention-program/early-intervention-data-dashboard
• https://justice.ri.gov/statistical-analysis-center-information/justice-reinvestment-dashboards
• Desire to independently learn new and complex data sets and data systems in a fast-paced environment
• Ability to identify and correct systemic data quality issues that may impact CMS reporting and data collection via the State’s integrated eligibility system.
• Prior experience creating Excel-based reports using PivotTables and Excel Formulas
• Experience compiling reports on topics such as Medicaid utilization, state spending, prevalence of specific procedure codes/services and other topics related to Medicaid cost and utilization.
• Prior experience presenting 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 Medicaid claiming systems (MMIS) as well as other state data sets (Department of Health or Department of Corrections data), the All-Payer Claims Database (APCD), and other integrated data sets for interagency analyses.
• Interest in working independently, and as a team member on a team crossing various roles (technical support, project managers, other analysts)
• Prior experience as the Subject Matter Expert (SME) in key areas, and willingness to collaborate with Program staff to help determine best ways to present data to better understand new and existing Medicaid programs

Preferred Qualifications

• Expert in Power BI
• Strong SQL Programming experience
• Prior experience with CMS reporting and large data systems
• Detail-oriented
• Excellent verbal and written communications skills, leadership skills, and organization skills.

The candidate is expected to work in person in Cranston, RI five days a week for the first six months. After six months, they may be eligible for telework two days of the week.

https://www.everify.gov/sites/default/files/everify/posters/IER_RighttoWorkPoster.pdf

https://everify.uscis.gov/web/media/resourcesContents/EVerify_Participation_Poster_ES.pdf

The individual hired to fill this position will have access to Federal tax Information (FTI), as defined in IRS Publication 1075, and, as such, must undergo a national fingerprint background screening in accordance with the set forth in regulation 220-RICR-40-00-2 (IRS Publication 1075 – Background Check Process and Criteria available at https://rules.sos.ri.gov/regulations/part/220-40-00-2.

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/.

Also, be advised that a new provision in RI General Law 35-6-1 was enacted requiring direct deposit for all employees. Specific to new hires, the law requires that all employees hired after September 30, 2014 participate in direct deposit. Accordingly, any employee hired after this date will be required to participate in the direct deposit system. At the time the employee is hired, the employee shall identify a financial institution that will serve as a personal depository agency for the employee.