Data Management Coordinator (Vacancy)

City of Columbus•Varies by position, OH

9d•Onsite

About The Position

This position is in the Director's Office-Information Technology Section at Columbus Water & Power (CWP) and, under general direction, will be responsible for planning, directing and coordinating the ongoing management and analysis of data and processes associated with Oracle Customer Cloud Services (Customer Service and Billing System) on behalf of the division. This role will focus on the Customer Information and Billing Application, as well as integrated systems. The Data Management Coordinator will be responsible for serving as the system administrator and subject matter expert for IT, business processes, system functionality and configuration. It will manage and analyze data to support critical business decisions and review and document processes related to information systems; performs related duties as required. This position is in-office at our headquarters.

Requirements

Possession of a bachelor's degree and five (5) years of experience performing data analysis OR report development from a relational database (using SQL, Crystal Reports, Business Objects, or other database reporting tool) OR database (relational) administration.

Nice To Haves

Using SQL, Crystal Reports, Business Objects, or other database reporting tools, or database relational administration experience.

Responsibilities

Plans, directs, and coordinates the on-going management of large information system(s) from the functional system user perspective
Collaborates with Department of Technology (DoT) and/or hosted vendor involved in the execution of information and data management system
Leads the development of policies and procedures related to the functional use of the information management system(s) and its related systems, such as document imaging, GIS, self-service, security management, etc
Communicates local issues with system-wide implications to appropriate stakeholders and provides recommendations for the resolution of issues
Takes the lead on any data management projects (roll-outs, enhancements, interfaces, transitions, additional phases of implementation) that develop
Maintains awareness of the needs and requirements of the system users by networking, providing opportunity for feedback, etc
Partners with DoT to provide project governance to ensure vendor performance meets contractual requirements and City expectations
Prepares and monitors the operating budget that is submitted to DoT as it relates to the information management system(s)
Ensures information regarding data support, quality, and management is distributed to all relevant parties
Receives and prioritizes all requests for internal reports and information
Disseminates reports and data analysis to relevant staff members, senior management, and department director(s)
Ensures high quality data is available for extraction as needed by developing and implementing systems to identify, track, correct, and prevent errors
Coordinates integrated testing and implementation of program changes and enhancements with functional and technical resources
Ensures functional users are properly trained; maintains training system, processes, and documentation
Works with DoT, hosted vendor and/or other relevant staff to ensure that local system changes and enhancements support staff needs and are compliant with system-wide standardizations and enhancements
Collaborates with DoT and/or hosted vendor to ensure data transfer and extraction is meeting expectations
Works with DoT and/or hosted vendor to identify and report problems of functionality to the data system and extractor
Analyzes and interprets data reports in support of planning, evaluation, management, decision making, and strategic planning
Presents information in an understandable and accurate format for a variety of applications and scenarios
May supervise professional, technical, and/or support staff