Business Intelligence (BI) Developer - NR

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

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

Metro Transit is one of the country's largest transit systems, employs more than 3,000 people, and provides ridership through an integrated network of buses, light rail and commuter trains, as well as resources for those who carpool, vanpool, walk or bike in the Twin Cities.

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, reports and apps (Power BI) available to a range of data consumers, including analysts, communication teams and department leaders. The position supports data quality and integrity, improves system performance, scalability, and security, and applies expertise in data architecture, database technologies, and data visualization. The role executes small to mid-size projects that includes data modeling and report/app design, contributes to data management strategies, and adheres to data governance and security requirements. The BI Developer gains exposure to increasingly complex tasks and may mentor others.

• Determine and analyze stakeholder requirements to inform BI solutions.
• Leverage reporting databases to design and maintain BI data models, datasets, dashboards, reports,apps,and visualizations.
• Design, develop, and implement BI data models and reporting architecture in partnership with Data Architects, leveraging structured and unstructured data from operational databases, data stores, data lakes, warehouses, and marts.
• Perform BI development using established software development methodologies and SQL best practices.
• Script, automate, configure, and monitor BI processes, environments, and code pipelines, including management of BI code repositories.
• Install, configure, and maintain BI software and supporting non-production environments.
• Provide ongoing BI production support, performance monitoring, alert management, and user subscriptions.
• Support end users with self-service reporting and data access.
• Partner with Servers, Storage, and Backup teams on BI infrastructure, including server operating systems and file backups.
• Ensure compliance with data security standards, data classifications, data retention schedules, and all applicable federal, state, and local data-related laws.
• Follow incident, service, and change management processes and procedures.
• Innovate and leverage emerging technologies to enhance BI capabilities.

Any of the following combinations of completed education (in Computer Science, Information Systems, Statistics, Mathematics, Economics, or related field) and experience (in data architecture, database technologies, data modeling, structured and unstructured data, and solid programming):

• High school diploma/GED with eight (8) years of experience
• Associate degree with six (6) years of experience
• Bachelor's degree with four (4) years of experience
• Master's degree with two (2) 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
• Designing reports and apps that are easy to read and interpret for diverse and non-technical audiences
• 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

• Knowledge of business intelligence platforms, tools, and reporting concepts.
• Knowledge of data architecture concepts, including relational and non-relational data and cloud-based BI solutions.
• Knowledge of data governance principles, including data classification, retention, security, and applicable data laws.
• Knowledge of BI standards, best practices, accessibility requirements, and emerging trends in analytics.
• Skill in writing, tuning, and optimizing queries.
• Skill in designing and supporting BI data models, reports, and dashboards.
• Skill in installing, configuring, and supporting BI tools, platforms, and integrations.
• Skill in supporting self-service reporting, subscriptions, and BI performance monitoring.
• Skill in consulting and collaborating with business and technology partners.
• Ability to analyze and communicate insights from structured and unstructured data.
• Ability to translate business needs into effective BI and reporting solutions.
• Ability to apply governance and security requirements to BI solutions.
• Ability to support reliable and scalable BI solutions and adapt to new technologies.

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!

Union/Grade: NRC/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:

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.

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.