Data Management Coordinator (Vacancy)

Columbus; Columbus (OH); On-site; USD 70,000 - 90,000; Full time

Job summary

Columbus Water & Power is seeking a Data Management Coordinator for the Division of Water Reclamation. This role will plan, direct, and coordinate ongoing data management and analysis across 40+ systems, acting as the primary contact for division systems and serving as system administrator and SME for business processes and configuration.

The incumbent will lead data reporting and analysis to support critical decisions, collaborate with DoT and hosted vendors, ensure data quality, and provide

Qualifications

• Bachelor's degree and 5 years of experience performing data analysis or report development from a relational database or database administration
• Master's degree may substitute for one year of the required experience

Responsibilities

• Plan, direct, and coordinate the ongoing management of data and processes across 40+ systems
• Serve as division system administrator and SME for business processes and configurations
• Lead data reporting and analysis to support critical business decisions
• Coordinate with DoT and hosted vendor on data systems and governance
• Ensure data quality and timely extraction for reporting and planning

Skills

Data analysis

Reporting

Project coordination

Education

Bachelor's degree in data management or related field

Tools

Crystal Reports

Business Objects

SQL

Job description

Columbus Water & Power is seeking a Data Management Coordinator for the Division of Water Reclamation. Under general direction, this position will be responsible for planning, directing, and coordinating the ongoing management and data analysis of data and processes associated with the division which includes over 40 systems.

This role will serve as primary contact for systems used in the division and will provide support from a functional standpoint. Critical systems include, but are not limited to: Cityworks, Customer Information Management System, PMIS and Falcon. The role will service as the division system administrator and subject matter expert for business process, system functionality, and configuration. The role will lead data reporting and analysis to support critical business decisions. Performs related duties as required.

(Any one position may not include all of the duties listed, nor do the examples cover all of the duties that may be performed.)

• 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, 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.

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. Substitution(s): Possession of a master's degree may substitute for one year of the required experience.

Recruitment #: 26-0591-V5

Employment Type: Full-Time (Regular)

Should you have questions regarding this vacancy, please contact:

Alisha Ardolino

Columbus Water & Power

Office of the Public Utilities Director

37 W. Broad St.

Columbus, Ohio 43215

P: [phone]

E: [e-mail]

The City of Columbus is an Equal Opportunity Employer