Address
Form of workInitial Posting Date:
11/09/2023
Application Deadline:
11/30/2023
Agency:
Oregon Health Authority
Salary Range:
$5,885 - $8,894
Position Type:
Employee
Position Title:
Senior Database Analyst (Information Systems Specialist 7)
Job Description:
PLEASE NOTE: Resumes, cover letters and all other documents must all be uploaded at one time. When uploading a resume, please upload any other documents in the same area/field.
The job application, resume, and a cover letter are required for this posting and should address the skills in this section clearly. Applications without the required documentation will not move forward in the selection process.
The Office of Information Service's mission is to deliver technology solutions and services that support Oregon Health Authority and Oregon Department of Health Services in helping Oregonians achieve health, well-being, and independence.
The Oregon Health Authority has a fantastic opportunity for a Senior Database Analyst to join an excellent team and work to advance their IT career.
The Oregon Health Authority is committed to:
This is a full-time permanent opportunity for anyone to apply. This is a Classified position and is union represented.
What you will do!
This position is part of the Medicaid Enterprise Systems (MES) Modularity unit team within VMS that supports State stakeholders and vendors for the current Medicaid Modularity Information System (MMIS) M&O activities and assists in the design and development efforts for major changes to IT systems that support Medicaid service delivery.
The individual in this position is required to develop an in-depth understanding of the complex Medicaid related systems from an architectural perspective and how it supports Medicaid service delivery, as well as how it connects to other core OHA and ODHS systems and services. These systems include the MMIS, Community Based Care (CBC), Client and Employee Provider (CEP), xPRS Payment Review System, and Immunization Registry.
What's in it for you?
What we are looking for:
(Please clearly outline how you meet the minimum qualifications in your application/resume/cover letter. Failure to do so might result in disqualification).
MINIMUM QUALIFICATIONS:
(a) Six (6) years of Information Systems experience in Database Analysis
OR
(b) 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 Analysis
OR
(c) A Bachelor's degree in Information Technology, Computer Science, or related field AND two (2) years of Information Systems experience in Database Analysis
OR
(d) Master's degree in Information Technology, Computer Science, or related field may substitute for all of the above.
DESIRED ATTRUBUTES:
Working Conditions
This position involves frequent contact with executives, management, and staff both internal and external to the organization. It requires working with a variety of people and situations, which requires the incumbent to exercise diplomacy. Confidentiality of information must be maintained at all times. This position requires the ability to work on multiple tasks simultaneously, within short time frames, and interface effectively with business partners. It requires maintenance of tight deadlines and close coordination of a large number of tasks. There can be frequent interruptions, demanding timeframes, and non-traditional working hours. At times, weekend and evening work is required to meet customer demands and department deadlines. The location of this position is in an office, cubicle and/or an agreed upon remote work environment with significant use of a computer and video conferencing.
Full-time remote work consideration is given when requirements below are met:
• Meet all responsibilities and perform all duties as if their role was performed in a traditional office setting.
• Comply with all agency policies, guidelines, and management directives.
• Maintain a professional demeanor in the performance of all duties.
• Meet and exceed performance expectations.
• Be available each week during traditional business hours, as determined by the business need.
There may be times that a position or an individual must be located full-time, on-site, within traditional business hours. Times when on-site presence can be required include but are not limited to training, performance, business alignment, accommodations, or resource availability. To be eligible for remote work, staff must have a home workspace that meets all applicable technology, security and safety requirements including the ability to provide protection of confidential information.
How to Apply
Attention current State of Oregon employees:
To apply for posted positions, please close this window, and log into your Workday account and apply through the career worklet.
To apply as a job rotation/developmental candidate, you must be currently employed by the State of Oregon (this includes regular status employees, who have completed trial service, as well as limited duration employees).
Help Your Application Rise to the Top!
Your candidate profile and resume are the perfect opportunity to highlight your interest in the position and showcase the amazing skills and experience, making you the best candidate for the position. Submissions will be screened for consistency of information and communication skills at the professional level (attention to detail, spelling, grammar, etc.).
Please ensure you've provided a thorough and updated application as it pertains to the position for which you are applying. If you meet the minimum qualifications for the position, and are the successful candidate, you may qualify for work out of class. For further information, please visit the Pay Equity Project homepage.
Questions/Need Help?
If you need assistance to participate in the application process, including an accommodation request under the American with Disabilities Act contact: Uma Abdullahi at umulkher.abdullahi@dhsoha.state.or.us
TTY users please use the Oregon Telecommunications Relay Service: 1-800-735-2900. For technical support, please call toll free 1-855-524-5627, for customer service assistance.
Additional Information
Affirmative Action and Equal Opportunity
The Oregon Health Authority is an affirmative action and equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, gender expression, national origin, age, protected veteran or disabled status, genetic information, or any other protected class under state or federal law. In addition, we do not discriminate, or screen applicants based on current or past compensation. To learn more about OHA's mission, vision, and core values, click here.
The Oregon Health Authority is an equal opportunity, affirmative action employer committed to workforce diversity.
Agency - OHAAOOIS
More information about the Office of Information Services and current job opportunities can be
11/09/2023
Application Deadline:
11/30/2023
Agency:
Oregon Health Authority
Salary Range:
$5,885 - $8,894
Position Type:
Employee
Position Title:
Senior Database Analyst (Information Systems Specialist 7)
Job Description:
PLEASE NOTE: Resumes, cover letters and all other documents must all be uploaded at one time. When uploading a resume, please upload any other documents in the same area/field.
The job application, resume, and a cover letter are required for this posting and should address the skills in this section clearly. Applications without the required documentation will not move forward in the selection process.
The Office of Information Service's mission is to deliver technology solutions and services that support Oregon Health Authority and Oregon Department of Health Services in helping Oregonians achieve health, well-being, and independence.
The Oregon Health Authority has a fantastic opportunity for a Senior Database Analyst to join an excellent team and work to advance their IT career.
The Oregon Health Authority is committed to:
- Eliminating health inequities in Oregon by 2030
- Becoming an anti-racist organization
- Developing and promoting culturally and linguistically appropriate programs, and
- Developing and retaining a diverse, inclusive, and equitable workforce that represents the diversity, cultures, strengths, and values of the people of Oregon.
- Click here to learn more about OHA's mission, vision and core values.
This is a full-time permanent opportunity for anyone to apply. This is a Classified position and is union represented.
What you will do!
This position is part of the Medicaid Enterprise Systems (MES) Modularity unit team within VMS that supports State stakeholders and vendors for the current Medicaid Modularity Information System (MMIS) M&O activities and assists in the design and development efforts for major changes to IT systems that support Medicaid service delivery.
The individual in this position is required to develop an in-depth understanding of the complex Medicaid related systems from an architectural perspective and how it supports Medicaid service delivery, as well as how it connects to other core OHA and ODHS systems and services. These systems include the MMIS, Community Based Care (CBC), Client and Employee Provider (CEP), xPRS Payment Review System, and Immunization Registry.
What's in it for you?
- Medical, vision, and dental benefits
- 11 paid holidays
- 8 hours of vacation per month, eligible to be used after 6 months of service
- 8 hours of sick leave per month, eligible to be used as accrued
- 24 hours of personal business leave per fiscal year, eligible to be used after 6 months of service
- Pension and retirement programs
- Opportunity to potentially receive loan forgiveness under the Public Service Loan Forgiveness Program (PSLF)
- Continuous growth and development opportunities
- Opportunities to serve your community and make an impact through meaningful work
- A healthy work/life balance, including fulltime remote options as well
What we are looking for:
(Please clearly outline how you meet the minimum qualifications in your application/resume/cover letter. Failure to do so might result in disqualification).
MINIMUM QUALIFICATIONS:
(a) Six (6) years of Information Systems experience in Database Analysis
OR
(b) 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 Analysis
OR
(c) A Bachelor's degree in Information Technology, Computer Science, or related field AND two (2) years of Information Systems experience in Database Analysis
OR
(d) Master's degree in Information Technology, Computer Science, or related field may substitute for all of the above.
DESIRED ATTRUBUTES:
- Strong knowledge of data and database administration and security concepts.
- Experience with SQL server configuration along with performance tuning and monitoring.
- Demonstrated knowledge of developing, deploying, and maintaining complex report and dashboard projects
- Strong ability to write complex SQL statements; experience with SQL Server DBMS and Oracle PL/SQL
- Have strong verbal and written skills along with the ability to effectively communicate with non-technical business stakeholders
- Strong ability to analyze and QA data, identify data integrity issues and make recommendations
Working Conditions
This position involves frequent contact with executives, management, and staff both internal and external to the organization. It requires working with a variety of people and situations, which requires the incumbent to exercise diplomacy. Confidentiality of information must be maintained at all times. This position requires the ability to work on multiple tasks simultaneously, within short time frames, and interface effectively with business partners. It requires maintenance of tight deadlines and close coordination of a large number of tasks. There can be frequent interruptions, demanding timeframes, and non-traditional working hours. At times, weekend and evening work is required to meet customer demands and department deadlines. The location of this position is in an office, cubicle and/or an agreed upon remote work environment with significant use of a computer and video conferencing.
Full-time remote work consideration is given when requirements below are met:
• Meet all responsibilities and perform all duties as if their role was performed in a traditional office setting.
• Comply with all agency policies, guidelines, and management directives.
• Maintain a professional demeanor in the performance of all duties.
• Meet and exceed performance expectations.
• Be available each week during traditional business hours, as determined by the business need.
There may be times that a position or an individual must be located full-time, on-site, within traditional business hours. Times when on-site presence can be required include but are not limited to training, performance, business alignment, accommodations, or resource availability. To be eligible for remote work, staff must have a home workspace that meets all applicable technology, security and safety requirements including the ability to provide protection of confidential information.
How to Apply
- Complete the online application
- Complete questionnaire
- Attach a resume
- Attach a cover letter of no more than two pages addressing the "What we are looking for?" section including required and preferred skills.
Attention current State of Oregon employees:
To apply for posted positions, please close this window, and log into your Workday account and apply through the career worklet.
To apply as a job rotation/developmental candidate, you must be currently employed by the State of Oregon (this includes regular status employees, who have completed trial service, as well as limited duration employees).
Help Your Application Rise to the Top!
Your candidate profile and resume are the perfect opportunity to highlight your interest in the position and showcase the amazing skills and experience, making you the best candidate for the position. Submissions will be screened for consistency of information and communication skills at the professional level (attention to detail, spelling, grammar, etc.).
- This posting closes at 11:59 PM on the close date listed.
- Workday will timeout after 15 minutes of inactivity.
- Workday performs best in Google Chrome.
- You must have a valid email address to apply.
- Check both your email and Workday account for updates regarding this recruitment.
- Please print or save a copy of this announcement. You will not have access to it once the posting closes.
Please ensure you've provided a thorough and updated application as it pertains to the position for which you are applying. If you meet the minimum qualifications for the position, and are the successful candidate, you may qualify for work out of class. For further information, please visit the Pay Equity Project homepage.
Questions/Need Help?
If you need assistance to participate in the application process, including an accommodation request under the American with Disabilities Act contact: Uma Abdullahi at umulkher.abdullahi@dhsoha.state.or.us
TTY users please use the Oregon Telecommunications Relay Service: 1-800-735-2900. For technical support, please call toll free 1-855-524-5627, for customer service assistance.
Additional Information
- Please monitor your Workday account to view all communication regarding your application. You must have a valid e-mail address to apply.
- Background Check: If you are offered employment, your offer will be contingent upon the positive outcome of an abuse check, criminal records check and driving records check. The information will be shared with the Oregon Health Authority (OHA), Office of Human Resources (OHR). Any criminal or founded abuse history will be reviewed and could result in the withdrawal of the offer or termination of employment.
- Veterans: If you are a veteran, you may receive veteran's preference. Click here for more information about veterans' preference. To receive veterans' preference points, please submit the following required documentation when you apply:
- A copy of your DD214/DD215 form; OR a letter from the US Dept. of Veterans Affairs indicating you receive a non-service-connected pension for the five (5) point preference.
- A copy of your DD214/DD215 form; AND a copy of your veterans' disability preference letter from the Dept. of Veterans Affairs for the ten (10) point preference.
- Visa Sponsorship: We do not offer VISA sponsorships or transfers currently. You will be required to complete the US Department of Homeland Security's I-9 form confirming authorization to work in the United States within three days of hire.
- Please attach only the documents that are related to the position. Additional documents that are attached will not be reviewed.
Affirmative Action and Equal Opportunity
The Oregon Health Authority is an affirmative action and equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, gender expression, national origin, age, protected veteran or disabled status, genetic information, or any other protected class under state or federal law. In addition, we do not discriminate, or screen applicants based on current or past compensation. To learn more about OHA's mission, vision, and core values, click here.
The Oregon Health Authority is an equal opportunity, affirmative action employer committed to workforce diversity.
Agency - OHAAOOIS
More information about the Office of Information Services and current job opportunities can be
