> Markdown version of [/jobs/ext/685307-business-intelligence-developer](https://www.wearedevelopers.com/jobs/ext/685307-business-intelligence-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Business Intelligence Developer - **Company:** City of Saint Paul - **Location:** Saint Paul, MN, United States - **Experience:** Starter - **Salary:** $90,917.0 - $126,651.0 - **Contract:** Temporary contract - **Skills:** Databases, Extract Transform Load (ETL), Data Manipulation Languages, Data Security, Data Visualization, Data Warehousing, Information Management, Python (Programming Language), Microsoft SQL Server, Power BI, Standard Sql, SQL Server Reporting Services, SQL Server Integration Services, Technical Data Management Systems, Azure Data Factory, Information Technology, Data Management, Tools for Reporting, Data Pipelines - **Published:** June 28, 2026 - **Apply:** https://www.juju.com/job/00000000gbx2qv ## About the Role 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? ## Description + 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 ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Behind the Curtain: How Recruiters Shortlist Devs in an AI-Driven Market and How You Stand Out](https://www.wearedevelopers.com/videos/100229-behind-the-curtain-how-recruiters-shortlist-devs-in-an-ai-driven-market-and-how-you-stand-out) - [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Crypto-secure Data Management with In-Database Blockchain](https://www.wearedevelopers.com/videos/632-crypto-secure-data-management-with-in-database-blockchain) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) ## Related Articles - [How to Answer the Interview Question: “Why Do You Want to Be a Software Engineer?”](https://www.wearedevelopers.com/magazine/392-how-to-answer-the-interview-question-why-do-you-want-to-be-a-software-engineer) - [How to Write a CV and Interview if You Don't Fully Qualify For The Job](https://www.wearedevelopers.com/magazine/183-how-to-write-a-cv-and-interview-if-you-don-t-fully-qualify-for-the-job) - [How to Answer the “Why Should We Hire You” Interview Question](https://www.wearedevelopers.com/magazine/321-how-to-answer-the-why-should-we-hire-you-interview-question) - [The 10 C++ programming questions to expect in an interview](https://www.wearedevelopers.com/magazine/50-the-10-c-programming-questions-to-expect-in-an-interview) - [Quick guide: How to write a Software Developer CV](https://www.wearedevelopers.com/magazine/37-quick-guide-how-to-write-a-software-developer-cv) - [Starter Kit For Job Applications For Developers](https://www.wearedevelopers.com/magazine/7-starter-kit-for-job-applications-for-developers)