Junior-Level Data Engineer (Senior Programmer Analyst) (Vacancies)

Preferred Skills : Skilled in Talend Data Fabric: Talend Studio, Talend Data Integration, Talend Enterprise Service Bus, Talend Data Catalog, Talend Data Stewardship, Talend Data Preparation or other low-code data integration tools (Informatica, MS SQL Server Integration Services, Azure Data Factory, Qlik). Knowledge of the following technologies: RDBMS platforms (SQL Server in particular), GitHub, and SOAP/REST APIs. Proficient in developing data ingestion, data processing, and analytical pipelines for data warehouses, relational databases. Proficient in object-oriented/object function scripting languages: Python, Java, C++, Scala, etc. Experienced in translating business requirements to scalable technical solutions. Experienced in performing statistical analysis using the latest analytical tools (Machine learning, Artificial Intelligence). Experience in SQL Server Integration Services, Azure Data Factory, SAS, Tableau, R, Jupyter Notebooks is highly desired.

Under direction, is responsible for planning, developing, modifying, and implementing complex or specialized computer programming projects and/or leading the preparation of computer programs; 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.)

Consults with clients as well as managerial and information systems staff to review and translate business specifications into computer applications; determines program intent and the extent of programming and coding required, and identifies potential problems;

Consults with multiple levels of clients in discovery sessions to determine the full scope of projects and to ascertain the objectives of the proposed system(s) or program(s);

Analyzes, creates, reviews, and/or alters programs to increase operating efficiency or meet division requirements;

Develops workflow charts and diagrams for complex or specialized programs; converts workflow charts to computer language and ensures that coded language is entered into computer;

Develops and prepares documents for the general design of solutions that meet project requirements;

Develops and maintains automated data processing applications and computer application programs;

Develops specifications to detail what new applications or enhancements to existing applications can accomplish;

Develops time/cost estimates for applications development and upgrades to existing applications;

Develops detailed applications designs; develops operational and installation procedures for hardware and software;

Coordinates the work of team members so that subprograms are compatible with overall system capabilities and project requirements;

Attends meetings with users, coordinators, third-party vendors, and other programming staff in order to obtain and exchange information;

Coordinates customer support for third-party software applications;

Writes documentation to describe program development, logic, coding, and corrections; writes manuals for users to describe installation and operating procedures;

Trains users to operate programs; provides technical assistance to users;

May supervise user support staff and/or programmer analysts. Possession of an associate degree and three (3) years of experience in application programming. Substitution(s): Additional experience as listed above may substitute for the required education on a year-for-year basis.

Recruitment #: 25-0581-V1

Employment Type: Full-Time (Regular)

Should you have questions regarding this vacancy, please contact:

Kim Hetterscheidt

Department of Technology

Division of Information Services

1111 E Broad St

Columbus, Ohio 43205

P: (614) 645- 0367

E: ...

The City of Columbus is an Equal Opportunity Employer