Power BI Developer (Information Systems Specialist 6)

State of Oregon•Salem, OR
•$74,184 - $112,332•Hybrid

About The Position

The Oregon Department of Justice, Information Services Section, is seeking an experienced Power BI Developer to support its Business Intelligence and Analytics program. The position designs, develops, enhances, and supports enterprise reporting and analytics solutions that help business units make informed decisions using secure, reliable, and accessible data products. Core work includes developing and maintaining Power BI reports, dashboards, semantic models, and related data solutions using Microsoft Power BI, Power Query, DAX, SQL, and approved data sources. The developer works with business stakeholders, analysts, technical teams, and leadership to deliver trusted analytics, improve operational insight, reduce manual reporting, and support the Department’s mission. The position may require on-call or after-hours support for the Origin batch process and the ability to work across functional coding areas as needed. It also mentors junior team members. The role is hybrid, combining remote and in-office work, with attendance at the Salem office once a month for scheduled team meetings. The finalist must reside in Oregon by the time of appointment.

Requirements

  • Five years of experience in information systems. Education may count toward experience if the degree is in Computer Science, Information Technology, or a related field, or if a two-year accredited vocational training program in information technology or a related field was completed.
  • At least three years of comprehensive experience designing, developing, and supporting Power BI solutions.
  • Proficiency with Power BI Desktop, Power BI Service, and Power BI Report Builder, including interactive and paginated reports, dashboards, semantic modeling, workspace content management, app deployment, data refresh, and security.
  • Proficiency with Power Query and DAX, including data transformation, measure development, evaluation context, time intelligence, and troubleshooting.
  • Knowledge of dimensional modeling, star schemas, relationships, storage modes, data granularity, and model-performance optimization.
  • Ability to create accessible, audience-appropriate dashboards and reports that communicate metrics accurately and clearly.
  • Experience validating data, reconciling results to authoritative sources, documenting metric definitions, and maintaining source-to-report lineage.
  • Knowledge of Power BI security and governance, including row-level security, least-privilege sharing, sensitivity, workspace roles, gateways, and controlled deployment.
  • Ability to write and interpret SQL or equivalent source queries to analyze, retrieve, validate, and troubleshoot reporting data.
  • Strong communication, facilitation, customer-service, analytical problem-solving, documentation, and workload-management skills.
  • Must reside in Oregon by the time of appointment.
  • Finalists must pass a comprehensive employment reference check and fingerprint-based criminal background check. A driver history check may also be included for positions requiring state vehicle driving privileges.
  • A resume and cover letter are required for consideration.

Nice To Haves

  • Ability to communicate and collaborate effectively with program staff, business analysts, data owners, data engineers, database administrators, security personnel, senior developers, and enterprise architecture teams.
  • Ability to define metrics with stakeholders, explain data and technical limitations, present analytical findings clearly, document business logic and data lineage, contribute to peer reviews, and help users interpret reports appropriately.
  • Ability to manage multiple assignments, adapt to changing priorities, and work independently within defined patterns and standards.

Responsibilities

  • Design, build, enhance, and maintain Power BI reports, dashboards, and reusable semantic models in accordance with business requirements and DOJ standards.
  • Develop Power Query transformations, DAX measures, calculated columns, relationships, and hierarchies.
  • Acquire, cleanse, transform, and validate data from approved sources; reconcile reporting outputs to authoritative systems and investigate data anomalies.
  • Create accessible and user-friendly visualizations, reports, and dashboards with navigation, filtering, drill-through functionality, mobile layouts, and clear presentation of key metrics.
  • Provide Tier-2 and Tier-3 support for reports, semantic models, dataflows, Power BI applications, refresh schedules, and workspace content.
  • Diagnose and resolve performance, refresh, gateway, permission, and data quality issues.
  • Configure and maintain row-level security, object-level security, sharing permissions, sensitivity labels, and workspace governance practices.
  • Develop and execute unit, integration, regression, accessibility, and user acceptance testing.
  • Document data lineage, business logic, calculations, security configurations, deployment procedures, and operational support processes.
  • Coordinate report and model promotions across development, testing, and production environments using approved deployment and version control practices.
  • Maintain refresh schedules, gateway connections, and related configuration settings.
  • Collaborate with program staff, business analysts, data engineers, database administrators, security personnel, and executive stakeholders to define reporting requirements and metrics and deliver analytics solutions.
  • Participate in peer reviews, technical discussions, demonstrations, and knowledge-sharing activities; stay current with Power BI, Microsoft Fabric capabilities adopted by DOJ, data modeling, analytics engineering, and visualization practices.
  • Mentor junior team members and perform other duties as assigned.

Benefits

  • Vacation leave
  • Sick leave
  • 11 paid holidays a year and special days off
  • Medical, dental, and vision benefits
  • Pension and retirement programs
  • Representation and support by the Service Employees International Union (SEIU)
  • Advancement opportunities within DOJ and other State agencies
  • Opportunity to expand technical and professional skills
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service