Software Specialist II (ITSA)

City of St. Louis

St. Louis (MO)

On-site

USD 65,000 - 90,000

Full time

29 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

City of St. Louis seeks a Software Specialist II (ITSA) to design and optimize complex reporting solutions. You will develop templates using ActiveReports.NET, write SQL queries for data extraction, and troubleshoot reporting workflows for diverse city stakeholders.

The role emphasizes template development, data analysis, and maintaining a robust repository of report templates, with a focus on accuracy and performance in a municipal context.

Qualifications

  • Bachelor's degree and 1 year of experience in template design and database development.
  • Experience with Mescius' ActiveReports (or similar BI/reporting tools) and SQL.

Responsibilities

  • Design and edit ActiveReports Templates: develop and modify dynamic reporting layouts using Mescius' ActiveReports.NET desktop designer.
  • Create and update report templates (*.rdlx, section, and page reports) to meet specific business and stakeholder requirements.
  • Implement advanced report controls, groupings, drill-downs, and custom styling to make complex datasets readable and professional.
  • Test, preview, and troubleshoot template errors, formatting issues, and visual bugs across different viewing and export formats (PDF, Excel, etc.).
  • Report Administration: assist in organizing, deploying, and maintaining the repository of active report templates, ensuring proper version control and access.

Skills

Data analysis
Verbal aptitude
Analytical thinking
Attention to detail

Education

Bachelor's degree in CS/IT

Tools

ActiveReports
SQL Server
Git

Job description

Job Description - Software Specialist II (ITSA) (260000SH)

Job Description

Software Specialist II (ITSA) - ( 260000SH )

Description

Position Grade: 210G
Department: ITSA
Job Type: Full-Time (Permanent)
Examination Number: EX1842
Location: Downtown - St. Louis, MO

This position uses their technical expertise in report design, data extraction, and database systems to create, modify, and optimize complex reporting solutions. This role focuses heavily on developing and maintaining reporting templates using Mescius' ActiveReports and writing, optimizing, and troubleshooting SQL queries to fetch and analyze business-critical data for diverse organizational stakeholders.

Essential Functions and Responsibilities:
Template Creation and Editing
  • ● Design and Edit ActiveReports Templates: Develop and modify dynamic reporting layouts using Mescius' ActiveReports.NET desktop designer.
  • ○ Create and update report templates (*.rdlx, section, and page reports) to meet specific business and stakeholder requirements.
  • ○ Implement advanced report controls, groupings, drill-downs, and custom styling to make complex datasets readable and professional.
  • ○ Test, preview, and troubleshoot template errors, formatting issues, and visual bugs across different viewing and export formats (PDF, Excel, etc.).
  • ● Report Administration: Assist in organizing, deploying, and maintaining the repository of active report templates, ensuring proper version control and access.
SQL Query Development and Support
  • ● Data Gathering and SQL Optimization: Write and maintain SQL queries to feed data sources ActiveReports templates.
  • ○ Analyze database schemas and write complex SQL queries to retrieve exact data requírements from relational databases (Microsoft SQL Server).
  • ● Service Request Troubleshooting: Diagnose and resolve data and reporting workflow-related support tickets from end users or business owners.
  • ○ Investigate why a report might render incomplete, slow, or incorrect data, addressing query logic or template mapping issues.
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, calibrate, tune and synchronize, and perform complex rapid adjustment on equipment, machinery and tools such as a computer terminal, personal computer 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 program specifications, technical operating manuals, work requisitions, run books, procedures, and non-routine correspondence.
  • ● Mathematical Aptitude: Requires the ability to perform addition, subtraction, multiplication and division; calculate percentages, and decimals.
  • ● 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 in an office environment under generally safe and comfortable conditions where exposure to irate individuals poses a very limited risk of injury.
  • ● 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 to ten pounds, such as peripheral computer equipment. 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 associated with job-related objects, materials and tasks, such as testing computer programs.
Qualifications

A Bachelor's degree in Computer Science, Information Technology, or a related field; plus one year of experience in template design and database development. OR an equivalent combination of education, training and experience.

Qualifying experience must include some experience working with Mescius' ActiveReports (or similar Business Intelligence (BI)/reporting frameworks) and SQL.

Preferences:
  • ● Strong proficiency in writing complex T-SQL queries (joins, subqueries, aggregate functions).
  • ● Proficiency in using ActiveReports Desktop.
  • ● Familiarity with Git version control.
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
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.

  • City of St. LouisCity Hall1200 Market StreetSaint Louis, MO 63103
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Systems Project Leader (ITSA)
Systems Project Leader (ITSA)

City of St. Louis • St. Louis (MO)

On-site
USD 85,000 - 120,000
Administrative Assistant II (Equipment Services)
Administrative Assistant II (Equipment Services)

City of St. Louis • St. Louis (MO)

On-site
USD 42,000 - 52,000
Administrative Assistant II (Talent Acquisition/Onboarding)
Administrative Assistant II (Talent Acquisition/Onboarding)

City of St. Louis • St. Louis (MO)

On-site
USD 47,000 - 71,000
Senior Plan Examiner (Buildings) - (260000IL)
Senior Plan Examiner (Buildings) - (260000IL)

Engineers Club • St. Louis (MO)

On-site
USD 65,000 - 90,000
Attorney III (Litigation)
Attorney III (Litigation)

City of St. Louis • St. Louis (MO)

On-site
USD 90,000 - 135,000
Administrative Assistant II (SLATE)
Administrative Assistant II (SLATE)

City of St. Louis • St. Louis (MO)

On-site
USD 40,000 - 55,000
Estimator (Water)
Estimator (Water)

City of St. Louis • St. Louis (MO)

On-site
USD 52,000 - 68,000
Health Care Compliance Specialist
Health Care Compliance Specialist

City of St. Louis • St. Louis (MO)

On-site
USD 60,000 - 90,000
Auditor
Auditor

City of St. Louis • St. Louis (MO)

On-site
USD 65,000 - 100,000
Deputy Commissioner of Buildings - Promotional Only
Deputy Commissioner of Buildings - Promotional Only

City of St. Louis • St. Louis (MO)

On-site
USD 95,000 - 140,000