IT Data Analyst-Information Technology

IT DATA ANALYST-INFORMATION TECHNOLOGY

116

$71,380.00 - 91,009.50

APPLICATION DEADLINE: 6/17/2024

JOB SUMMARY:

This position is responsible for working with City of Columbia departments to analyze data, create reports and metrics, and ensure data integrity and accuracy. Assists departments with data integration and visualization of data for consumption by Stakeholders, Executive staff, Divisional/Departmental staff, and Project Managers. Identify and validate requirements and organize the information into a logical document using business analysis models that are understood by City staff. Create and maintain rich interactive visualizations through data interpretation and analysis integrating various reporting components from multiple data sources. Performs related work as assigned.

ESSENTIAL JOB FUNCTIONS:

• Manages and improves existing reporting systems.

• Performs complex analyses.

• Perform testing and validation of data sets

• Experience in data models and Business Intelligence packages (Power BI, Cognos, JasperSoft)

• Identify, analyze, and interpret trends or patterns in complex data sets.

• Strong knowledge of and experience with reporting packages (Business Objects etc.), databases (SQL etc.), programming (XML, JavaScript, or ETL frameworks)

• Knowledge of statistics and experience using statistical packages for analyzing datasets (Excel)

• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy

• Adept at queries, report writing and presenting findings

• Conducts and facilitates (and educates and trains on) analyses, issues identification, organizational risk assessment, and decision-making processes.

• Provides consulting and analytic services to leadership.

• Analyzes problems and determines root causes.

• Defines city data assets (data models), populate data models.

• Document structures and types of business data

• Works closely with all business units to develop strategy for long term data platform architecture.

• Performs other related duties as assigned.

MINIMUM REQUIREMENTS TO PERFORM WORK:

• Bachelor's degree in business administration, economics, computer science, management information systems, or related field or equivalent related experience

• Two+ years data analyst or related experience, including proficiency with analytical software or equivalent related education

• Valid South Carolina Class "D" Driver's License.

Knowledge, Skills and Abilities:

• Expert with Microsoft Excel and various business intelligence and analytical tools such as Cognos, Jaspersoft;

• Knowledge in data mining and statistical methods;

• Knowledge working with large data sets and understand how to manipulate and analyze them using various statistical and mathematical methods;

• Knowledge of the English language;

• Knowledge of personal and peripheral computer equipment with skill in performing data entry and in the use of Windows Operating Systems and Microsoft Office suite preferred, utilizing Outlook and all associated software programs;

• Ability to read and write technical instructions, procedures, manuals and charts to solve practical problems; composing routine reports and specialized reports, forms and business letters with proper format; speaking compound sentences using normal grammar and word form;

• Ability to collect, analyze and create reports from vendor data

• Ability to provide information, guidance or assistance to people to directly facilitate task accomplishment; may give directions or assignments to helpers or assistants;

• Ability to perform coordinating work involving guidelines and rules, with constant problem-solving tasks and personnel interactions;

• Ability to read journals, manuals and professional publications; speaking informally to groups of co-workers; presenting training; composing original reports, training and other written materials using proper language, punctuation, grammar and style;

• Ability to perform specialized technical or entry-level professional work requiring general understanding of operating policies and procedures and their application to problems not previously encountered; application of specialized technical or professional principles and practices or the use of a wide range of administrative methods in the solution of problems; requires normal attention with short periods of concentration for accurate results and occasional exposure to unusual pressure; and

• Ability to take actions of others, requiring almost constant decisions affecting co-workers, customers or others in the general public; works in a moderately fluid environment with guidelines and rules, but frequent variations from the routine.

PHYSICAL DEMANDS:

The work is considered light in nature and involves walking or standing some of the time and involves exerting up to 20 pounds of force occasionally, and/light lifting.

WORKING CONDITIONS:

Work environment involves exposure to no known environmental hazards; and is relatively safe, secure, and stable.