Business Intelligence (BI) Developer - NR

Metropolitan Council•Minneapolis, MN

13h•Hybrid

About The Position

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. This position is eligible for a hybrid (both remote and onsite) telework arrangement. The candidate's permanent residence must be in Minnesota or Wisconsin. This posting may be used to establish a six-month eligibility pool for current and future openings.

Requirements

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
Experience in data architecture, database technologies, data modeling, structured and unstructured data, and solid programming.

Nice To Haves

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

Responsibilities

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.