Technical Business Analyst-Operations & Policy Analyst 2 SR27

U.S. Department of Veterans Affairs; Salem (OR); Hybrid; USD 60,000 - 80,000; Full time

Job summary

The Oregon State Hospital is seeking a Technical Business Analyst to enhance its data capabilities. This role involves translating data needs into technical specifications, collaborating with various teams, and supporting a data-driven environment. Candidates should have a strong background in SQL and experience in data visualization and analysis. This is a hybrid position based in Salem, Oregon, with a focus on improving healthcare data management.

Benefits

Excellent medical, vision, and dental benefits

Optional life insurance and disability

11 paid holidays and vacation accrual

Training opportunities for career growth

Qualifications

• Two years of professional-level evaluative, analytical and planning work.
• Experience working with technical and non-technical partners.

Responsibilities

• Translate data needs into table definitions for the data mart.
• Collaborate with hospital staff to determine reporting requirements.
• Assist with design and maintenance of the OSH data warehouse.

Skills

SQL

Data visualization

Technical requirements interpretation

Data gathering

Education

Bachelor's Degree in Business or Public Administration

Degree in Behavioral or Social Sciences

Degree in Finance

Degree in Political Science

Job description

Initial Posting Date:

05/13/2025

Application Deadline:

05/23/2025

Agency:

Oregon Health Authority

Salary Range:

$5325.00-$8148.00

Position Type:

Employee

Position Title:

Technical Business Analyst-Operations & Policy Analyst 2 SR27

Job Description:

Opportunity Awaits, Apply Today! - Operations & Policy Analyst 2 SR27 - Oregon State Hospital

Oregon State Hospital, a Joint Commission and CMS certified public psychiatric hospital, provides psychiatric hospital services and patient treatment services to persons committed by the Oregon courts as part of the state mental health system.

The Oregon State Hospital (OSH) is recruiting for a Technical Business Analyst role. This position will play a critical role in moving OSH forward in its data capabilities, allowing the organization to become nimbler in providing data to decision-makers at all levels of the organization.

The Technical Business Analyst works with the hospital’s data mart team and plays a critical role in translating the organization’s data needs into table definitions and designs for the data mart. This role also has responsibility for performing tests to confirm implemented tables perform as required and identify corrections to designs to meet data needs.

The successful candidate has demonstrable experience working with technical and non-technical partners, gathering technical requirements, working with subject matter experts, translating business needs into technical specifications, SQL coding, and working with healthcare data.

The primary purpose of this position is to assist with planning, analyzing and managing the process for the storage, retrieval, and transformation of data from the hospital’s electronic health record and other disparate data bases into a functional data warehouse, DataMart. This position will work as a liaison and consultant between the hospital and data warehousing team for the development, adoption and use of a data warehouse, as well as other data system projects. This position will work with Data & Analysis staff to develop the infrastructure to produce a business intelligence system for performance metrics, benchmarking, data mining and statistical analysis to allow the hospital to continue to be a data driven facility. As such, this position will support strategic reporting, LEAN management, research topics, and hospital administration with data transformations to allow data visualizations and distribution of business knowledge.

Working in conjunction with hospital staff, project team, information system staff, and other agencies to analyze, plan, and document system implementation activities such as:

• Functional Requirements
• Use Cases Implementation plans
• Data conversion plans
• Testing plans Maintenance and support plans

Collaborate and interview with various hospital staff on current systems environment to determine requirements and specifications for reporting needs throughout the hospital, including medical, clinical, financial, security and social services data.

Assist with the design, development, and maintenance of the OSH data warehouse, and other data delivery and/or data transformation tools. This effort will include:

• Designing mock-ups
• Conducting implementation and testing
• Developing and completing data audits and validation for hospital data
• Documenting audit gaps and issues
• Elevate to project team
• Suggest mitigation actions to address risks
• Assisting in documenting and maintaining a data source catalog
• Review data records for processing errors; evaluate how errors occurred and recommend system improvements to prevent future errors
• Adopt and implement systematic approaches to data system improvement work, including LEAN management and best practices

For a full review of the position description, please click here.

If this opportunity aligns with your strengths, background, and commitment to fostering inclusivity, we encourage you to apply! At the Oregon Health Authority (OHA), we value diversity and encourage applicants from all backgrounds and experiences to help us build a stronger, more equitable future for all.

What We Are Looking For

A Bachelor's Degree in Business or Public Administration, Behavioral or Social Sciences, Finance, Political Science or any degree demonstrating the capacity for the knowledge and skills; and two years professional-level evaluative, analytical and planning work.
OR;
Any combination of experience and education equivalent to five years of experience that typically supports the knowledge and skills for the classification.

Desired Attributes: The following are skills and lived experiences that we have identified as key to success in this role at OSH. These are the attributes we are looking for in our top candidate. If you possess any of these, please let us know in your application.

• Strong SQL coding capabilities
• Experience gathering and interpreting data
• Experience interpreting technical requirements
• Data visualization skills
• Experience communicating technical data to non-technical audience

Special Requirements:To be hired, you must have a criminal records and driving records check that meets OHA/OSH criteria at the time of hire, and throughout employment.

Application Guidance

How to Apply: Submission Requirements - At the time of application, ensure the work history in your applicant profile is up to date and attach a current copy of your resume and cover letter, answer supplemental questions at the end of the application process.

External Candidates : Visit the State of Oregon job opportunities webpage to submit your application. Be sure to follow all application submission requirements.

• Internal Candidates: Current State of Oregon employees must apply through their employee Workday login. Be sure to follow all application submission requirements.

After You Apply:

• Before the job announcement closes, log in to your Workday account to check for pending tasks under “My Applications” and complete them.
• Remember to check your email (including your junk folder) and Workday inbox for updates on your application.
• We value our veterans! To ensure the security of your information, kindly follow the instructions for how to submit your Veteran documents for preference found here. Please do not attach your Veterans’ preference documentation in the Resume/CV field of your application.

Reminders:

• Your candidate profile and application materials are great opportunities to showcase your interest in the position and highlight your skills and experience. Submissions will be screened for consistency and communication skills, including attention to detail, spelling, and grammar. For more tips and guidance, check out What you need to know to get the job !
• This announcement is for 1 vacancy, time type: full-time, permanent, SEIU represented, Operations & Policy Analyst 2 SR27 position based in Salem, Oregon.
• This is a Hybrid position. Please check SECTION 4. WORKING CONDITIONS, of the position description linked above to review more details regarding the details surrounding the working conditions.
• Please download and save a copy of this job announcement and linked position description, as it is not available after the application deadline. For questions about the announcement, or if you require an alternate format to apply, please contact the Sr. Recruiter, Melissa Perez at: [e-mail] | (503)-209-7058.

Benefits of Joining Our Team

We offer a workplace that balances productivity with enjoyment;promote an atmosphere of mutual respect, dedication, and enthusiasm. You will collaborate with a team of bright individuals to work with and learn from. If you're driven by the passion to do something meaningful that changes lives, the Oregon Health Authorityis the place for you. We also offer a competitive benefits package including:

• Excellent medical, vision, and dental benefits package for the employee and qualified family members with a very low monthly out-of-pocket cost.
• Optional life insurance, short-term disability, long-term disability, deferred compensation savings program, and flexible spending accounts for health care and childcare expenses.
• Employee benefits include 11 paid holidays, 3 personal business days, 8 hours of monthly sick leave, and vacation accrual starting at 8 hours per month.
• Possible eligibility for the Public Service Loan Forgiveness Program .
• Membership in the Public Employees Retirement System (PERS)/Oregon Public Service Retirement Plan (OPSRP).
• Training opportunities that will help grow your career with the State of Oregon.

Additional Details

• The information in your application will be used to complete an Equal Pay Analysis to determine salary placement upon hire. Visit the Department of Administrative Services Equal Pay Analysis Webpage for more information.
• The salary listed is the non-PERS qualifying salary range. If the successful candidate is PERS qualifying, the salary range will reflect the additional 6.95%. Review the Classification and Compensation page for more details on the classification.
• Agency does not offer visa sponsorship. Within three days of hire, applicants will be required to complete I-9 documentation and confirm authorization to work in the United States. OHA will use E-Verify to confirm that you are authorized to work in the United States. If your employment authorization and documentation is contingent on sponsorship now or in the future, you will not meet Agency employment eligibility standards.

Helpful Links & Resources

How to Set Job Alerts | Workday Applicant FAQ | Oregon Health Authority | Facebook | Instagram | LinkedIn | Veterans Resources

The Oregon Health Authority is an affirmative action and equal opportunity employer, committed to fair employment practices and pay equity for all employees. We do not discriminate based on any protected class—including race, sex, veteran status, disability, age, color, religion, national origin, marital status, or sexual orientation—and we do not screen applicants based on current or past compensation. Salary is determined through a fair review of your education, experience, and training as it relates to the position.

OHA is an anti-racist organization working to eliminate health inequities and dismantle structural barriers that impact underserved communities. Join us in advancing our Strategic Plan and building a more equitable Oregon.