Power BI Developer (Information Systems Specialist 6)
Initial Posting Date:
11/16/2026Application Deadline:
11/30/2026Agency:
Department of JusticeSalary Range:
$6,182 - $9,361Position Type:
EmployeePosition Title:
Power BI Developer (Information Systems Specialist 6)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. Apply today!
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.
- Transform and Validate Data: 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.
- Design Accessible Analytics Solutions: 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.
- Support Power BI Operations: 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.
- Implement Security and Governance Standards: 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.
- Perform Testing and Documentation: 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.
- Support Deployments and Lifecycle Management: 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.
- Collaborate Across the Organization: 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.
- Continuous Improvement and Professional Development: 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) Years
- Bachelor's Degree = Four (4) Years
- Master'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.
- Click "Apply" and complete the online application and all supplemental questions.
- Attach your resume.
- Attach your cover letter identifying your attributes that meet desired and requested skills.
CURRENT STATE EMPLOYEES: Login to Workday using your state-issued login and apply via the Jobs Hub Worklet located on your home page. Using a private account disrupts the hiring process for all internal candidates. Prior to clicking "Apply", update your employee profile to reflect your Education, Skills, and Job History (including your current job).
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.
For additional information regarding working for the Department of Justice and application assistance, click HERE.
Phone: (503) 947-4328
Fax: (503) 373-0367
Required Skills
Required Languages
🇬🇧 English