DATA ANALYST II

State of careers Rhode Island; Providence (RI); On-site; USD 106,000 - 121,000; Full time

Job summary

The Department of Administration in Rhode Island seeks a Data Analyst II (Non-Union Executive Branch) to perform full lifecycle data analytics, including requirements gathering, design, data cleaning, analysis and reporting, and to link databases for integrated datasets.

The role requires strong knowledge of data models, regression analysis, and statistics, with experience in presenting findings to program owners and stakeholders.

Qualifications

• Thorough knowledge of data models, regression analysis, database design and data mining techniques.
• Strong knowledge of statistical methodologies and reporting packages.
• Ability to collect, organize, analyze and disseminate large amounts of information with accuracy.

Responsibilities

• Undertake full lifecycle data analytics including requirements, design, cleaning, development of analysis and reporting capabilities, and data integration.
• Assure data integrity, perform data extraction, storage, manipulation and analysis.
• Query, interpret data, analyze results, develop predictive models and provide ongoing reports.

Skills

Data modeling

Regression analysis

Database design

Data mining

Statistics

Reporting tools

Education

Master's degree

Bachelor's degree

Tools

SQL

Programming

Job description

Department

Department of Administration

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

Job Requisition Number

JR103907 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

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.

Benefits

For information regarding thebenefits available to State of RhodeIsland 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.