Data Analyst II (Corrections)

Shelby County•Memphis, TN

About The Position

Works under the general direction of the Administrator (Data) to develop dynamic and multifaceted reporting mechanisms by acting as the intermediary between IT and Strategy & Innovation, transmuting data and research needs into automated reporting as the connective thread between departments. Work to develop and run reports and will be responsible for communicating and coordinating programming needs with IT, vendor(s), and data managers. Pay Grade: 51 Salary Commensurate with Experience and Education

Requirements

Four (4) years of experience; AND
Bachelor’s degree from an accredited college or university in mathematics, statistics, computer science, data science or a closely related field; OR
An equivalent combination of related education and/or experience.
PROOF OF EDUCATION, TRAINING AND/OR EXPERIENCE IS REQUIRED.

Nice To Haves

Knowledge of the best practices for Corrections databases and general knowledge of the metrics and outcomes-tracking landscape for Corrections is preferred.
Thorough knowledge of relational databases with the ability to work with and communicate technical information simply to other users.
Specialized knowledge and experience with analyzing major datasets / databases, working with statistical coding languages, and working with complex financial datasets (as well as unstructured data).
Thorough knowledge of Excel and Access, as well as data visualization tools (e.g., PowerBI, GIS).
Analytically skilled in initiating development of clear and concise specifications, documentation, and procedures.
Ability to coordinate, solve, and complete multiple projects in a deadline-oriented work environment.
Ability to work independently or as a member of a team to complete projects by required deadlines.
Ability to apply and communicate technical knowledge and principles in designing major software or other systems and conduct user interviews.
Ability to interpret and convert business problems to computer language.
Ability to communicate technical information and conduct user interviews.
Skilled in coordinating efforts of a large project.

Responsibilities

Functions as a data systems integrator by building reports and maintaining databases.
Works in tandem with the Business Service Analyst to maintain the data dictionary by keeping the database current.
Utilize advance SQL expertise to effectively query/navigate across multiple data domains, perform data analysis, create findings, and generate comprehensive and relevant datasets.
Work with programmers, engineers, and management to identify process improvement opportunities, propose system modifications, and devise data governance strategies.
Author technical requirements for IT to build new features and enhancements for reporting tools.
Maintain and monitor data security for continuous improvement and help inform the data security planning.
Establishes and maintains tools (e.g., reports, dashboards).
Collaborates with interdepartmental staff to visualize, interpret and report data findings.
Collaborates with other technical/database leads to provide insight and resolve data issues to enable better decisions and improve data processing.
Detect and resolve incidence of errors prior to data release.
Codes, debugs, tests and documents application programs as requested by management.
Assists in the development of specifications for software applications as it relates to reporting dynamic data.
Performs other related duties as required or directed.