DATA ANALYST I at Rhode Island… · Louis…

Summary: The Rhode Island Department of Corrections is seeking a Data Analyst I to join their Information Management team within the Department of Human Services. The role involves conducting full lifecycle activities of data analytics, including data cleaning, analysis, and reporting, while ensuring the integrity of project data and identifying improvements in models. Responsibilities: - To be responsible for 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 - To assure the integrity of project data, including data extraction, storage, manipulation, processing and analysis - To query and interpret data, analyze results using statistical techniques, develop predictive models using administrative datasets and provide ongoing reports - To acquire data from primary or secondary data sources and maintain databases/data systems - To provide data visualization and presentation of analytical findings to program owners and other stakeholders - 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: - 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 working 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 establish and maintain effective working relationships with state and municipal officials, superiors, subordinates and the public - 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 - Employment in a professional capacity as a data analyst or in a technical capacity involving computational emphasis or data analysis - Any combination of education and experience that shall be substantially equivalent to the above education and experience Preferred Qualifications: - Strong fundamental understanding of relational database concepts (RDBMS) preferred, including querying databases, inserting/updating data, window vs aggregate functions - Familiarity and experience with state government benefit programs, including the Supplemental Nutrition Assistance Program (SNAP), Medicaid, Temporary Assistance for Needy Families (TANF), Child Care, Medicaid and others - Intermediate to advanced skillset in Microsoft Excel; ability to effortlessly manipulate, clean, and visualize data in Excel using code, etc - Intermediate/Expert understanding of Oracle/SQL querying preferred - Knowledge of general best practices for data analytics and data management - Familiarity and experience with data visualization tools, mainly Tableau Required Skills: Data models, Regression analysis, Database design development, Data mining, Segmentation techniques, Statistical methodologies, Relational database concepts, SQL querying, Microsoft Excel, Data visualization, Tableau, Data cleaning, Data analysis, present findings clearly, establish and maintain effective working relationships 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/