Data Analyst I: Insights, ETL & Dashboards

RI Council 94; Rhode Island; On-site; USD 92,000 - 105,000; Full time

Job summary

RI Council 94 in Rhode Island is seeking a Data Analyst I within the Department of Transportation IT division. You will conduct full lifecycle data analytics, including requirements gathering, data cleaning, modeling and reporting, while linking databases and monitoring data quality across RIDOT systems and GIS portals.

The role emphasizes data visualization for program owners and collaboration with state officials; a quantitative bachelor's degree and data analysis experience are expected.

Qualifications

• Bachelor's degree in a quantitative field or closely related area.
• Experience as a data analyst or in a technically focused data role.
• Ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail.

Responsibilities

• Conduct full lifecycle data analytics: requirements, design, data cleaning, modeling and reporting.
• Link and integrate databases/datasets, monitor performance and quality control plans.
• Query, interpret, and present data findings to stakeholders; develop predictive models.
• Maintain RIDOT GIS on-prem and cloud environments; publish services and ETL integrations.

Skills

Data models

Regression analysis

Database design

Data mining

Data segmentation

Reporting packages

Programming

Statistical methods

Education

Bachelor's degree in Mathematics, Economics, CS, Information Management, Statistics

Tools

SQL

ETL

GIS

Data visualization tools

Job description

RI Council 94 in Rhode Island is seeking a Data Analyst I within the Department of Transportation IT division. You will conduct full lifecycle data analytics, including requirements gathering, data cleaning, modeling and reporting, while linking databases and monitoring data quality across RIDOT systems and GIS portals.

The role emphasizes data visualization for program owners and collaboration with state officials; a quantitative bachelor's degree and data analysis experience are expected.