Job Information
City of Saint Paul Data and Systems Analyst & BI Developer in Saint Paul, Minnesota
Data and Systems Analyst & BI Developer
Print (https://www.governmentjobs.com/careers/stpaul/jobs/newprint/5235124)
Apply
Data and Systems Analyst & BI Developer
Salary
$81,286.40 - $113,859.20 Annually
Location
Saint Paul, MN
Job Type
Full Time
Job Number
26-01663O
Department
Saint Paul Regional Water Services
Opening Date
02/18/2026
Closing Date
3/19/2026 11:59 PM Central
Description
Benefits
Questions
About the Position
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.
For more information and essential functions, see our job description (https://www.governmentjobs.com/careers/stpaul/classspecs/772634?keywords=is%20info%20tech&pagetype=classSpecifications) .
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.
Our Benefits: We offer competitive wages, and a variety of excellent benefits (https://www.stpaul.gov/sites/default/files/2024-11/2025%20Summary%20of%20Benefits%20Document%20for%20AFSCME%20Technical.pdf) , including health insurance, retirement contributions and paid vacation and sick time.
The eligible list created from this assessment may also be used to fill IS Information/Technical Analyst IV positions as they become available in various departments within the City.
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.
Position Requirements
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.
How to Apply
Submit a City of Saint Paul online application by the closing date.
Upload or submit the following required document via the online application system. (Zip files and web links will not be accepted. Each uploaded attachment is limited to 10MB.)
A resume
First time applying online? Read our How to Apply Online Guide (https://www.stpaul.gov/departments/human-resources/jobs/how-apply) .
Need technical support? For help with the online application, please call 1-855-524-5627.
Learn more about our Hiring Process
Assessment: Qualifications Rating
The Qualifications Rating is an assessment of your completed application and answers to the Supplemental Questionnaire. Be as specific and detailed as possible in completing your application and questionnaire. You must submit your completed application and supplemental questionnaire by the application deadline.
GENERAL INFORMATION:
Open Job Posting: This posting is open to anyone who meets the position requirements.
Eligible Lists Created from Open Job Posting: You must receive a score of 75% or higher to pass the assessment and be considered for the position. Non-promotion eligible lists typically are pass/fail and promotion eligible lists are typically ranked. If the open eligible list created contains a veteran, one open list will exist. When there are no veterans remaining on the eligible list (i.e. hired, withdrawn) from an open list that also contains promotional candidates, two lists will be created: one open list and one promotion list. If two lists exist, the promotion list must be exhausted before the open list is considered.
Final Selection Process: Those who pass will be placed on an eligible list for approximately six months and all will be notified of their status. A Hiring Manager will consider those applicants eligible for hire. You will be notified if you are invited to participate in the final selection process which may include an interview, job simulation, work sample submission, or other evaluation method.
Condition of Employment: This position also requires a background check and may require a driver’s license check drug test. Candidates will be required to submit proof of education to Human Resources upon conditional job offer. This position may be subject to limited on-call status for after-hours services associated with the assignment.
Human Resources Contact Information:
Danni Smith at 651-266-6566
Email: danni.smith@stpaul.gov
The City of Saint Paul encourages individuals to apply for positions regardless of criminal history.
Veteran’s Preference: If you are a veteran and would like to receive Veteran’s preference in accordance with MN Statute 197.455, you must submit a photocopy of your DD214 preferably at time of application. Click here for more information. (https://www.stpaul.gov/departments/human-resources/jobs/how-apply)
Equal Employment Opportunity Statement: The City of Saint Paul is an equal opportunity/affirmative action employer. Veterans, women, persons of color, members of the LGBTQIA+ community, and individuals with disabilities are strongly encouraged to apply.
Working Title: Data and Systems Analyst & BI Developer
Official Title: IS Info/Technical Analyst IV
The City of Saint Paul offers a competitive benefits package for permanent, certified positions. Temporary positions are not eligible for benefits.
Benefits vary with each position and the collective bargaining agreement. Benefits may include:
City Paid Benefits
Health Insurance
Vacation/Holidays
Sick Leave
Life Insurance
Subsidized Metro Bus Pass
Deferred Compensation
Retirement Program
Optional Benefits
Dental
Flexible Spending Accounts
Disability Insurance
Accidental Death and Dismemberment Insurance
Long Term Care Insurance
For a detailed overview, visit General Benefits (https://www.stpaul.gov/departments/human-resources/employee-retiree-benefits/general-benefits-overview) .
01
The thorough completion of the supplemental questions is very important in the screening and application processes. Therefore, a lack of detail and explanation in the supplemental questions and in your application, may result in failure or disqualification for this position. In addition, documentation of work experience referred to in the supplemental questions must be included in the application. Your education, training, and experience are subject to verification. I understand that giving false information, failure to accurately represent myself, or not providing required documentation as listed on the job announcement will result in disqualification from this position.
Yes
02
Do you possess a valid Minnesota Class D Driver's License or equivalent out-of-state driver's license?
Yes
No
03
How do you best qualify for this position?
A Bachelor's Degree in Information Management, Computer Technology, or a related field and four (4) years of work experience related to the vacancy
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
None of the above
04
This role will be responsible for supporting and maintaining enterprise applications and data platforms. Please indicate which of the following you have professional experience with? (Check all that apply)
Leading complex systems analysis and solution design for enterprise applications and data platforms
Designing, developing, and optimizing advanced SQL queries, views, functions, and stored procedures to support analytics, integrations, and operational reporting
Ensuring enterprise data integrity, validation and reconciliation
Leading development of dashboards, analytical models, and visualizations
Evaluating vendor solutions, participate in system selection, and support cloud migrations
Developing and maintaining technical documentation, SOPs, and training materials
None of the above
05
In detail, describe how you have partnered with infrastructure, application, security, and/or service management teams to maintain configuration accuracy and shared ownership of data? What was your role and responsibilities?
06
In detail, describe your experience managing multiple high priority projects simultaneously. What methods or steps do you take to adhere to agreed upon timelines to ensure success of the projects?
07
In detail, describe a time you were part of a team that was responsible for a technical initiative. What was your role? Describe how responsibilities were shared, how the team addressed challenges, and how the team’s efforts led to a positive outcome.
08
In detail, describe your experience providing customer service to both technical and non-technical customers, including internal and external stakeholders. How do you tailor your communication to different audiences while ensuring accuracy and understanding, while maintaining a positive customer experience.
09
I am currently a Right Track Worker or have been employed by the City of Saint Paul as a Right Track Worker in the past.
Yes
No
10
RECRUITMENT: How did you first find your way to our website to apply for this position? (check all that apply)
City of Saint Paul website
City of Saint Paul employee
City of Saint Paul job interest card
City of Saint Paul walk-in
City of Saint Paul Posted! newsletter
City of Saint Paul Gov.Delivery notifications
Friend or family member
League of Minnesota Cities website
Governmentjobs.com website
LinkedIn
Facebook
X (formerly known as Twitter)
Indeed.com website
ZipRecruiter
Pollen website
MinnesotaWorks.net
College or University
Community organization
Job fair
Professional association
Saint Paul Elevate Session
People of Color Career Fair
Other
11
RECRUITMENT: If not indicated above, please specify where you heard about the position (e.g., specific organization/website name, City of Saint Paul employee name).
12
Are you currently a Saint Paul resident?
Yes
No
Prefer not to answer
13
If you indicated "yes" as a current Saint Paul resident, please indicate your zip code.
Required Question
Employer
City of Saint Paul
Address
25 West Fourth Street, Suite 200 City Hall Annex Saint Paul, Minnesota, 55102
Phone
651-266-6500
Website
http://www.stpaul.gov/jobs
Apply
Please verify your email address Verify Email