Power BI Developer (Information Systems Specialist 6)

Department of Justice

Salem (OR)

Hybrid

USD 69,000 - 104,000

Full time

3 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Vacation and sick leave
11 paid holidays a year
Excellent medical, dental, and vision

Job summary

Oregon Department of Justice is seeking an experienced Power BI Developer (Information Systems Specialist 6) to design, develop, and support enterprise BI reporting and analytics. You will work with stakeholders to deliver trusted analytics, secure data products, and scalable dashboards using Power BI, Power Query, DAX, and SQL.

The role is hybrid with remote work, requiring occasional in-office presence in Salem. Applicants must reside in Oregon by appointment and pass background checks.

Qualifications

  • Five years of information systems experience.
  • Experience designing and supporting Power BI solutions.
  • Proficiency with Power BI Desktop, Service, and Report Builder.
  • Proficiency with Power Query and DAX.
  • Ability to pass background and fingerprint checks.

Responsibilities

  • Develop Power BI reports, dashboards, and semantic models.
  • Create Power Query transformations and DAX measures.
  • Validate data against authoritative sources and ensure data quality.
  • Configure RLS/OLS and security for Power BI workspaces.
  • Provide Tier-2/3 support for reports and data models.
  • Coordinate deployments across environments and maintain documentation.

Skills

Power BI
SQL
DAX
Power Query
Data modeling

Education

Bachelor’s Degree
Master’s Degree

Tools

Power BI Desktop
Power BI Service
Power BI Report Builder
SQL
Power Query
DAX

Job description

Power BI Developer (Information Systems Specialist 6)

Initial Posting Date: 11/16/2026

Application Deadline: 11/30/2026

Agency: Department of Justice

Salary Range: $6,182 - $9,361

Position Type: Employee Position

Job Description

The Oregon Department of Justice (DOJ), Information Services Section is seeking an experienced Power BI Developer (Information Systems Specialist 6) to join our team. This role supports the Department's Business Intelligence and Analytics program by designing, developing, enhancing, and supporting enterprise reporting and analytics solutions that empower business units to make informed decisions through secure, reliable, and accessible data products. The primary responsibility of this position is to develop and maintain Power BI reports, dashboards, semantic models, and related data solutions using Microsoft Power BI, Power Query, DAX, SQL, and approved data sources. This position works closely with business stakeholders, analysts, technical teams, and leadership to deliver trusted analytics solutions that improve operational insight, reduce manual reporting efforts, and support the Department's mission. This position may require on-call or after-hours support for the Origin batch process, as well as the ability to adapt across all functional coding areas when needed. As a mentor to junior team members, you will help us to develop and build our diverse work family.

This role is a hybrid of remote work and in-office work. Remote work is embraced to the fullest extent possible without interfering with business. There is an expectation of reporting to the Salem office once a month for scheduled team meetings. The finalist must reside in the state of Oregon by the time of appointment.

Primary Job Duties (In Part)
  • Develop Power BI Reports and Semantic Models: Design, build, enhance, and maintain Power BI reports, dashboards, and reusable semantic models that meet business requirements and DOJ standards.
  • Develop Power Query transformations, DAX measures, calculated columns, relationships, and hierarchies to deliver accurate and meaningful analytics.
  • Acquire, cleanse, transform, and validate data from approved sources. Reconcile reporting outputs with authoritative systems, investigate data anomalies, and ensure the integrity, accuracy, and consistency of business intelligence products.
  • Create effective and user-friendly visualizations, dashboards, and reports that include accessible navigation, filtering, drill-through functionality, mobile layouts, and clear presentation of key business 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 (RLS), object-level security (OLS), sharing permissions, sensitivity labels, and workspace governance practices in accordance with DOJ security and compliance requirements.
  • Develop and execute unit, integration, regression, accessibility, and user acceptance testing. Maintain documentation related to data lineage, business logic, calculations, security configurations, deployment procedures, and operational support processes.
  • Coordinate report and model promotions through development, testing, and production environments using approved deployment and version control practices. Maintain refresh schedules, gateway connections, and related configuration settings.
  • Work with program staff, business analysts, data engineers, database administrators, security personnel, and executive stakeholders to define reporting requirements, develop meaningful metrics, and deliver analytics solutions that support agency objectives.
  • Participate in peer reviews, technical discussions, demonstrations, and knowledge-sharing activities. Stay current with evolving Power BI technologies, Microsoft Fabric capabilities adopted by DOJ, data modeling, analytics engineering, and visualization best practices.
  • Other duties as assigned.
Required Experience

Research suggests that women and people of color are less likely to apply unless they are confident they meet 100% of the listed qualifications. We strongly encourage all interested individuals to apply, and allow us to evaluate the knowledge, skills, and abilities that you demonstrate, using an intentional equity lens.

Five (5) years of experience in information systems. Education will be counted as experience if degree is in Computer Science, Information Technology, or related field, or if a two (2) year accredited vocational training program was completed in information technology or related field.Associate’s Degree (or 2-year vocational training) = Two (2) YearsBachelor’s Degree = Four (4) YearsMaster’s Degree = Six (6) Years

AND 3+ years of comprehensive experience in designing, developing, and supporting Power BI solutions. Finalists must pass a comprehensive employment reference check and fingerprint-based criminal background check. A driver history check will be included for positions requiring state vehicle driving privileges. Adverse findings will be evaluated to determine eligibility for the position.

Proficiency with Power BI Desktop, Power BI Service, and Power BI Report Builder, including interactive and paginated report development, 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 sufficient to analyze, retrieve, validate, and troubleshoot reporting data.

Strong communication, facilitation, customer-service, analytical problem-solving, documentation, and workload-management skills.

Both a resume and a cover letter are required to be considered for this recruitment.

Our Ideal Candidate Will Have

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

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

The ability to manage multiple assignments, be adapt to changing priorities, and work independently within defined patterns and standards.

What’s In It For You
  • Permanent, full-time, and stable employment without the need to bounce between contract assignments.
  • Equal pay in accordance with Oregon Pay Equity Laws; we will ensure you are paid well and equitable to your peers.
  • Work where individual contribution matters and is recognized, where creativity and accomplishment are rewarded.
  • Vacation, sick leave, 11 paid holidays a year, and special days off.
  • Excellent medical, dental, and vision benefits.
  • Pension and retirement programs.
  • Representation and support by the Service Employees International Union (SEIU).
  • Advancement opportunity within DOJ and other State agencies.
  • Opportunity to expand your technical and professional skills.
  • For more information about our benefits, you can learn here.
Application Process

The use of AI is prohibited in the application process. This includes any selection related processes through the recruitment process including assessments and interviews. If there is known use of AI, you will be disqualified.

Equal Opportunity Employer Statement

The Department of Justice is an equal opportunity employer, does not discriminate based on race, color, national origin, ethnicity, veteran status, gender, sexual orientation, religion, age, or disability, and is committed to workplace diversity.

Contact Information

Oregon Department of Justice
1162 Court St NE
Salem OR, 97301
DOJ.recruitment@doj.oregon.gov
Phone: (503) 947-4328
Fax: (503) 373-0367

Status of the Organization

Oregon state government is a large organization by nearly any standard. With over 40,000 employees working all over the state, in small communities and large, we are proving that government can be innovative. We work as a team, challenging ourselves to be better, faster and more efficient with taxpayer dollars. After all, when every day we are responsible for caring for the needs of a diverse population and thriving business community, we simply must have the best and brightest workforce. If you take responsibility for your actions, are passionate about helping others succeed, and have a reputation for excellence and honesty, why not make Oregon state government your next career move? Joining our team means you open the door to many possibilities. From entry level to executive, outdoor work to policy setting, we have a role for nearly every calling, expertise and background. If you’re looking at us from across the country (or beyond!), know that Oregon is one of the most beautiful places on earth. Made up of seven diverse regions, Oregon has the ocean, mountains, valleys, high desert, cities, small towns, and almost everything in between. Oregon 'flies with her own wings.'

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Software Developer (Information Systems Specialist 6)
Software Developer (Information Systems Specialist 6)

Department of Justice • Salem (VA), Beardsley (MN)

Hybrid
USD 69,000 - 104,000
Vacation and sick leave
11 paid holidays a year
Excellent medical, dental, and vision
Investigator 3 - Charitable Activities Section
Investigator 3 - Charitable Activities Section

Department of Justice • Portland (ME)

On-site
USD 58,000 - 89,000
Paid holidays
Vacation and sick leave
Pension plan
+2
Middleware Administrator (Information Systems Specialist 7)
Middleware Administrator (Information Systems Specialist 7)

Department of Justice • Salem (VA)

Hybrid
USD 76,000 - 115,000
Medical, dental, vision
Pension and retirement
Paid holidays
+2
Software Developer (Information Systems Specialist 6)
Software Developer (Information Systems Specialist 6)

Oregoncitybusiness • Salem (OR)

Hybrid
USD 69,000 - 104,000
Pension plan
11 paid holidays
Health benefits
+2
Office Specialist 2, Behavioral Health Office Support (Portland)
Office Specialist 2, Behavioral Health Office Support (Portland)

Department of Corrections • United States

On-site
USD 47,000 - 61,000
Court Operations Associate (Cashier/Information Clerk)
Court Operations Associate (Cashier/Information Clerk)

Judicial Department • Bend (OR)

On-site
USD 42,000 - 62,000
Medical insurance premium coverage
Paid holidays and leave
Bilingual skills allowance
Programs and Services Coordinator, Program Analyst 1 (Salem)
Programs and Services Coordinator, Program Analyst 1 (Salem)

Department of Corrections • Salem (VA), Headquarters (WA)

On-site
USD 61,000 - 88,000
*Investigator 3 - Civil Enforcement Division (Portland)
*Investigator 3 - Civil Enforcement Division (Portland)

Department of Justice • United States

Hybrid
USD 70,000 - 95,000
11 paid holidays
Vacation
Sick leave
+2
Institution Records Specialist, Administrative Specialist 1(Salem)
Institution Records Specialist, Administrative Specialist 1(Salem)

Department of Corrections • Salem (OR)

On-site
USD 51,000 - 67,000
Family health insurance
Vacation and holidays
Paid time off for military
Financial Auditor (Governmental Auditor 2)
Financial Auditor (Governmental Auditor 2)

Department of Human Services • Salem (VA)

Hybrid
USD 58,000 - 89,000
ODHS Employee Resource Group
Cost of Living Adjustments
Annual salary increases
+2