Overview
The Data Engineer reports to the Head of Urban Data in the Office of Urban Analytics & Innovation (Urban AI) at the City of Cleveland. The Data Engineer will partner with business and operations technology teams to help define and implement data analytics initiatives that create sustainable improvements to the City of Cleveland reporting and analytics infrastructure. The Data Engineer is responsible for enabling data integration and data preparation pipelines for downstream analytics on behalf of City departments. This role requires business intuition and ability to use a variety of technical and soft skills necessary to be a good partner to various teams across the City of Cleveland.

Examples of Duties

Analyzes information requirements of new or modified systems and develops data file specifications. Assists Project Leaders, Systems Analysts, and Programmers with the implementation of data files to the City’s Information Systems. Creates and assigns descriptors to elements needed for data organization, access and control. Anaylzes current and planned database usage and makes recommendations to management for improving and modifying database structure. Performs other job-related duties as required. TYPICAL TASKS: Develops file data specifications including standard names for data elements. Consults with and assists Project Leaders on procedures related to new or existing data file structures. Monitors and analyzes the performance of databases and prepares reports on findings to management including recommendations for improvement. Assists Project Leaders, Systems Analysts, and Programmers with implementation of data files to database. Develops and documents standards for use, control, updating, and maintenance of databases. Interfaces with tech support and computer operations in the reorganization of databases and recovery and backup procedures.

Minimum Qualifications

A High School Diploma or GED is required. A Bachelor’s Degree in Computer Science, Business Administration, or closely related field from an accredited four (4) year college or university is required. Two (2) years experience in Database Management Systems (DMS) is required. (Substitution: Two (2) years of experience may be substituted for each year of college education lacking.) Must be proficient in Windows and Microsoft Office Suite. Must be able to lift and carry a minimum of thirty (30) pounds. A valid State of Ohio Driver’s License is required.

Supplemental Information

Essential Duties & Job Functions

•  Utilize software engineering methods and tools to create and maintain a common data analytics platform that can integrate and process and prepare multiple sources of data for downstream performance analysis
• Partner with business stakeholders to identify key initiatives and engage data team members across the City of Cleveland to complete delivery of sustainable solutions to business problems, using data analysis, advanced analytics and data engineering standard methodologies
• Test data and/or applications to validate data accuracy/quality
• Manages and monitors CI/CD processes
• Work with stakeholders to automate data analysis and integration
• Uses SQL to investigate databases and assemble data models
• Maintain and create new data pipelines
• Document processes for both education and posterity

Preferred Qualifications

• Bachelor’s degree in computer science or information systems, or equivalent experience
• Demonstrated ability in complex data management and data preparation, including but not limited to data storage, data standardization, and data operations, for data mart/warehousing efforts
• Experience working with large datasets and analytic initiatives, ability to tell a story using data
• Experience working with data integration frameworks a plus
• Experience working with cloud services & infrastructure and big data frameworks a plus
• Experience in designing, writing, and delivering code in a team environment, using source code control, unit testing, and other software engineering principles (e.g., Java, Python)
• Ability to thrive in a project-based, team environment
• Experience with Infrastructure as Code technologies and/or methodologies
• Ability to work independently and collaboratively
• Experience with external data reads through APIs
• Basic SQL knowledge
• Experience with the ETL framework
• Experience with Databricks a plus

The City’s guiding principles are as follows: Placing Clevelanders at the Center, Empowering Employees to Do Purposeful Work, Defining Clear and Pragmatic Objectives, Leading with Trust and Transparency, Striving for Equity in All We Do, and Embracing Change. All City employees are responsible for embracing and carrying out these principles in all that they do.