Business Intelligence Developer
Role details
Job location
Tech stack
Job description
In this dynamic role, you will help build the BI platform, governed datasets, and reporting capabilities that support data-driven work across Metro, contributing significantly to Metro's digital and data evolution. Be part of a team where innovation meets public service, and your work directly enhances the daily lives of the staff and our community. Your expertise in business intelligence and data visualization will help shape how IT provides BI infrastructure and platform for our departmental analytics and data partners.
The Team:
The Data Services group is on a mission to enhance the reliability and modernization of Metro's data infrastructure for both Metro employees and the community, contributing to enhancing service delivery with the help of technology, supporting everything from day-to-day database operations to enterprise analytics, data migration, and cloud platform adoption. The Data Services group is all about making sure Metro's data is reliable, accessible, and ready for what comes next.
As the Business Intelligence Developer you will:
- Refine the Shared Analytics Platform: Enhance the enterprise BI environment - so departments across Metro have a reliable, and usable foundation for analytics work.
- Own Reporting for the ERP Migration: Lead the reporting side of Metro's PeopleSoft-to-Workday transition-inventorying what exists today, running requirements intake with functional teams, and building everything beyond what our implementation partner delivers.
- Bridge Two Platforms: Connect Workday's native reporting environment with Power BI and Microsoft Fabric to create a unified analytics experience. Develop working proficiency in Workday's reporting tools while building the pipelines and semantic models that bring Workday data into the broader analytics platform.
- Support and Enable: Help analysts across Metro do better work with data-through shared standards, documentation, mentoring, and self-service capabilities that make the platform accessible. You're a resource and a partner, not a gatekeeper.
- Accelerate with AI: Use AI tools throughout your workflow-for learning unfamiliar systems, generating DAX, modeling data, writing documentation-and help the team establish AI-augmented analytics as the norm., This position is designated as "hybrid telework." You will be required to work onsite and at times have the option to work away from your assigned work location. The specific schedule and balance of onsite and telework will be discussed with the hiring manager at the time of offer. Employees must reside in Oregon or Washington to work at Metro. Please note, the designation of hybrid telework may be subject to change at a future time., + A cover letter telling us about a time you built something from scratch - a reporting process, a BI practice, a governance framework, or an analytics capability that didn't exist before. What was the situation, what did you build, and what made it successful (or what would you do differently)?
The selection process: We expect to evaluate candidates for this recruitment as follows. The selection process is subject to change.
- Initial review of minimum qualifications
- In-depth evaluation of application materials to identify the most qualified candidates
- Consideration of top candidates/interviews
- Testing/assessments
- Reference check
- Background records check for finalist candidate
Requirements
-
Proven proficiency in Power BI or an equivalent modern BI platform-data modeling, DAX, Power Query/M, semantic layer construction, and report design-with enough depth to build a well-structured dataset from scratch and write non-trivial measures.
-
Track record translating business reporting needs into technical specifications-sitting with non-technical stakeholders, understanding what they actually need, and delivering analytics that are both sound and usable.
-
SQL proficiency sufficient to investigate data issues independently, validate reporting accuracy, and collaborate effectively with the Database Engineer on pipeline and data quality work.
-
Demonstrated experience using AI tools (Copilot in Power BI, Claude, and/or similar) to accelerate analytics work-not as a novelty, but as a core part of how you operate.
-
A platform thinker who builds for others to succeed-you care about governed datasets, shared standards, and self-service tools as much as your own dashboards, and you see your role as strengthening the whole analytics ecosystem, not claiming territory.
-
Collaborative by default-you'd rather build something with people than for them, you respect what's already been built across the organization, and you earn trust by listening before prescribing.
-
A modernizer with patience who sees every reporting request as an opportunity to establish better patterns, but understands that meaningful change in a complex organization happens through consistent, incremental progress.
-
An AI-augmented practitioner who uses AI tools as a force multiplier for their analytics work-and knows enough to critically evaluate whether AI-generated output is actually correct., + 5-8 years of related professional experience, and
-
Bachelor's Degree, or
-
Any combination of experience and education that provides the applicant with the desired skills, knowledge, and ability required to perform the job
-
Ability to obtain and maintain an advanced professional certification., You do not need to have the following preferred qualifications/transferable skills to qualify. However, keep in mind we may consider them when identifying the most qualified candidates. Your transferable skills are any skills you have gained through education, work experience, including the military, or life experience that are relevant for this position.
-
Experience with Workday reporting tools (Report Writer, Calculated Fields, Prism Analytics) or other enterprise HRIS/ERP reporting platforms.
-
Experience with cloud-based analytics platforms and services, particularly Microsoft Fabric, Azure Data Factory, or equivalent.
-
Experience using AI-assisted analytics tools in professional or project work to accelerate delivery and expand capability.
-
Experience building shared analytics platforms or supporting federated BI models across multiple teams or departments.
-
Familiarity with analytics engineering concepts such as dbt, semantic layers, or metrics layers., + Some high school (or less)
-
High school diploma or GED
-
Some college
-
Associate degree
-
Bachelor's degree
-
Master's degree
-
Doctorate degree
02
How many years of professional experience do you have related to this position?, Select your years of experience using AI-assisted analytics tools in professional or project work to accelerate delivery and expand capability., Describe your familiarity with analytics engineering concepts such as dbt, semantic layers or metrics layers.
Benefits & conditions
- Standard office environment. May need to respond to emergencies outside of normal work hours on rare occasions., The full-salary range for this position is step 1: $95,992.34 to step 7: $128,601.98. However, unless a candidate's qualifications justify, based on the Oregon Pay Equity Act requirements and Metro's internal equity review process, the appointment will likely be made between step 1: $95,992.34 to the equity range step 4: $111,111.94., Led by an elected council, this unique government gives all residents of greater Portland a voice in shaping the future and provides parks, venues, services, and tools at a regional scale. We find solutions for our area's garbage and recycling that protect clean air and water; help plan land use and development to provide jobs and safe transportation; manage local venues that provide a connection to arts and culture and help keep the economy growing; protect 17,000 acres of parks and natural areas, and run the Oregon Zoo, to keep nature close to home.
As part of the Metro family, you play a vital role in serving the people of the greater Portland region.
Family members, including eligible spouses, domestic partners, and children, are covered under most of our benefits programs. Benefits vary depending on position and full-time, part-time, and variable hour status.
This is a budgeted, regular status position with a full-time schedule. The position is eligible for these benefits:
- Medical, dental and vision health insurance
- Paid sick leave
- Paid vacation, holiday, and other leave
- Paid parental leave
- Full contribution to Oregon PERS retirement
- No-cost TriMet Hop Pass
- Employee Assistance Program
- Training opportunities
- Flexible schedules depending on position and department
- Hybrid/Telework living in Oregon /Washington depending on position and department
Metro also offers a variety of perks for all employees, including free admission to the Oregon Zoo (including ZooLights!), Oxbow and Blue Lake Regional Parks, membership discount at Lloyd Athletic Club, credit union eligibility and more. Employees also receive access to financial wellness and legal consultation services, as well as first-time home buying and ownership counseling.
