Business Intelligence Developer

• Design, build, and maintain City’s data warehouse, data models, and database/reporting environments

• Develop and manage Extract Transform Load (ETL) processes and data pipelines

• Write, troubleshoot, and maintain SQL code

• Contribute to enterprise data infrastructure planning and development

• Develop reporting frameworks and produce reporting deliverables

• Manage the City’s data and metadata to ensure security, extensibility, and accuracy

• Provide data access to City staff and the public via enterprise data access tools

• Collaborate with City departments to understand business needs and develop effective solutions

• Communicate with end users to ensure reporting and analytics deliverables meet expectations

• Help business users leverage appropriate business intelligence tools, techniques, and best practices

• Provide business partners with training and capacity-building support in data stewardship and data literacy

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.

A combination of education and experience to equal 8 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., 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 process. 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

Which of the following represents your highest level of completed education?

• High School diploma or GED

• Associate’s Degree

• Bachelor’s Degree

• Master’s Degree, How many years of professional experience do you have in supporting enterprise data projects, identifying key performance indicators, and creating data visualizations? (1 year of experience = 2080 hours/40 hours a week) Your application must show experience that supports your answer.

• Less than two years

• Two years but less than three years

• Three years but less than four years

• Four years but less than five years

• Five years but less than six years

• Six years but less than seven years

• Seven years but less than eight years

• Eight years or more

• None of the above

04

Which of the following do you have professional experience in? (Check all that apply) Your application must show experience that supports your answer

• Clarifying the goals, scope, data needs, and expected outcomes of a data project before development begins.

• Eliciting and defining business needs and translating them into technical data requirements and solution designs.

• None of the above

05

Which of the following reflect the skills/tools you have experience using as part of your data related work? (Check all that apply)

• SSIS

• SSRS

• Power BI

• SQL Server (DML and/or DDL)

• Python

• Azure data tools/Data factory/Fabric

• None of the above

06

Based on your selections above, please describe your work-related experience with each section. Please include your role, responsibilities, and length of experience with each skill and/or tool. If you selected none of the above, type N/A.

07

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?

08

Describe your experience working on projects in a team environment. What methods do you use to effectively communicate and how do you ensure a successful and collaborative outcome when there are multiple stakeholders?

This position is located at 25 4th St. W, Saint Paul, MN offering a hybrid schedule with mandatory in office days on Wednesdays and expected to be in office 2-3 days a week.

Our Benefits: We offer competitive wages, and a variety of excellent benefits (https://www.stpaul.gov/sites/default/files/human-resources/2026-summary-benefits-document-professional-employees.pdf) , 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., 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