Business Intelligence (BI) Developer
Print (https://www.governmentjobs.com/careers/metrocouncil/jobs/newprint/5291594)
Apply
?
Business Intelligence (BI) Developer
Salary
$88,566.40 - $143,707.20 Annually
Location
390 Robert St. N St. Paul, MN
Job Type
Full-Time
Job Number
2026-00084
Division
Regional Administration
Department
IS-Admin
Opening Date
04/02/2026
Closing Date
4/16/2026 11:59 PM Central
Description
Benefits
Questions
WHO WE ARE
This position is eligible for a hybrid (both remote and onsite) telework arrangement. Candidate's permanent residence must be in Minnesota or Wisconsin.
We are the Metropolitan Council, the regional government for the seven-county Twin Cities metropolitan area. We plan 30 years ahead for the future of the metropolitan area and provide regional transportation, wastewater, and housing services.
We are committed to supporting a diverse workforce that reflects the communities we serve.
Metropolitan Council's Regional Administration division provides enterprise services that are aligned with the Council's vision. We strive to be a trusted strategic partner by delivering integrated, collaborative, efficient, and responsive services.
Information Servicesis the central IT department supporting all divisions of the Metropolitan Council. Our 140 team members provide technology, practices, and innovative solutions that enable the Council's core services.
The Metropolitan Council is looking for a Business Intelligence (BI) Developer, where your creativity and technical skills will drive the transformation of the Council's data platform and Enterprise BI capabilities for our staff and our community.
How your work would contribute to our organization and the Twin Cities region:
The BI Developer is a mid-level role responsible for designing and delivering data and analytics solutions that increase organizational value and reduce data risk. This role collaborates with technology teams and business partners to make clean, reliable, and well-structured data available to a range of data consumers, including report developers, data scientists, analysts, and business users. The position supports data quality and integrity, improves system performance, scalability, and security, and applies expertise in data architecture, database technologies, data modeling, and programming. The role executes small to mid-size projects, contributes to data management strategies, and adheres to data governance and security requirements. The Data/BI Engineer gains exposure to increasingly complex tasks and may mentor others.
What you would do in this job
Data Engineering
Analyze stakeholder requirements and design data models, pipelines, and basic reporting databases (data stores, data warehouses, data marts).
Build and maintain ETL/ELT workflows, integrations, and dataflows that move and structure data for analysis and reporting.
Write SQL queries, scripts, and automation to support data processing and ensure data quality, integrity, and accessibility.
Monitor and optimize the performance, scalability, and security of reporting databases, integrations, and data pipelines.
Troubleshoot and resolve issues related to data pipelines, reporting databases, connectivity, and apply data security standards and retention schedules.
BI Engineering
Leverage reporting databases to design and maintain BI data models, datasets, dashboards, reports, and visualizations.
Translate business needs and KPIs into reporting requirements and develop solutions that support data-driven decision-making.
Monitor and tune the performance and usability of reports, dashboards, and visualizations, and troubleshoot related issues.
Apply data governance practices, including data classifications, compliance with applicable laws, and adherence to change management processes.
Support business units with self-service reporting, provide consulting on BI tools and standards, and innovate using emerging technologies.
What education and experience are required for this job (minimum qualifications)
Education/Experience:
Any of the following combinations of completed education (in Computer Science, Information Systems, Statistics, Mathematics, Economics, the Sciences, the Social Sciences, or related field) and experience (in data architecture, database technologies, data modeling, structured and unstructured data, and solid programming):
High school diploma/GED with seven (7) years of experience
Associate degree with five (5) years of experience
Bachelor's degree with three (3) years of experience
What additional skills and experience would be helpful in this job (desired qualifications):
Experience developing BI solutions for the cloud
Experience developing reports from start to finish, coding SQL, defining tables and relationships, developing metrics and quantitative measures, designing visualizations and report pages, and performing data analysis
Statistical analysis experience for business administration, econometrics, and/or public administration
Python and/or R programming experience
Experience working and collaborating in diverse, multicultural, and inclusive environments
What knowledge, skills, and abilities you should have within the first six months on the job:
Knowledge of data security, data classifications, and compliance requirements under applicable federal, state, and local laws.
Knowledge of database design, data modeling, normalization, and performance tuning methods.
Knowledge of reporting database architectures, including data stores, data lakes, data warehouses, and data marts.
Knowledge of cloud data platforms, big data tooling, and the ability to write and tune complex queries.
Knowledge of data retention requirements, investigation and response methods, and Data Practices standards.
Skill in building and maintaining data integrations, including APIs, web services, and integration platforms (iPaaS).
Skill in partnering with database and application teams to design and implement secure databases and environments.
Skill in developing reporting and BI data models, visualizations, standards, and accessibility methods.
Skill in creating and administering analytical tools, subscriptions, and self-service BI solutions.
Ability to conduct capacity planning and feasibility studies for data solutions.
Ability to establish data and reporting best practices and consult with technology and business units.
Ability to support a reporting enablement model or center of excellence to increase adoption and data maturity.
What you can expect from us:
We offer the opportunity to make a difference and positively influence the Twin Cities metropolitan area.
We encourage our employees to develop their skills through on-site training and tuition reimbursement.
We provide a competitive salary, excellent benefits and a good work/life balance.
More about why you should join us! (http://metrocouncil.org/Employment/Making-A-Difference.aspx)
Additional information
Union/Grade: AFSCME/Grade H
FLSA Status: Exempt
Safety Sensitive: No
Work Environment:
Work is primarily performed in a standard office setting.
What steps the recruitment process involves:
We review your minimum qualifications.
We rate your education and experience.
We conduct a structured panel interview.
We conduct a selection interview.
Once you have successfully completed the steps above, then:
If you are new to the Metropolitan Council , you must pass a background check which verifies education, employment, and criminal history. A driving record check and/or physical may be conducted if applicable to the job. If you have a criminal conviction, you do not automatically fail. The Metropolitan Council considers felony, gross misdemeanor and misdemeanor convictions on a case-by-case basis, based on whether they are related to the job and whether the candidate has demonstrated adequate rehabilitation.
If you are already an employee of the Metropolitan Council , you must pass a criminal background check if the job you're applying for is safety sensitive, is a supervisory or management job, is in the Finance, Information Services, Audit, or Human Resources departments, or has access to financial records, files/databases, cash, vouchers or transit fare cards. A driving record check and/or physical may be conducted if applicable to the position.
IMPORTANT: If you make a false statement or withhold information, you may be barred from job consideration.
The Metropolitan Council is an Equal Opportunity, Affirmative Action, and veteran-friendly employer. The Council is committed to a workforce that reflects the diversity of the region and strongly encourages persons of color, members of the LGBTQ community, individuals with disabilities, women, and veterans to apply.
If you have a disability that requires accommodation during the selection process, please email HR-OCCHealth@metc.state.mn.us.
We believe our employees are a key to our agency's success! In order to attract and retain high quality employees, the Council provides a highly competitive benefits package both in choice and coverage levels. Some highlights about our benefits are listed below:
Guaranteed monthly retirement income through Minnesota State Retirement System pension fund
Opportunity to save additional funds for retirement on a tax-deferred basis through a voluntary deferred compensation (457) plan
Two or more medical plans from which to choose, with employer contribution towards premiums over 80%
Dental insurance, life insurance and vision insurance
The following benefits are provided to all employees as part of working for the Council. You will have access to free:
Well@Work clinic
bus/rail pass valued at over $1200 per year
parking at many job locations
fitness centers at many job locations
Employee Assistance Program
extensive health and wellness programs and resources
01
Applicant Instructions: It is important that your application shows all relevant education and experience you possess. The supplemental questions listed below are to further evaluate your education and experience and to determine your eligibility for this position. Answer each question completely. The experience you indicate in your responses should also be consistent with the Work History section of this application. Resumes will not be accepted for this recruitment. I have read and understand the above instructions regarding my application and supplemental questions.
Yes
No
02
How did youfirsthear about this job opening?
CareerForce Center
Community Event/Organization
Employee Referral
Facebook
Glassdoor
Indeed
Job Fair
LinkedIn
Metro Transit Bus Advertisement
Twitter
Website: governmentjobs.com
Website: metrocouncil.org
Website: metrotransit.org
Website: minnesotajobnetwork.com
Other
03
If you selected 'Other', please describe where you first heard about this job. if you selected 'Employee Referral' please enter the employee's first and last name, ID number (if known), and job title. Type N/A if not applicable.
04
The Metropolitan Council recognizes that Artificial Intelligence (AI) and generative tools are increasingly used in application processes. While the Council permits the use of AI to assist in the preparation of application materials, all applicants must certify to the following:
I affirm that all information provided in my application including any uploaded documentation is true and accurate. I further affirm that I have personally reviewed, verified, and approved all content, including any content generated with the assistance of AI.
I will provide all interview responses directly and in real-time without unauthorized assistance. I will not use AI avatars, external assistance in answering including computer-generated suggestions, or any recording and transcription tools during the interview process unless I have received prior approval from Human Resources for a disability-related reasonable accommodation.
05
What is the highest level of education that you have completed and in what field of study?
06
Please select the option that best describes your completed education and experience.Education should be in Computer Science, Information Systems, Statistics, Mathematics, Economics, the Sciences, the Social Sciences, or related field. Experience should include data architecture, database technologies, data modeling, structured and unstructured data, and solid programming.
High school diploma/GED with seven (7) years of experience
Associate degree with five (5) years of experience
Bachelor's degree with three (3) years of experience
Master's degree with one (1) year of experience.
None of the above
07
Please describe your experience in data architecture, database technologies, data modeling, structured and unstructured data, and solid programming. If you do not have this experience, indicate 'N/A.'
08
Do you have Python and/or R programming experience?
Yes
No
09
Describe your experience with data visualization (Power BI/Tableau). If you do not have this experience, indicate 'N/A.'
10
Describe your experience developing reports from start to finish, coding SQL, defining tables and relationships, developing metrics and quantitative measures, designing visualizations and report pages, and performing data analysis. If you do not have this experience, indicate 'N/A.'
11
The Metropolitan Council values a workplace that is as diverse as the people we serve. Please describe your experience working and collaborating in a diverse, multicultural, and inclusive environment. If you do not have this experience, indicate 'N/A.'
Required Question
Employer
Metropolitan Council
Address
390 Robert St. N.St. Paul, Minnesota, 55101
Website
https://metrocouncil.org
Apply
Please verify your email addressVerify Email
