Business Intelligence (BI) Developer - NR

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

Do you have experience in Statistical analysis?, Do you have a Master’s degree?, 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

What knowledge, skills, and abilities you should have within the first six months on the job:

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

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

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.

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., We believe our employees are a key to our agency’s success! In order to attract and retain high quality employees, the Council provides a highly competitive benefits package both in choice and coverage levels. Some highlights about our benefits are listed below:

• Guaranteed monthly retirement income through Minnesota State Retirement System pension fund
• Opportunity to save additional funds for retirement on a tax-deferred basis through a voluntary deferred compensation (457) plan
• Two or more medical plans from which to choose, with employer contribution towards premiums over 80%
• Dental insurance, life insurance and vision insurance

The following benefits are provided to all employees as part of working for the Council. You will have access to free:

• Well@Work clinic
• bus/rail pass valued at over $1200 per year
• parking at many job locations
• fitness centers at many job locations
• Employee Assistance Program
• extensive health and wellness programs and resources

You must create an Indeed account before continuing to the company website to apply