A complete application in a minute
Tailored resume and cover letter, ready to send.
The Metropolitan Council seeks a mid-level BI Developer to design and deliver data analytics solutions that support staff and the community across the Twin Cities region.
You will build BI data models, datasets, dashboards, and reports, translate business needs into requirements, monitor performance, and ensure governance and data quality. This role offers a hybrid work arrangement with on-site presence in Minnesota.
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 Services is 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.
The BI Developer is a mid-level role responsible for designing and delivering data and analytics solutions. This role Leverages structured and unstructured data to design and maintain BI data models, datasets, dashboards, reports, and visualizations. The role executes small to mid-size projects, contributes to data management strategies, and adheres to data governance and security requirements.
This posting will create a six-month eligibility list for current and future openings.
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.
Write SQL queries, scripts, and automation to support data processing and ensure data quality, integrity, and accessibility.
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 working with database technologies, programming languages, and concepts:
Mathematics, Economics, the Sciences, the Social Sciences, or related field) and experience working with database technologies, programming languages, and concepts.
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
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
Skill in developing reporting and BI data models, visualizations, standards, and accessibility methods.
Knowledge of reporting database architectures, including data stores, data lakes, data warehouses, and datamarts.
Skill in creating and administering analytical tools, subscriptions, and self-service BI solutions.
Ability to establish data and reporting best practices and consult with technology and business units.
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!
Union/Grade: AFSCME/Grade H
FLSA Status: Exempt
Safety Sensitive: No
Work is primarily performed in a standard office setting.
Once you have successfully completed the steps above, then:
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.
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, Affiant 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.