Data Analyst II

Department

Executive Office of Health and Human Services

Division

Information Technology/Computers

Salary

$103,293.00 - $117,155.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

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

Or,

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

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.

Duties/Responsibilities:

• Strong ability to develop models, visualizations, and reports of utilization and outcomes in Microsoft Power BI.
• Ability to evaluate and perform analysis on systemic data quality issues that may impact management and CMS reporting.
• Knowledge of best analytic practices to determine data quality.
• Experience with briefing and guidance on best practices for management and submission of data to CMS and other federal entities.
• 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 and experience untangling claims data to identify trends.

Preferred Qualifications:

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

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 criteria 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. Additionally, the individual is being hired to an E-Verify site which contains FTI and must have their employment eligibility validated through E-Verify.

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

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.