Data Analytics Specialist II | Power BI & SQL

RI Council 94; Cranston (RI); Hybrid; USD 106,000 - 121,000; Full time

Job summary

State of Rhode Island seeks a Data Analyst II to perform full lifecycle data analytics, including data cleaning, analysis, and reporting. You will link databases, monitor data quality, and deliver insights to program owners.

The role requires strong Power BI, SQL, and data visualization skills, with experience in health data (CMS/MMIS/APCD) and a collaborative, independent work style. Hybrid work options may apply after onboarding.

Qualifications

• A thorough knowledge of data models, regression analysis, database design development, data mining and segmentation techniques.
• Experience with sophisticated reporting packages, databases and programming.
• Knowledge of statistical methodologies for analyzing large datasets and ability to present findings clearly.
• Ability to mentor and supervise analysts and communicate with stakeholders effectively.

Responsibilities

• Develop visualizations and summarize data trends using Power BI.
• Query and interpret data, perform statistical analyses, and build predictive models.
• Develop data collection systems and strategies to improve data quality and efficiency.
• Collaborate with management to prioritize information needs and present findings to program owners.
• Acquire data from primary or secondary sources and maintain databases/datasets.

Skills

Power BI

SQL

Data Analysis

Data Visualization

CMS reporting

Education

Master’s Degree in Mathematics/CS/Statistics

Bachelor’s Degree in Mathematics/CS/Statistics

Tools

Excel

MMIS

APCD

Job description

State of Rhode Island seeks a Data Analyst II to perform full lifecycle data analytics, including data cleaning, analysis, and reporting. You will link databases, monitor data quality, and deliver insights to program owners.

The role requires strong Power BI, SQL, and data visualization skills, with experience in health data (CMS/MMIS/APCD) and a collaborative, independent work style. Hybrid work options may apply after onboarding.