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.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.What you would do in this job: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.Minimum qualifications: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 experienceAssociate degree with six (6) years of experienceBachelor's degree with four (4) years of experienceMaster's degree with two (2) years of experienceSee complete job posting and apply:https://www.governmentjobs.com/careers/metrocouncil