Description
The City of Saint Paul Regional Water Services is hiring an individual to support and maintain enterprise applications and data platforms, with a focus on advanced SQL, analytics, and system integrations across cloud-based and on-prem environments. This role ensures data integrity, delivers dashboards and reporting for operational and decision-making needs, resolves complex system and data issues, and contributes to modernization and continuous improvement efforts.
The ideal candidate for this position will possess the following:
- Experience designing Power BI semantic models and dashboards.
- Experience supporting cloud-based (SaaS) platforms, including data access, reporting, and integration with on-prem systems.
- Experience designing, writing, and maintaining REST and SOAP API calls.
- Scripting/programming experience (Python, JavaScript, or similar) for automation and analytics.
- Experience leveraging the Microsoft 365 platform (SharePoint, Power Automate, Power Apps, Excel Power Query) to automate workflows, data collection, reporting, and system integrations.
- Familiarity with data governance, security, and compliance in regulated environments.
- Experience in public sector, utilities, or critical infrastructure environments.
Responsibilities
- Lead complex systems analysis and solution design for enterprise applications and data platforms.
- Design, develop, and optimize advanced SQL queries, views, functions, and stored procedures to support analytics, integrations, and operational reporting.
- Architect and maintain ETL and data integration workflows across cloud-based and on-prem systems.
- Ensure enterprise data integrity, validation and reconciliation.
- Lead development of dashboards, analytical models, and visualizations to support executive, operational, and regulatory decision-making.
- Support system-to-system integrations, including REST/SOAP APIs, secure file exchanges, and database connections.
- Evaluate vendor solutions, participate in system selection, and support cloud migrations and modernization initiatives.
- Troubleshoot and resolve complex application, integration, and data issues; perform root-cause analysis and implement long-term fixes.
- Establish technical standards, documentation, and best practices for analytics, reporting, and data access.
- Develop and maintain technical documentation, SOPs, and training materials; provide advanced user and staff training.
For more information and essential functions, see our job description.
Qualifications
A Bachelor's Degree in Information Management, Computer Technology, or a related field and four (4) years of work experience related to the vacancy
Or
A vacancy-related technical school certificate and six (6) years of work experience related to the vacancy.
A combination of education and experience to equal eight years or more can be used to qualify for the position.
May require a valid Minnesota Class D Driver's License, or equivalent out-of-state driver's license.
City of Saint Paul
Saint Paul, Ramsey, Minnesota 55102
US
