- Professional
- Optionales Büro in Salem
Initial Posting Date:
10/23/2025Application Deadline:
10/30/2025Agency:
Department of Human ServicesSalary Range:
$6,123 - $9,409Position Type:
EmployeePosition Title:
Research Analyst 4Job 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 are seeking a Research Analyst 4 who can bridge the gap between application development and business intelligence. This unique role works closely with application developers, DBAs, and Child Welfare (CW) business analysts to understand new screens, modules, and business processes as they are introduced into the CW application. The ideal candidate will gather and analyze system-level details, create ERDs, process flows, and visual blueprints, and deliver clear documentation that enables our Data Warehouse team to build accurate star schemas and data models.
In addition, this position will design and develop semantic models, dashboards, and reports in Power BI and Paginated reports, while implementing best practices such as row-level security, calculated measures, and KPIs. The successful candidate will have a strong understanding of both the application development lifecycle and the BI/reporting lifecycle, ensuring that data warehouse models and reporting solutions evolve in step with program needs.
We are looking for someone who is open-minded, flexible, calm under pressure, and able to think outside the box when solving problems. The ideal candidate will stay current on new features and innovations in the Power BI ecosystem, bringing fresh ideas and approaches to improve our BI solutions. Strong communication and documentation skills are essential, as you will be responsible for translating technical details into materials that stakeholders, report developers, and data engineers can all use with confidence. You will also contribute to self-service BI by delivering well-structured datasets, data dictionaries, and process documentation, while mentoring peers and promoting modern BI solutions.
The successful candidate must be able to learn program processes quickly and translate them into accurate technical documentation and BI solutions.
If you are excited by the opportunity to serve as a technical liaison, build innovative BI solutions, and ensure accurate representation of business processes in the data warehouse, consider joining our team at the Office of Reporting, Research, Analytics & Implementation (ORRAI), Oregon Department of Human Services (ODHS).
Summary of Duties
As a Research Analyst 4, you will:
Collaborate with application developers, DBAs, and Child Welfare (CW) business analysts to gather system-level details, ERDs, and business requirements as new screens and modules are introduced into CW applications.
Work closely with ORRAI’s internal teams — DBAs, Data Warehouse Engineers (DBEs), and the reporting team — to ensure that application-level changes are accurately translated into data warehouse modules and reporting solutions.
Create clear documentation, ERD diagrams, process flows, and blueprints that accurately describe application structures and business processes, enabling the DW team to design and build reliable star schema models.
Design, develop, and maintain Power BI semantic models, datasets, dashboards, and reports, implementing features such as row-level security, calculated measures, and KPIs to meet business needs.
Translate CW business processes into data warehouse models and BI solutions, ensuring accurate representation of program operations and outcomes in analytical tools.
Stay current on Power BI updates and innovations, applying new features and best practices to continuously improve BI solutions and self-service reporting capabilities.
Demonstrate strong communication and documentation skills, explaining technical concepts clearly to non-technical stakeholders and producing materials that both business and technical teams can confidently use.
Develop business use cases, user stories, and other agile software development requirements, applying structured methodologies to ensure alignment between application changes, warehouse design, and BI reporting.
Act as a bridge between the application development lifecycle and the BI/reporting lifecycle, ensuring DW modules and reporting solutions remain synchronized with evolving application functionality.
Contribute to team growth by mentoring peers, sharing expertise in Power BI, data modeling, and documentation standards, and promoting process improvement and automation.
Model flexibility, open-mindedness, and creative problem-solving, staying calm under pressure, adapting to changing priorities, and thinking outside the box to deliver innovative BI solutions that support CW leadership in making data-driven decisions.
Minimum Qualifications
A Bachelor's Degree in any disciplines that included six-quarter units in statistics or quantitative analysis methods and procedures, and three years of experience in business intelligence report development using Power BI (or similar interactive data visualization software product) to independently gather, compile, and analyze data and prepare narrative or statistical reports. Two of the three years must have included coordinating complex research projects.
OR
Five years of experience in business intelligence, report development, or data analytics using Power BI (or similar interactive data visualization software product) and related Microsoft technologies to independently gather, compile, and analyze data and prepare narrative or statistical reports. Two of the five years must have included coordinating complex research projects.
Essential Attributes
We are looking for candidates with:
Proven experience developing business intelligence solutions using Microsoft Power BI and Power BI Report Builder, including designing interactive dashboards, reports, and visualizations that accurately reflect business processes.
Expertise in semantic modeling and dimensional data structures, with the ability to collaborate with Data Warehouse Engineers (DBEs) to ensure accurate representation of business processes in the data warehouse.
Strong understanding of Power BI architecture, report lifecycle management, and alignment with evolving application functionality.
In-depth knowledge of the Microsoft BI and application development lifecycles, including requirements gathering, dataset preparation, report design, deployment, and maintenance.
Demonstrated ability to collaborate across teams, including application developers, DBAs, DBEs, reporting teams, and business analysts, while maintaining a helpful, respectful, and solutions-focused attitude.
Strong communication and documentation skills, with the ability to create ERDs, process flows, visual blueprints, and business requirements that stakeholders and technical teams can confidently use.
Open-minded, flexible, and innovative problem-solving mindset, able to stay calm under pressure, think outside the box, and proactively apply new Power BI features and best practices to improve BI solutions.
Dedication to ongoing professional development, including involvement in BI community groups, forums, or learning activities to stay current on emerging technologies and trends.
Commitment to fostering a diverse, equitable, inclusive, and accessible work environment, supporting collaboration and growth for all team members.
Preferred Attributes:
This attribute is a plus but is not required.
Prior experience in Child Welfare or human services programs is helpful.
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 your cover letter will remove your application from further consideration.
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: Please upload your resume and cover letter 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.
The State of Oregon does not request or require your age, date of birth, attendance or graduation dates from an educational institution during the application process.
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.
Hybrid work will be considered for this position. This position may occasionally require travel, including overnight stays, to attend meetings, research conferences, or consultations. You may also be asked to report to the office in Salem on short notice. Please note that all travel-related expenses including lodging, airfare, and mileage—will be the responsibility of the successful candidate.
You will be expected to report to the office in Salem on a quarterly basis and as needed to collaborate with business partners.
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.
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 is available here.
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:
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-189606.
Email: [email protected].
Phone (call or text): 503-2694222.
