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. Information about us on our website.

The 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 core services of the Council.

We are committed to supporting a diverse workforce that reflects the communities we serve.

How your work would contribute to our organization and the Twin Cities region:

The Bridge Fellow - Associate BI Developer is an entry-level role responsible for helping design, develop, and maintain business intelligence (BI) reporting and analytical solutions. They help collaborate with technology and business units to understand BI objectives and Key Performance Indicators and may use quantitative and/or qualitative analysis. They help create a variety of solutions including paginated reports, dashboards, interactive visualizations, metrics, dataflows, shared datasets, and/or predictive models (AI/ML). They help make these available to reporting consumers, including executives, managers, line-of-business users, business analysts, data scientists, citizen developers, government partners, and/or the public at large. They help administer, monitor, and maintain reporting solutions, ensuring their security, performance, and availability. They may also help administer BI tools and may identify and resolve data quality issues.

The Bridge Fellow - Associate BI Developer works on matters of limited complexity in a support role and their work is closely managed. They work with reporting solutions of less complexity that typically do not have council-wide impact and perform routine and less complex reporting and maintenance tasks. They are often directed in several aspects of the work. This role requires entry-level knowledge of reporting technologies, databases (DBs), data modeling, structured and unstructured data, and programming skills. They must learn and become aware of and comply with data governance and data security requirements.

What is the Bridge Program?
The Bridge Program is a long-term, two-year position, which allows students and recent graduates to bridge the gap between their education and experience to become successful in the workplace. The Bridge program is designed to be a long-term temporary (2 years) position. This position is eligible for benefits.

• Determine and analyze stakeholder requirements.
• Design, develop, and maintain reports, data visualizations, dashboards, metrics, and analytical solutions using a variety of BI tools and technologies.
• Utilize a variety of data sources including structured and unstructured data.
• Where applicable use operational and reporting DBs, data stores, data lakes, data warehouses, and data marts for reporting and analytics.
• Perform BI development using various software methodologies.
• Write and understand SQL queries and SQL best practices.
• Understand data security and data classifications.
• Innovate and leverage emerging technology.
• Provide on-going BI reporting production support and maintenance.
• Install and configure BI software.
• Script, automate, configure, and monitor BI processes.
• Setup and manage BI code repositories.
• Support non-production BI environments and code pipelines.
• Partner with Servers, Storage and Backup on server OS and file backups.
• Monitor BI performance, manage IS alerts and user subscriptions.
• Comply with all data-related federal, state, and local laws.
• Follow incident, service, and change management processes and procedures.
• Adhere to Data Practices retention schedules.
• Support end users with self-service reporting.

Bachelor's degree (or soon to graduate within 6 months) in computer science/engineering, information technology, or related field.

• Ability to gather and analyze stakeholder requirements.
• Ability to design, develop, and maintain reports, data visualizations, dashboards, metrics, and analytical solutions using a variety of BI tools and technologies.
• Experience using databases, data stores, data lakes, data warehouses, and/or data marts for reporting and analytics.
• Programming language knowledge with at least one scripting language.
• Writing SQL queries and defining BI standards and best practices.
• BI tools installation, administration, maintenance, and support.
• Production and Non-production BI environment support and code pipelines.
• Experience managing BI performance, alerts, and user subscriptions.
• Being up to date on emerging technologies around reporting and analytics.
• Experience consulting with technology and business units.
• Experience developing BI solutions for the cloud.
• Experience supporting self-service reporting.
• Experience with the Council's business processes and/or operations.

• 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.

Union/Grade: AFSCME/Grade E
FLSA Status: Non-Exempt
Safety Sensitive: No

Work Environment:
Work is performed in a standard office setting. Some positions may require travel between primary work site and other sites.

Full Salary Range: $29.69 - $44.82 hourly / $61,755 - $93,226 annually

What steps the recruitment process involves:

1. We review your minimum qualifications.
2. We rate your education and experience.
3. We conduct a structured panel interview.
4. We conduct a selection interview.