Business Intelligence Developer
Apply NowCompany: City of Saint Paul, MN
Location: Saint Paul, MN 55106
Description:
Salary : $91,266.48 - $130,625.28 Annually
Location : Saint Paul, MN
Job Type: Full Time
Remote Employment: Flexible/Hybrid
Job Number: 25-UNSP-01121
Department: Office of Technology and Communication
Opening Date: 03/25/2025
Closing Date: 4/15/2025 11:59 PM Central
About the Position
The Business Intelligence Developer will be a key member of the City's Information Systems team, playing a vital role in shaping the direction of data usage within the City. This position will involve creating reporting and analytics, providing decision-makers with actionable insights, and collaborating with business partners across the City to gather requirements. The developer will support enterprise data projects, identify key performance indicators (KPIs), and create meaningful data visualizations that business partners can leverage to effectively manage the City of Saint Paul. Additionally, the role will contribute to promoting a data-driven culture throughout the City.
Primary responsibilities of this role include:
Our Benefits: We offer competitive wages, and a variety of , 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.
Position Requirements
A Bachelor's Degree in Information Management, Computer Technology or related field; and four (4) years of vacancy-related work experience, or vacancy-related technical school certificate and six (6) years of work experience related to the vacancy.
Work experience must have included business analysis and project definition that would allow one to gain a good understanding of technology relevant to the vacancy.
Professional experience may be substituted for education on a year for year basis. A combination of education and experience must total 8 years or more.
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.)
First time applying online? Read our
Need technical support? For help with the online application, please call 1-855-524-5627.
Learn more about our Hiring Process
Open Job Posting: This posting is open to anyone who meets the position requirements.
Selection Process: Applicants who meet the minimum job requirements will be placed on a hiring list for consideration. Hiring Managers may interview/hire anyone from the list. 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.
Pre-Employment Screening: This position may require a driver's license check, and a background check which may include criminal history, and employment history as a condition of employment. Candidates will be required to submit proof of education to Human Resources upon conditional job offer, if qualifying based on education.
Condition of Employment: This position also requires a background check and may require a driver's license check. Candidates will be required to submit proof of education to Human Resources upon conditional job offer. The City of Saint Paul encourages individuals to apply for positions regardless of criminal history. This position may be subject to limited on-call status for after-hours services associated with the assignment.
Human Resources Contact Information:
Consultant Name at 651-266-6533
Email:
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.
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: Business Intelligence Developer
**Official Title: IS Systems Consultant II
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
Optional Benefits
For a detailed overview, visit
01
The thorough completion of the supplemental questions is very important in the screening and assessment 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.
02
Please select from the options below that reflect the skills/tools you have experience using as part of your data related work:
03
Based on your selections above, please describe your work related experience with each selection. Please include your role, responsibility, and length of experience with each skill and/or tool. If you selected none of the above, type N/A.
04
Provide an example of when you had to communicate business solutions to a technical and non-technical audience. How did you ensure understanding and what means of communication did you employ?
05
Describe your experience collaborating in a team environment. What methods do you use to effectively communicate, and how do you ensure a favorable outcome when there are competing interests from multiple stakeholders.
06
RECRUITMENT: How did you first find your way to our website to apply for this position? (check all that apply)
07
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).
08
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.
Required Question
Location : Saint Paul, MN
Job Type: Full Time
Remote Employment: Flexible/Hybrid
Job Number: 25-UNSP-01121
Department: Office of Technology and Communication
Opening Date: 03/25/2025
Closing Date: 4/15/2025 11:59 PM Central
About the Position
The Business Intelligence Developer will be a key member of the City's Information Systems team, playing a vital role in shaping the direction of data usage within the City. This position will involve creating reporting and analytics, providing decision-makers with actionable insights, and collaborating with business partners across the City to gather requirements. The developer will support enterprise data projects, identify key performance indicators (KPIs), and create meaningful data visualizations that business partners can leverage to effectively manage the City of Saint Paul. Additionally, the role will contribute to promoting a data-driven culture throughout the City.
Primary responsibilities of this role include:
- Participates in development and creation of data warehouse and database reporting environments
- Designs and develops ETL process and data pipelines
- Designs and develops appropriate data models and implements them in the necessary technology
- Writes and troubleshoots SQL code
- Contributes to enterprise data infrastructure planning and development
- Works with business partners to define and develop solutions for business intelligence needs
- Communicates with front-end users to ensure deliverables meet expectations
- Develops reporting frameworks and reporting deliverables
- Helps business users leverage the appropriate business intelligence techniques and tools
- Provides training and capacity building support in data stewardship to business partners
- Manages the City's data and metadata to ensure security, extensibility and truth
- Champions data culture in the City
- Provide data access for City staff and the public via enterprise data access tools.
- For more information and essential functions, see our job description
Our Benefits: We offer competitive wages, and a variety of , 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.
Position Requirements
A Bachelor's Degree in Information Management, Computer Technology or related field; and four (4) years of vacancy-related work experience, or vacancy-related technical school certificate and six (6) years of work experience related to the vacancy.
Work experience must have included business analysis and project definition that would allow one to gain a good understanding of technology relevant to the vacancy.
Professional experience may be substituted for education on a year for year basis. A combination of education and experience must total 8 years or more.
May require a valid Minnesota Class D Driver's License, or equivalent out-of-state driver's license.
How to Apply
- A resume
First time applying online? Read our
Need technical support? For help with the online application, please call 1-855-524-5627.
Learn more about our Hiring Process
Open Job Posting: This posting is open to anyone who meets the position requirements.
Selection Process: Applicants who meet the minimum job requirements will be placed on a hiring list for consideration. Hiring Managers may interview/hire anyone from the list. 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.
Pre-Employment Screening: This position may require a driver's license check, and a background check which may include criminal history, and employment history as a condition of employment. Candidates will be required to submit proof of education to Human Resources upon conditional job offer, if qualifying based on education.
Condition of Employment: This position also requires a background check and may require a driver's license check. Candidates will be required to submit proof of education to Human Resources upon conditional job offer. The City of Saint Paul encourages individuals to apply for positions regardless of criminal history. This position may be subject to limited on-call status for after-hours services associated with the assignment.
Human Resources Contact Information:
Consultant Name at 651-266-6533
Email:
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.
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: Business Intelligence Developer
**Official Title: IS Systems Consultant II
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
01
The thorough completion of the supplemental questions is very important in the screening and assessment 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
Please select from the options below that reflect the skills/tools you have experience using as part of your data related work:
- SSIS
- SSRS
- Power BI
- SQL Server (DML and/or DDL)
- Python
- Azure data tools / Data Factory / Fabric
- None of the Above
03
Based on your selections above, please describe your work related experience with each selection. Please include your role, responsibility, and length of experience with each skill and/or tool. If you selected none of the above, type N/A.
04
Provide an example of when you had to communicate business solutions to a technical and non-technical audience. How did you ensure understanding and what means of communication did you employ?
05
Describe your experience collaborating in a team environment. What methods do you use to effectively communicate, and how do you ensure a favorable outcome when there are competing interests from multiple stakeholders.
06
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
- 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
07
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).
08
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
Required Question