Job Information
City of Saint Paul Data and Systems Analyst &BI Developer in Saint Paul, Minnesota
Job Duties
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.
Here's what you can expect to do:
•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.
Minimum Education Required
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.
Minimum Experience Required
A combination of education and experience to equal eight years or more can be used to qualify for the position.
Shift
First (Day)
Number of Openings
1
Public Transportation Accessible
No
Veterans Encouraged to Apply
Yes
Physical Required
No
Drug Test Required
Yes
Compensation
$39.08 - $54.74 / Hourly
Postal Code
55102
Place of Work
Hybrid
Requisition ID
26-01663O
Job Type
Full Time
Job Benefits
Benefits include health insurance, PTO, retirement benefits including a penchant...etc. To find more benefits information, go to our website: https://www.stpaul.gov/departments/human-resources/benefits/general-benefits-overview
Application Link
https://www.governmentjobs.com/careers/stpaul/jobs/5235124/data-and-systems-analyst-bi-developer?pagetype=jobOpportunitiesJobs