Business Intelligence Analyst, Research Analyst 4

State of Oregon; United States; Hybrid; USD 80,000 - 100,000; Full time

Job summary

The State of Oregon is seeking a Business Intelligence Analyst (Research Analyst 4) within the Department of Human Services. The role focuses on using Power BI to create dashboards and reports, supporting data-driven decision-making. Candidates should have strong analytical skills and experience in a similar field to contribute effectively to valuable services for the community and clients.

Benefits

Cost of Living Adjustments

Annual salary increases

Amazing benefits package

Potential eligibility for the Public Service Loan Forgiveness Program

Qualifications

• Minimum of three years of professional experience in business intelligence report development using Power BI.
• At least five years of professional experience in BI or data analytics.
• Hands-on experience in designing and implementing semantic models.

Responsibilities

• Design, develop, and maintain BI solutions for the Child Welfare program.
• Create and document Power BI reports and dashboards.
• Collaborate with teams to deliver timely insights using BI tools.

Skills

Power BI

SQL

DAX

M Query

Data Analysis

Education

Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or related field

Job description

Business Intelligence Analyst, Research Analyst 4

Initial Posting Date:

05/21/2025

Application Deadline:

06/11/2025

Agency:

Department of Human Services

Salary Range:

$6,123 - $9,409

Position Type:

Employee

Position Title:

Business Intelligence Analyst, Research Analyst 4

Job Description:

The Oregon Department of Human Services is proud to be an Equal Opportunity Employer. We are guided by our Equity North Star and our vision for a positive RiSE organizational culture that advances equity and diversity. We encourage applications from members of historically underrepresented racial/ethnic groups, women, individuals with disabilities, veterans, LGBTQIA2S+ community members, and others to help us achieve our vision of a diverse and inclusive community.

Opportunity Awaits! We're in search of leaders committed to promoting and fostering a diverse and qualified workforce where individuals feel welcome, appreciated, and valued for all they bring to the organization. The ideal candidate will be proficient in designing and developing reports, dashboards and visualizations, creating and managing semantic models using Power BI, and implementing row-level security, calculated measures, and KPIs. The role supports self-service BI by delivering well-documented, structured datasets, data dictionaries, requirements that business users can confidently explore and utilize. If this position aligns with your skills and career goals, consider taking on a key role in our team as the (Business Intelligence Analyst, Research Analyst 4, Office of Reporting, Research, Analytics & Implementation) for the Oregon Department of Human Services (ODHS).

About the Office of Reporting, Research, Analytics, and Implementation (ORRAI), The Oregon Department of Human Services and specifically ORRAI establishes organizational alignment and strategic focus around the use of comprehensive data-informed decision-making. Through an equity, diversity, inclusion, and access lens, ORRAI is responsible for providing employees, clients, legislators, other agencies and organizations, stakeholders, and the public with information to understand how data, research, and analytics informs decision-making about client services, agency recommendations for change, large-scaled systemic improvements, and improves outcomes for children and families.

Summary of Duties

As a Business Intelligence Developer/Analyst, you will:

• As a Power BI Report Developer supporting the Child Welfare (CW) program within the Oregon Department of Human Services (ODHS), you will be responsible for designing, developing, and maintaining business intelligence solutions that provide program leaders and stakeholders with critical, data-driven insights.
• You will work closely with database administrators, data engineers, and CW program analysts to deliver timely and actionable information using Power BI and other Microsoft BI tools. Your work will contribute directly to the CW program’s ability to monitor outcomes, improve services, and make informed decisions.
• Core responsibilities include developing semantic models, designing and maintaining datasets, creation of data dictionaries and report documentations for report users, creating visual diagrams of process-flow, creating dynamic reports and dashboards using Power BI, and migrating legacy reports into modern BI platforms. You will also use SQL, DAX, and M Query to integrate data from multiple sources and build user-friendly reporting solutions aligned with ORRAI data and visualization standards.
• This position requires excellent communication skills, a strong customer service mindset, and the ability to explain technical concepts clearly to non-technical audiences. You will also support team growth by mentoring others in Power BI and contributing to process improvement and reporting automation initiatives.
• Develop, identify, and analyze business requirements; ability to including integration with Power BI REST APIs for automation; leverage Business Intelligence tools and software to design and create advance reporting solutions and reporting that provides executive leadership and ODHS actionable data to make critical business decisions; maintain report and dashboards aligned with ORRAI standards; migrate legacy reports into new platform.
• Consults with ORRAI management about reporting needs, new advanced solutions, and conclusions.
• Assist with the development of business use cases, user stories or other agile software development requirements gathering, project management experience and documentation methodologies.
• The position is directly responsible for using reporting automation methods and tools to help streamline existing and new reports using agency approved BI tools.
• Mentor staff by sharing skills, experience, knowledge, and expertise on analytic tools and solutions such as Power BI. Apply Power Platform Model Driven Apps, Automations, and Customizations, including workflow, process automation, business rules, reports, dashboard, and system configuration.

Minimum Qualifications

• A bachelor’s degree in Computer Science, Information Systems, Data Analytics, Business Administration, or a related field, and at least three (3) years of professional experience in business intelligence report development using Power BI; OR
• At least five (5) years of professional experience in business intelligence, report development, or data analytics using Power BI and related Microsoft technologies. At least two (2) of those years must include hands-on experience designing and implementing semantic models (semantic layers) to support Power BI reporting and analytics.

Essential Attributes

We are looking for candidates with:

• Proficiency in M Query Language (Power Query) and Data Analysis Expressions (DAX) for building efficient and scalable Power BI datasets.
• Proven experience in developing business intelligence solutions using Microsoft Power BI, Power BI Report Builder, including designing interactive dashboards, reports, and visualizations.
• Expertise in semantic modeling with a strong understanding of dimensional data structures created by data engineers to support analytical and self-service reporting needs.
• Strong understanding of Power BI architecture, including integration with Power BI REST APIs for automation and report lifecycle management.
• Advanced SQL skills with a solid foundation in relational database concepts, data warehousing, and data integration techniques.
• In-depth knowledge of the Microsoft BI report development lifecycle, including requirements gathering, dataset preparation, report design, deployment, and maintenance.
• Demonstrated ability to provide excellent customer service and maintain a helpful, respectful, and solutions-focused attitude when working with internal staff and external stakeholders.
• Ability to design and develop sophisticated reports, connect multiple data sources, and build custom Power BI solutions.
• Ongoing involvement in BI community groups, forums, or professional development activities to stay updated on industry trends and emerging technologies and to continuously improve BI solutions.
• Proven dedication to fostering a diverse, equitable, inclusive, and accessible work environment.

Attention all candidates! A cover letter is required. Clearly describe how you meet the minimum qualifications and essential attributes in your application materials. Your application materials will determine if you are selected to move forward in the selection process. Please include detailed work and education history. Failure to submit the required cover letter will result in disqualification of your application.

• Please make sure your application materials, resume and job history, are clearly outlined as this information will be used to determine your starting salary range. Note: Your resume and cover letter may be uploaded in the Resume/CV field on the online application.
• The use of outside resources such as Artificial Intelligence software during applicant skill assessments, examinations, and/or interviews is prohibited unless otherwise stated by the hiring agency. Unauthorized use of outside resources during the hiring process will result in disqualification.

Working Conditions

• This position may spend extended time working with computers – up to eight hours a day for extended periods of time depending on project needs.
• Work effectively under STRESS, independently, and within a team.
• Some of the work is time-sensitive, and deadlines are observed.
• May require some travel (occasionally overnight) for meetings, research conferences, and /or consultations.
• Hybrid work will be considered in filling this position. The ability to report to a Salem office is required when training, business or operational needs are dependent on onsite activities.

Background Checks and Requirements

• If selected as a finalist, we will conduct a criminal history and background check. Adverse criminal history or background check may lead to disqualification. Additional background check information.
• The Oregon Department of Human Services does not offer visa sponsorship. Within three days of hire, you will be required to complete the US Department of Homeland Security’s I-9 form confirming authorization to work in the United States. ODHS will use E-Verify to confirm that you are authorized to work in the United States.

Benefits

• ODHS Employee Resource Group communities that promote shared learning.
• Cost of Living Adjustments.
• Annual salary increases (until you reach the top of the listed salary range).
• Amazing benefits package .
• Possible eligibility for the Public Service Loan Forgiveness Program .

Employment Preference

Veterans’ preference:

• Veterans’ preference information .
• How to submit your Veteran documents for preference . Please do not attach your Veterans’ preference documentation in the Resume/CV field of your application.

General Information

• This is a permanent, full-time position and is represented by the Service Employees International Union (SEIU).
• This recruitment may be used to fill future vacancies in the same classification.

Contact Information

We invite you to contact the recruiter for accommodation requests under the Americans with Disabilities Act (ADA), application questions or job-specific questions.

• The recruiter for this position is Nora Leyva Esquivel. If you contact the recruiter, please include the job requisition number: REQ-180997.
• Email: [e-mail]
• Phone (call or text): 503-269-4222

About the company

Oregon (/ˈɒrɡən/ ORR--gən) is a state in the Pacific Northwest region on the West Coast of the United States.

Notice

Talentify is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.

Talentify provides reasonable accommodations to qualified applicants with disabilities, including disabled veterans. Request assistance at [e-mail] or 407-000-0000.

Federal law requires every new hire to complete Form I-9 and present proof of identity and U.S. work eligibility.

An Automated Employment Decision Tool (AEDT) will score your job-related skills and responses. Bias-audit & data-use details: www.talentify.io/bias-audit-report . NYC applicants may request an alternative process or accommodation at [e-mail] or 407-000-0000.