Oregon Health Authority
Data Warehouse Systems Analyst (Information Systems Specialist 6) 100 % Remote W
Oregon Health Authority, Salem, Oregon, us, 97308
Overview
Data Warehouse Systems Analyst (Information Systems Specialist 6) 100 % Remote Work Join to apply for the Data Warehouse Systems Analyst (Information Systems Specialist 6) 100 % Remote Work role at Oregon Health Authority. Position title: Data Warehouse Systems Analyst (Information Systems Specialist 6) 100 % Remote Work Initial posting date: 10/09/2025 Application deadline: 10/26/2025 Agency: Oregon Health Authority Salary range: $6,031 - $9,133 Position type: Employee Job Description
The Data Warehouse Systems Analyst provides operations and maintenance support for custom built and purchased software programs that automate the business of the Oregon Health Authority and the Department of Human Services. This position is a part of a team that supports mostly internal applications that serve administrative support functions such as accounting, payroll, human resources, payment recovery, procurement and administration. The Office of Information Service’s mission is to deliver technology solutions and services that support Oregon Health Authority and Oregon Department of Human Services in helping Oregonians achieve health, well-being, and independence. More information about the Office of Information Services and current job opportunities can be found here. If this opportunity aligns with your strengths, background, and commitment to fostering inclusivity, we encourage you to apply. The Oregon Health Authority values diversity and encourages applicants from all backgrounds and experiences to help build a stronger, more equitable future for all. What We Are Looking For
These qualifications must be visible in your application/resume and cover letter. Special Requirements:
At least 1 year of professional experience in SQL Server and Database development. Minimum Qualifications Six (6) years of information systems experience in Database Development OR An Associate's degree in Computer Science, Information Technology, or related field, OR completion of a two (2) year accredited vocational training program in information technology or related field. AND Four (4) years of information systems experience in Database Development OR A Bachelor's degree in Information Technology, Computer Science, or related field AND Two (2) years of information systems experience in Database Development OR Master's degree in Information Technology, Computer Science, or related field may substitute for all of the above. Desired Attributes
The following are skills and lived experiences that we have identified as key to success in this role at OHA. If you possess any of these, please let us know in your application. The full list of desired attributes is linked in the Position Description above. Database platforms (SQL Server preferred) Data warehouse architecture, design, and optimization Extraction, transformation, and loading of large data sets (SSIS, C#.NET) Structured Query Language (SQL) Client and address matching (RedPoint preferred) Skills: Manage movement of large amounts of data Write complex SQL incorporating common table expressions, aggregate and window functions, sub queries and other functionality Oral and written communication
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, cover letter, and answer all supplemental questions.
Candidates that don\'t submit a resume, cover letter and completed application will be declined. External Candidates: Visit the State of Oregon job opportunities webpage to submit your application. Follow all submission requirements. Internal Candidates: Current State of Oregon employees must apply through Workday. After You Apply: Log in to your Workday account to check for pending tasks under “My Applications” and complete them. Check email (including junk) and Workday inbox for updates. Veterans documents for preference should be submitted as instructed; do not attach in the Resume/CV field. Reminders:
Submissions will be screened for consistency and communication skills. This announcement is for 1 full-time, permanent, classified, Data Warehouse Systems Analyst position based in Salem, Oregon. This is a full-time remote position. Review the working conditions in the Position Description. Benefits Of Joining Our Team: We offer a competitive benefits package including excellent medical, vision, and dental benefits, optional life insurance, disability coverage, 11 paid holidays, personal business days, sick leave, vacation accrual, potential eligibility for Public Service Loan Forgiveness, and retirement plan options. Training opportunities are available to grow your career with the State of Oregon. Additional Details
The information in your application will be used for an Equal Pay Analysis to determine salary placement. Salary is non-PERS qualifying unless the candidate is PERS qualifying. Agency does not sponsor visas. I-9 documentation is required within three days of hire. Helpful Links & Resources
How to Set Job Alerts | Workday Applicant FAQ | Oregon Health Authority | Veterans Resources The Oregon Health Authority is an affirmative action and equal opportunity employer. We do not discriminate and pay equity is pursued for all employees. We do not screen applicants based on current or past compensation. OH A is anti-racist and aims to eliminate health inequities. OHAAOOIS
#J-18808-Ljbffr
Data Warehouse Systems Analyst (Information Systems Specialist 6) 100 % Remote Work Join to apply for the Data Warehouse Systems Analyst (Information Systems Specialist 6) 100 % Remote Work role at Oregon Health Authority. Position title: Data Warehouse Systems Analyst (Information Systems Specialist 6) 100 % Remote Work Initial posting date: 10/09/2025 Application deadline: 10/26/2025 Agency: Oregon Health Authority Salary range: $6,031 - $9,133 Position type: Employee Job Description
The Data Warehouse Systems Analyst provides operations and maintenance support for custom built and purchased software programs that automate the business of the Oregon Health Authority and the Department of Human Services. This position is a part of a team that supports mostly internal applications that serve administrative support functions such as accounting, payroll, human resources, payment recovery, procurement and administration. The Office of Information Service’s mission is to deliver technology solutions and services that support Oregon Health Authority and Oregon Department of Human Services in helping Oregonians achieve health, well-being, and independence. More information about the Office of Information Services and current job opportunities can be found here. If this opportunity aligns with your strengths, background, and commitment to fostering inclusivity, we encourage you to apply. The Oregon Health Authority values diversity and encourages applicants from all backgrounds and experiences to help build a stronger, more equitable future for all. What We Are Looking For
These qualifications must be visible in your application/resume and cover letter. Special Requirements:
At least 1 year of professional experience in SQL Server and Database development. Minimum Qualifications Six (6) years of information systems experience in Database Development OR An Associate's degree in Computer Science, Information Technology, or related field, OR completion of a two (2) year accredited vocational training program in information technology or related field. AND Four (4) years of information systems experience in Database Development OR A Bachelor's degree in Information Technology, Computer Science, or related field AND Two (2) years of information systems experience in Database Development OR Master's degree in Information Technology, Computer Science, or related field may substitute for all of the above. Desired Attributes
The following are skills and lived experiences that we have identified as key to success in this role at OHA. If you possess any of these, please let us know in your application. The full list of desired attributes is linked in the Position Description above. Database platforms (SQL Server preferred) Data warehouse architecture, design, and optimization Extraction, transformation, and loading of large data sets (SSIS, C#.NET) Structured Query Language (SQL) Client and address matching (RedPoint preferred) Skills: Manage movement of large amounts of data Write complex SQL incorporating common table expressions, aggregate and window functions, sub queries and other functionality Oral and written communication
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, cover letter, and answer all supplemental questions.
Candidates that don\'t submit a resume, cover letter and completed application will be declined. External Candidates: Visit the State of Oregon job opportunities webpage to submit your application. Follow all submission requirements. Internal Candidates: Current State of Oregon employees must apply through Workday. After You Apply: Log in to your Workday account to check for pending tasks under “My Applications” and complete them. Check email (including junk) and Workday inbox for updates. Veterans documents for preference should be submitted as instructed; do not attach in the Resume/CV field. Reminders:
Submissions will be screened for consistency and communication skills. This announcement is for 1 full-time, permanent, classified, Data Warehouse Systems Analyst position based in Salem, Oregon. This is a full-time remote position. Review the working conditions in the Position Description. Benefits Of Joining Our Team: We offer a competitive benefits package including excellent medical, vision, and dental benefits, optional life insurance, disability coverage, 11 paid holidays, personal business days, sick leave, vacation accrual, potential eligibility for Public Service Loan Forgiveness, and retirement plan options. Training opportunities are available to grow your career with the State of Oregon. Additional Details
The information in your application will be used for an Equal Pay Analysis to determine salary placement. Salary is non-PERS qualifying unless the candidate is PERS qualifying. Agency does not sponsor visas. I-9 documentation is required within three days of hire. Helpful Links & Resources
How to Set Job Alerts | Workday Applicant FAQ | Oregon Health Authority | Veterans Resources The Oregon Health Authority is an affirmative action and equal opportunity employer. We do not discriminate and pay equity is pursued for all employees. We do not screen applicants based on current or past compensation. OH A is anti-racist and aims to eliminate health inequities. OHAAOOIS
#J-18808-Ljbffr