Programmer/Analyst II (Data Analyst)

Salary: $59,956 - $93,886

Position Grade: 16G

Department: ITSA

Job Type: Full-Time (Permanent)

Examination Number: EX1642

Location: Downtown - St. Louis, MO

• Position to start after July 1, 2026.

The Data Analyst will take responsibility for managing the Information Technology Service Agency’s master data set, developing reports, and troubleshooting data issues using detail, experience as a Data Analyst, and a deep understanding of the popular data analysis tools and databases.

Essential Functions and Responsibilities:

• Identifies and analyzes trends and forecasts and recommends improvements to the business processes.
• Develops and maintains automated data pipelines for ingestion of various city datasets into the city’s data warehouse.
• Manages master data, including creation, updates, and deletion.
• Provides quality assurance of imported data, working with quality assurance analysts if necessary.
• Commissions and decommissions data sets.
• Processes confidential data and information according to guidelines.
• Develops reports and analysis, generates reports from single or multiple systems.
• Manages and designs the reporting environment, including data sources, security, and metadata.
• Supports the data warehouse in identifying and revising reporting requirements.
• Supports initiatives for data integrity and normalization.
• Assesses tests and implementing new or upgraded software and assisting with strategic decisions on new systems.
• Troubleshoots the reporting database environment and reports.
• Evaluates changes and updates to source production systems.
• Uses automated tools to extract data from primary and secondary sources.
• Removes corrupted data and fixing coding errors and related problems.
• Develops and maintains databases, data systems – reorganizes data in a readable format.
• Performs analysis to assess quality and meaning of data.
• Filters data by reviewing reports and performance indicators to identify and correct code problems.
• Uses statistical tools to identify, analyze, and interpret patterns and trends in complex data sets that could be helpful for the diagnosis and prediction.
• Provides technical expertise in data storage structures, data mining, and data cleansing.
• Assigns numerical value to essential business functions so that agency performance can be assessed and compared over periods of time.
• Analyzes local, national, and global trends that impact both the organization and the industry.
• Prepares reports for the management of trends, patterns, and predictions using relevant data.
• Performs other duties as assigned.

Knowledge, Skills and Abilities:

• Data Utilization: Requires the ability to perform mid-level data analysis including the ability to audit, deduce, assess, conclude and appraise. Requires discretion in determining and referencing such to established criteria to define consequences and develop alternatives.
• Human Interaction: Requires the ability to provide guidance, assistance and/or interpretation to others, such as coworkers and the public, on how to apply policies, procedures and standards to specific situations.
• Equipment, Machinery, Tools and Materials Use: Requires the ability to operate and perform complex rapid adjustment on equipment, machinery and tools such as personal computers, modems, and/or related materials used in performing essential functions.
• Verbal Aptitude: Requires the ability to utilize a variety of reference, descriptive and advisory data and information such as, technical operating manuals, requisitions, procedures, and non-routine correspondence.
• Mathematical Aptitude: Requires the ability to perform addition, subtraction, multiplication and division; calculate percentages, and decimals; requires the ability to interpret descriptive statistics.
• Functional Reasoning: Requires the ability to apply principles of rational systems. Ability to interpret instructions furnished in written, oral, diagrammatic or schedule form. Ability to exercise independent judgment to adopt or modify methods and standards to meet variations in assigned objective
• Situational Reasoning: Requires the ability to exercise the judgment, decisiveness and creativity required in situations involving the evaluation of information against measurable or verifiable criteria.
• Environmental Factors: Work is normally performed under generally safe and comfortable conditions without exposure to adverse environmental conditions.
• Physical Requirements: Tasks involve the ability to exert light physical effort in sedentary to light work, but which may involve some lifting, carrying, pushing and pulling of objects weighing five (5) to ten (10) pounds, such as computer hardware. Tasks may involve extended periods of time at a keyboard or workstation.
• Sensory Requirements: Requires the ability to recognize and identify individual characteristics of colors, shapes, and sounds textures associated with job-related objects, materials and tasks, such as installing new software.

A Bachelor’s degree in Statistics, Computer Science, Information Technology, or a closely related field; plus three years of experience as a Data Analyst, Database Administrator, or a related position monitoring, managing, manipulating and drawing insights from data. OR an equivalent combination of education, training, and experience.

Preferences:

• Strong programming skills, i.e. SQL, SAS, and other query languages.
• Experience with scripting tools (Python).
• Experience with data warehousing, Snowflake preferred.
• Experience with data visualization tools: Tableau, Power BI, etc.
• Experience with ArcGIS/Esri.

Scoring Components and Their Weights
Experience and Training: 100%
May be Subject to:
Background Investigation: Pass/Fail
Medical Examination: Pass/Fail

Documentation of Academic Credentials must be Submitted Upon Request

When completing the Employment History and the Educational/Training History sections of the Employment Application, please be as thorough as possible when describing your education, training and experience relating to this position. Applicants will only receive credit for their experience, training and education as shown on the application. Resumes will not be accepted as a substitute to a fully completed application. Incomplete applications will not be considered.

Veterans Preference Points

To be eligible for veteran's preference points, the applicant must submit a copy of their DD 214 Certificate of Release or Discharge from Active Duty with the Employment Application or upon request. The Director of Personnel may, in their discretion, accept alternate documentation.

City Residence Preference Points

City residents who pass an examination for a position in the classified service and do not receive any other preference will receive a five (5) point preference on a scale of 100 points on the exam. An additional one (1) point shall be added to the passing score of City residents who receive any other preference on a scale of 100 points. City residents must have resided in the City for at least one (1) year at the time of filing their application to be eligible for the preference points.

Accommodations

If assistance with the job application is necessary based on a physical impairment, mental impairment, or otherwise, they should reach out to the Office on the Disabled with contact information. This office will not disclose any information that an applicant or employee has a disability or has discussed possible accommodations without the applicant's or employee's prior consent.