Data and Systems Analyst & BI Developer

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.

• 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.

• 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.

We offer competitive wages, and a variety of excellent benefits, including health insurance, retirement contributions and paid vacation and sick time.

Equity, Inclusion and Belonging: The City of Saint Paul is dedicated to dismantling systemic racial, cultural, and economic barriers that prevent people from fully enjoying and participating in our community and ensuring fairness in opportunities and outcomes for all individuals. At the City of Saint Paul, we want our workforce to reflect the diverse city that we serve. Our leaders are guided by an unapologetic equity agenda, which promotes the belief that true equity is building a city that works for all of us.

We encourage you to apply as we are most interested in finding the best candidate for this job.

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.

Read our

How to Apply

Online Guide.

For help with the online application, please call 1‑855‑524‑5627.

The Qualifications…