Software Specialist II - Reporting & SQL

City of St. Louis

St. Louis (MO)

On-site

USD 65,000 - 90,000

Full time

28 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

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

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Software Specialist II (ITSA)
Software Specialist II (ITSA)

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

On-site
USD 65,000 - 90,000
SSRS Report Developer & Business Systems Support - St Louis
SSRS Report Developer & Business Systems Support - St Louis

Brand Addition • St. Louis (MO)

On-site
USD 70,000 - 100,000
Report Developer and Business Systems Support
Report Developer and Business Systems Support

Brand Addition • St. Louis (MO)

On-site
USD 70,000 - 100,000
Senior SQL & GIS Reporting Specialist
Senior SQL & GIS Reporting Specialist

Galvestontx • Galveston (TX)

On-site
USD 70,000 - 90,000
Staff Applications Specialist - Construction (St. Louis)
Staff Applications Specialist - Construction (St. Louis)

Burns & McDonnell • St. Louis (MO)

On-site
USD 70,000 - 90,000
Civic Tech Data & Reports Developer I
Civic Tech Data & Reports Developer I

Shelby County TN • Memphis (TN)

On-site
USD 65,000 - 90,000
Workforce Data & Organizational Performance Analyst
Workforce Data & Organizational Performance Analyst

SBS Creatix • United States

On-site
USD 70,000 - 90,000
CityWorks Applications Analyst — SQL & Crystal Reports Expert
CityWorks Applications Analyst — SQL & Crystal Reports Expert

Telnet, Inc. • Nashville (TN)

On-site
USD 70,000 - 95,000
Senior SQL Server Developer — Hybrid (St. Louis)
Senior SQL Server Developer — Hybrid (St. Louis)

Perceptive Recruiting, LLC • St. Louis (MO)

Hybrid
USD 100,000 - 150,000
IT Systems & Reporting Analyst
IT Systems & Reporting Analyst

City of Concord • Concord (NC)

On-site
USD 70,000 - 95,000