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 Transitis one of the countrys largest transit systems employs more than 3000 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 reportsappsand 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
• Bachelors degree with four (4) years of experience
• Masters 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 youre 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.