Information Systems Specialist 7 - Business Intelligence Developer (Limited Duration)

Initial Posting Date:

Application Deadline:

Agency:

Salary Range:

Position Type:

Position Title:

Job Description:

Bring your experience with PowerBI and reporting/analytical tools to OYA!

Join our diverse and inclusive team at the Oregon Youth Authority (OYA) Information Systems Department as a full-time, Limited Duration Business Intelligence Developer. We are seeking an experienced individual proficient in PowerBI and reporting/analytical tools to contribute to our mission. As a Business Intelligence Developer, you will play a crucial role in designing, implementing, and maintaining inclusive reporting systems that promote data mining, research, program evaluation, and information dissemination. Collaborating with managers, information systems staff, researchers, and planners from various departments, you will ensure optimal reporting methods for the Juvenile Justice Information System (JJIS) Reporting database and OYA's data warehouse. Your responsibilities will encompass analysis, planning and coordination, design, development, and maintenance of the JJIS reporting system and the Department's data warehouse reporting system. Additionally, you will provide valuable technical assistance to Business Intelligence users. If you are passionate about diversity, equity, and inclusion and possess the necessary expertise, we encourage you to apply and make a difference with us.

Additional Information:

• For a complete list of duties and responsibilities, please click here.
• Limited Duration: This is a 12 month limited duration appointment. Limited duration appointments are benefits eligible and have a designated maximum length of service. This position has the potential to become permanent.
• Open until-filled:This recruitment will remain open until filled. Our first application screening is scheduled for 8:30 a.m. onMay 5, 2025but we may close the announcement at any time when we have received an adequate number of applications. We cannot guarantee that we will consider applications received after the first screening date. We encourage interested applicants not to delay in applying.
• Telework: This position is eligible for telework. You maybe required to come to Central Office for mandatory meetings. Currently this position will maintain a remote work schedule. Remote work is evaluated periodically to ensure business needs are being met and can be adjusted at any time. Please visit the state's Work Reimagined website for more information.
• Representation: This position is represented by the Service Employees International Union (SEIU/OPEU)
• We may used this recruitment to fill future vacancies.

ABOUT OYA

At OYA, diversity, equity, and inclusion are more than just words on a page.To meet our mission and live our values as an agency, DEI must be at the heart of all we do. We support cultural competence, develop teams and cultivate leaders in ways that are equitable to everyone, especially people of color, those who identify as LGBTQ+, or those from other marginalized communities. We are explicit and intentional as we identify resources that all our youth and staff need to grow and prosper. Our DEI work connects closely with our culture of positive human development, with safe and supportive environments where everyone is held accountable and connected to their community. The end goal is to protect the public and reduce crime by holding youth accountable and providing opportunities for reformation in safe environments.

If you are looking to join a team that values individual and cultural differences, with the opportunity to contribute to youth reformation by enriching our workforce with diversity, OYA wants to hear from you! People of color, women, and other members of historically marginalized communities are strongly encouraged to apply!

For more information please visitwww.oregon.gov/oya.

What's in it for You?
OYA values our employees. We believe that your time outside of the workplace is as valuable as it is inside the workplace. We offer a great work/life balance with flexible work schedules on most positions and a competitive benefits package, including low-cost, high-coverage health insurance, generous time-off, and a competitive retirement plan.

Discover moreabout working in Oregon state government byclicking here.

What We Are Looking For:

• Six (6) years of information systems experience with PowerBI and reporting/analytical tools such as SAP BusinessObjects suite, Cognos, SSRS.

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 with PowerBI and reporting/analytical tools such as SAP BusinessObjects suite, Cognos, SSRS.

OR

• A Bachelor's degree in Information Technology, Computer Science, or related field AND
• two (2) years of information systems experience with PowerBI and reporting/analytical tools such as SAP BusinessObjects suite, Cognos, SSRS.

OR

• Master's degree in Information Technology, Computer Science, or related field may substitute for all of the above.

REQUIRED SKILLS

• This position requires good verbal and written skills, and the ability to effectively communicate difficult technical automation concepts to end-users and managers who may have little or no automation experience.
• Have knowledge of databases and automated systems, including PC-based and server-based systems and networks.
• Ability to comprehend complex details of OYA's automated systems, JJIS, and Windows server operations.
• Experience using SQL, Oracle, SQL Server DBMS, structured programming techniques, SAP business intelligence and analytical tools, data transformation software and techniques, and data warehousing techniques and theories.

DESIRED ATTRIBUTES/APPLICATION SCORING CRITERIA: If you have these qualities, let us know! It's how we will choose whom to move forward!

Note: You do not need to have all of these qualities to be eligible for this position.

• Extensive experience developing and maintain complex reports and dashboards (preferably PowerBI, Crystal Reports, Web Intelligence)
• Demonstrated ability to write complex SQL statements using T-SQL or Oracle SQL
• Experience using SAP BusinessObjects and Information Design Tool and/or other analytical tools
• Experience using quality assurance best practices and data analytic techniques to troubleshoot, identify data integrity issues, and analyze data
• Experience gathering and creating requirements; prioritizing tasks and maintaining technical documentation

How to apply:

• Complete the application fully or upload current, updated resume.
• Complete the questionnaire / supplemental questions.
• After you submit your application please respond to the public records request authorization and gender identity questionnaire. This step will come after you submit and will complete the process. If you are an employee, the tasks will come to your Workday inbox.
• If you are a veteran, you may receive preference. Click here for more information about veterans' preference. The task to claim preference will come after the public records request and gender identity questionnaire tasks. Click here for a guide on how to upload your documents. For privacy reasons, please do not attach your DD214/DD215/civil service preference letter to your application or combine it with any other required document attachments.

Good To Know Information:

Our goal is to be a diverse workforce that is representative, at all job levels, of the citizens we are here to serve. OYA is an equal opportunity and affirmative action employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be individualized based on merit, competence, performance, and business need.

We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, veteran status, or any other status protected under federal, state, or local law." The more diverse we are, the better our work will be.

Applicants with a disability may request a reasonable accommodation to participate in the hiring process. For assistance regarding reasonable accommodation or for alternative format please contact OYA Recruitment at 971-345-1236. Oregon Relay Service can be reached by calling 7-1-1.

Pre-employment Checks:

In keeping with our mission, OYA will conduct a criminal record check, per OAR 416 Division 800, a driving record background check and a vulnerable population abuse and neglect check. Information obtained about an individual is confidential. An individual who refuses to consent to a criminal records/background check shall be disqualified from consideration in the position for which you applied. All applicants are subject to additional pre-employment check(s) such as fingerprint based on criminal records check, pre-employment drug screening and/or education verification as required for the position.

In 2003 Congress passed the Prison Rape Elimination Act (PREA), the first federal civil statue focused specifically on addressing sexual violence in juvenile facilities, jails, prisons, and other facilities. In recognition of the rights, safety, and well-being of the youth we serve you will be asked specific questions about your background to ensure our hiring and promotion practices comply with the National PREA standards.

All positions in OYA will require the incumbent to serve as a "mandatory reporter" of child abuse.

Visa Sponsorship:

We do not offer Visa sponsorship. If you are hired, you will be required to fill out the US Department of Homeland Security's I-9 form confirming you are able to work in the US. OYAuses E-Verify to confirm that applicants are authorized to work in the United States.

Have Questions?:

For questions about the job announcement, email OYA Recruiter.