Data Analyst (Technology Solutions Analyst IV) (Vacancy)
Description:
Data Analyst (Technology Solutions Analyst IV) (Vacancy)
Print (
Apply
Data Analyst (Technology Solutions Analyst IV) (Vacancy)
Salary
$48.25 - $72.41 Hourly
Location
Varies by position
Job Type
Full-time
Job Number
25-0585-V5
Department
47 Department of Technology
Division
Division of Information Services
Opening Date
08/22/2025
Closing Date
9/19/2025 11:59 PM Eastern
Description
Benefits
Questions
Definition
Preferred Skills and Experience:
• Data Analysis & Querying: Proficiency in SQL, Excel, Python, or R.
• Data Visualization: Experience with Tableau, Power BI, or similar tools.
• Data Management: Knowledge of metadata management, data quality, and data lineage.
• Database Systems: Familiarity with relational databases (Microsoft SQL Server, Oracle).
• ETL & Data Integration: Experience with ETL tools (i.e. Talend).
• Expertise in data profiling, metadata management, and data lineage tracking
• Familiarity with Data Inventorying and Cataloging.
• Understanding of data governance frameworks (e.g., DAMA-DMBOK).
• Knowledge of data privacy regulations (GDPR, CCPA, HIPAA).
• Ability to enforce data policies and best practices.
• Attention to Detail: Ensuring high-quality and consistent data.
• Analytical Thinking: Ability to derive insights from complex datasets.
• Collaboration & Communication: Working across departments to manage data.
• Problem-Solving: Ability to troubleshoot and resolve data-related issues.
• Data Analysis & Querying: Proficiency in SQL, Excel, Python, or R.
• Data Visualization: Experience with Tableau, Power BI, or similar tools.
• Data Management: Knowledge of metadata management, data quality, and data lineage.
• Database Systems: Familiarity with relational databases (Microsoft SQL Server, Oracle).
• ETL & Data Integration: Experience with ETL tools (i.e. Talend).
• Expertise in data profiling, metadata management, and data lineage tracking
• Familiarity with Data Inventorying and Cataloging.
• Understanding of data governance frameworks (e.g., DAMA-DMBOK).
• Knowledge of data privacy regulations (GDPR, CCPA, HIPAA).
• Ability to enforce data policies and best practices.
• Attention to Detail: Ensuring high-quality and consistent data.
• Analytical Thinking: Ability to derive insights from complex datasets.
• Collaboration & Communication: Working across departments to manage data.
• Problem-Solving: Ability to troubleshoot and resolve data-related issues.
Under direction, is responsible for researching, designing, developing, and improving enterprise data and/or application solutions; performs related duties as required.
Examples of Work
(Any one position may not include all of the duties listed, nor do the examples cover all of the duties that may be performed.)
Develops data and/or applications solutions, which may include utilization of supportive software, data management platforms, database management systems, server applications, and/or web-based development systems;
Confers with departmental or divisional personnel to analyze current operational procedures, document potential problems, and identify specific data input and output requirements for software system development;
Analyzes requirements of data and/or application solutions, such as licensing requirements, data requirements, peripheral equipment, maintenance support, server requirements, access on mobile devices, or other system interfaces and requirements 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); evaluates integration requirements for data and applications and supportive databases; develops solutions for integration and/or extraction of data for cross-platform dependencies among application systems; 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;
Develops solutions for citywide data integration and management; creates synthesized data models, transformations and visualizations for deployment of analytics to meet the business or operational needs of the City;
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, configures, 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; utilizes administrative rights within software applications to mass import updates to an application system;
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.
Minimum Qualifications
Possession of a bachelor's degree 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), Microsoft Certified Solutions Expert (Data Platform or Business Intelligence), or Geographic Information Systems Professional (GISP). Additional experience as specified above may substitute for the educational requirement on a year-for-year basis. Possession of a master’s degree may be substituted for one (1) year of the required experience.
Test/Job Contact Information
Recruitment #: 25-0585-V5
Employment Type: Full-Time (Regular)
Should you have questions regarding this vacancy, please contact:
Kimberly 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
The City of Columbus seeks to promote compensation strategies that maximize the recruitment, performance, development, and retention of quality employees in support of the City's Covenant and strategic plan. In addition to a competitive pay plan, the City offers a comprehensive benefits program that includes the following:
Medical
Dental
Vision
Short-term Disability
Life Insurance
Wellness Program
Tuition Reimbursement
Specifics about these benefit opportunities and eligibility can be discussed with one of the City's human resources professionals at the time of your interview or by contacting the Department of Human Resources, Labor Relations Office at for further information.
01
Have you included all of your relevant work experience (previous and current)? Resumes will not be accepted as a substitute for completing the application.
Yes
No
02
Have you reviewed the Minimum Qualifications for the job that you are applying to ensure that you meet specified requirements?
Yes
No
03
Have you attached the documents that provide proof of your license, education (post high school), and/or professional or state certification as you have referenced in your applicant profile? Such documents may include a photocopy or scan of your driver's license, bachelor's/master's degree or transcript of completed coursework.
Yes
No
Required Question
Employer
City of Columbus
Address
77 N. Front Street, Suite 330
Columbus, Ohio, 43215
Phone
Website
Apply
Please verify your email addressVerify Email