Address
Form of workPosition Details
Consults with users to evaluate, develop, and document an understanding of business processes, needs, expectations, and technology requirements; analyzes and reviews requests for data integrations, batch ETL, data visualizations, and additional technologies to standardize data management and access to data;
Develops the outline of the data integration design and defines the requirements and parameters of the proposed information management systems; prepares cost estimates and project timelines for implementation of information management systems; makes recommendations on improvements to business processes;
Analyzes currently available data sources, data integration tools, and data management systems to determine compatibility with and adaptability to the users' needs and the City's technical capabilities;
Collaborates with technical section's specialists in areas such as data engineering, database, data management, and data visualization systems to specific departmental requirements;
Documents the development, testing, implementation, and evaluation of the business systems; directs the preparation of reports, training materials, and operational procedures related to the business systems;
Familiarity and prior experience in ETL platforms such as Talend, Tableau, SQL Server, GitHub, etc. is highly desired.
Develops the outline of the data integration design and defines the requirements and parameters of the proposed information management systems; prepares cost estimates and project timelines for implementation of information management systems; makes recommendations on improvements to business processes;
Analyzes currently available data sources, data integration tools, and data management systems to determine compatibility with and adaptability to the users' needs and the City's technical capabilities;
Collaborates with technical section's specialists in areas such as data engineering, database, data management, and data visualization systems to specific departmental requirements;
Documents the development, testing, implementation, and evaluation of the business systems; directs the preparation of reports, training materials, and operational procedures related to the business systems;
Familiarity and prior experience in ETL platforms such as Talend, Tableau, SQL Server, GitHub, etc. is highly desired.
Under direction, is responsible for researching, designing, developing, and implementing enterprise software systems, which may include databases, server applications, and/or web-based development; 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.)
Confers with departmental or divisional personnel to analyze current operational procedures, document potential problems, and identify specific input and output requirements for software system development;
Analyzes software requirements for computerization, such as hardware and network configurations, peripheral equipment, maintenance support, mainframe, or other system interfaces and memory devices to determine feasibility of system designs within time and budget constraints;
Reviews the outline of the new or revised business system process(es) and makes recommendations for improvements by defining the hardware and software requirements of the proposed system(s) or process(es); prepares cost estimates and project timelines for implementation;
Consults with technical staff to evaluate business processes, needs, expectations, and functional requirements and translates into technical requirements; designs and proposes solutions to streamline or enhance business functions/processes;
Researches third-party software systems for feasibility of design and compatibility and adaptability with existing architecture and business processes; reviews proposed hardware and software solutions and recommends selection to management for approval;
Formulates, designs, and/or modifies software systems using scientific analysis to predict and measure outcome and consequences of design;
Develops and directs software system testing procedures, programming, and documentation;
Serves as senior consultant for database design, implementation, and administration, including security, backup, recovery, and maintenance;
Advises departmental or divisional personnel in their technology needs with regard to data corruption, security issues, computer viruses, and hardware and software redundancy;
Consults with staff members to evaluate interface between hardware and software and operational and performance requirements of software system; analyzes system growth and evaluates processing efficiency;
Plans and prepares technical reports, memoranda, and instructional manuals as documentation of system development;
Makes recommendations to management regarding the planning, development, and coordination of software system development projects;
Performs engineering cost/benefit analysis to verify potential effectiveness of new products; conducts technical research for building new designs, developing business cases, selling ideas to management, and gaining commitment for new system enhancements;
Mentors business systems analysts and senior programmer analysts in their work and individual projects as requested by management;
Participates in appropriate professional activities to stay abreast of existing and emerging technologies.
Possession of a bachelor's degree with significant coursework (twenty-one (21) semester or thirty-two (32) quarter hours) in computer science, management information systems, computer programming, geographic information systems, engineering, mathematics, or a closely related field and four (4) years of experience in systems analysis, database management, applications development, or software design. Substitution(s): Valid possession of one (1) of the following certifications may be substituted for the required education: Microsoft Certified Solutions Developer (all tracks), or Microsoft Certified Solutions Expert (Data Platform or Business Intelligence), or Oracle Certified Professional (PL/SQL Developer or Database Administrator). Additional experience as specified above may substitute for the educational requirement on a year-for-year basis. Possession of a master's degree with significant coursework (ten (10) semester or sixteen (16) quarter hours) as stated above may be substituted for one (1) year of the required experience.Recruitment #: 23-0585-V7Confers with departmental or divisional personnel to analyze current operational procedures, document potential problems, and identify specific input and output requirements for software system development;
Analyzes software requirements for computerization, such as hardware and network configurations, peripheral equipment, maintenance support, mainframe, or other system interfaces and memory devices to determine feasibility of system designs within time and budget constraints;
Reviews the outline of the new or revised business system process(es) and makes recommendations for improvements by defining the hardware and software requirements of the proposed system(s) or process(es); prepares cost estimates and project timelines for implementation;
Consults with technical staff to evaluate business processes, needs, expectations, and functional requirements and translates into technical requirements; designs and proposes solutions to streamline or enhance business functions/processes;
Researches third-party software systems for feasibility of design and compatibility and adaptability with existing architecture and business processes; reviews proposed hardware and software solutions and recommends selection to management for approval;
Formulates, designs, and/or modifies software systems using scientific analysis to predict and measure outcome and consequences of design;
Develops and directs software system testing procedures, programming, and documentation;
Serves as senior consultant for database design, implementation, and administration, including security, backup, recovery, and maintenance;
Advises departmental or divisional personnel in their technology needs with regard to data corruption, security issues, computer viruses, and hardware and software redundancy;
Consults with staff members to evaluate interface between hardware and software and operational and performance requirements of software system; analyzes system growth and evaluates processing efficiency;
Plans and prepares technical reports, memoranda, and instructional manuals as documentation of system development;
Makes recommendations to management regarding the planning, development, and coordination of software system development projects;
Performs engineering cost/benefit analysis to verify potential effectiveness of new products; conducts technical research for building new designs, developing business cases, selling ideas to management, and gaining commitment for new system enhancements;
Mentors business systems analysts and senior programmer analysts in their work and individual projects as requested by management;
Participates in appropriate professional activities to stay abreast of existing and emerging technologies.
Employment Type: Full-Time (Regular)
Should you have questions regarding this vacancy, please contact:
Kimberly Hetterscheidt
Department of Technology
Division of Information Systems
1111 E. Broad St
Columbus, Ohio 43215
P: (614) 645-0367
E: khetterscheidt@columbus.gov
The City of Columbus is an Equal Opportunity Employer
Employment Type: Full-time
