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