BI Developer
| Estimated Pay info | Based on similar jobs in your market$53 per hour |
|---|---|
| Hours | Full-time, Part-time |
| Location | Saint Paul, Minnesota |
About this job
This position is eligible for a hybrid (both remote and onsite) telework arrangement. Candidate's permanent residence must be in Minnesota or Wisconsin.
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.
Metropolitan Council's Regional Administration division provides enterprise services that are aligned with the Council's vision. We strive to be a trusted strategic partner by delivering integrated, collaborative, efficient, and responsive services.
Information Services is the central IT department supporting all divisions of the Metropolitan Council. Our 140 team members provide technology, practices, and innovative solutions that enable the Council's core services.
The Metropolitan Council is looking for a Business Intelligence (BI) Developer, where your creativity and technical skills will drive the transformation of the Council's data platform and Enterprise BI capabilities for our staff and our community.
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. This role Leverages structured and unstructured data to design and maintain BI data models, datasets, dashboards, reports, and visualizations. The role executes small to mid-size projects, contributes to data management strategies, and adheres to data governance and security requirements.
This posting will create a six-month eligibility list for current and future openings. What you would do in this jobBI Engineering
Leverage reporting databases to design and maintain BI data models, datasets, dashboards, reports, and visualizations.
Translate business needs and KPIs into reporting requirements and develop solutions that support data-driven decision-making.
Monitor and tune the performance and usability of reports, dashboards, and visualizations, and troubleshoot related issues.
Apply data governance practices, including data classifications, compliance with applicable laws, and adherence to change management processes.
Support business units with self-service reporting, provide consulting on BI tools and standards, and innovate using emerging technologies.
Write SQL queries, scripts, and automation to support data processing and ensure data quality, integrity, and accessibility.
Any of the following combinations of completed education (in Computer Science, Information Systems, Statistics, Mathematics, Economics, the Sciences, the Social Sciences, or related field) and experience working with database technologies, programming languages, and concepts:
Mathematics, Economics, the Sciences, the Social Sciences, or related field) and experience working with database technologies, programming languages, and concepts.
High school diploma/GED with seven (7) years of experience
Associate degree with five (5) years of experience
Bachelor's degree with three (3) 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
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
Skill in developing reporting and BI data models, visualizations, standards, and accessibility methods.
Knowledge of reporting database architectures, including data stores, data lakes, data warehouses, and datamarts.
Skill in creating and administering analytical tools, subscriptions, and self-service BI solutions.
Ability to establish data and reporting best practices and consult with technology and business units.
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.
Union/Grade: AFSCME/Grade H
FLSA Status: Exempt
Safety Sensitive: No
Work Environment:
Work is primarily performed in a standard office setting.
- We review your minimum qualifications.
- We rate your education and experience.
- We conduct a structured panel interview.
- We conduct a selection interview.
Once you have successfully completed the steps above, then:
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 .