Senior Data warehouse Architect, Information Systems Specialist 8 (Salem/Hybrid)

Oregon State Government Jobs; Salem (OR); Hybrid; USD 80,000 - 100,000; Full time

Job summary

The Oregon Department of Corrections is seeking a Senior Data Warehouse Architect to design and manage data warehousing solutions. This role involves collaboration with various stakeholders to ensure data accessibility and reliability, supporting the department's mission while offering a competitive salary and benefits.

Benefits

Family health, vision, and dental insurance

Vacation and sick leave

Fully paid retirement program

Flexible spending accounts

Qualifications

• Seven years of experience in data warehouse design and architecture.
• Experience with ETL/ELT design methods and tools.
• Familiarity with cloud data platforms (AWS, GCP, Azure).

Responsibilities

• Design and develop enterprise data warehouse solutions.
• Define data architecture strategy and data models.
• Collaborate with stakeholders to understand data requirements.

Skills

Data storage management

Information security

Database infrastructure management

Software development lifecycle

Data governance

Communication skills

Education

Bachelor's degree in Information Technology

Master's degree in Information Technology

Job description

Initial Posting Date:

05/23/2025

Application Deadline:

06/02/2025

Agency:

Department of Corrections

Salary Range:

$7,645 - $11,608

Position Type:

Employee

Position Title:

Senior Data warehouse Architect, Information Systems Specialist 8 (Salem/Hybrid)

Job Description:

Senior Data warehouse Architect, Information Systems Specialist 8 (Salem/Hybrid)

Central Distribution Center – Salem/Hybrid

Oregon Department of Corrections

Are you a seasoned data professional with a passion for public service and data-driven decision making? The Oregon Department of Corrections is seeking a highly skilled and self-motivated Information Systems Specialist 8 to serve as our Senior Data warehouse Architect within the information Technology Services unit.

This position is approved for telework work but will be required to report the ODOC Central Services Office in Salem, Oregon as needed.

About the Job – Your Role

As a Senior Data warehouse Architect you will design, implement, and manage scalable and high-performance data warehousing solutions and be responsible for setting the vision and standards for our data architecture, ensuring data is accessible, reliable, and aligned with business needs of Oregon Department of Corrections, its community corrections partners, as well as several other partner criminal justice organizations across the state of Oregon.

This position will collaborate with Information Technology staff, Research Analysts, Data Owners, Program Managers and Directors to provide the data necessary to create and manage reports and dashboards, consult on standards and controls (best practices), optimal methods, procedures, processes. This position is responsible for providing technical assistance and guidance to Business Intelligence users.

Key Responsibilities

• Design and develop enterprise data warehouse/data lake solutions that support business intelligence, reporting, and analytics.
• Define data architecture strategy, data models, and integration patterns across various data sources.
• Collaborate with business stakeholders to understand data requirements and translate them into effective technical designs.
• Lead the selection and implementation of appropriate data warehousing technologies and platforms.
• Develop ETL/ELT pipelines and ensure efficient data ingestion, transformation, and loading processes.
• Define and enforce data governance, security, and quality best practices.
• Monitor performance and optimize data architecture for speed, cost, and scalability.
• Mentor data engineers and ensure adherence to architectural standards and best practices.

For a full review of position description and duties please contact the listed recruiter.

This position is represented by American Federation of State, County, and Municipal Employees (AFSCME). This position may be eligible for Police & Fire (P&F) benefits through Public Employees Retirement System (PERS), as defined by statute.

Minimum Qualifications:

Seven (7) years of information systems experience in, Data warehouse design, data architecture, and data warehouse administration technologies;
OR

An Associate's degree or higher 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 Five (5) years of information systems experience in data warehouse design, data architecture, and data warehouse administration technologies;

OR

A Bachelor's degree in Information Technology, Computer Science, or related field AND three (3) years of information systems experience in data warehouse design, data architecture, and data warehouse administration technologies;

OR

A Master's degree in Information Technology, Computer Science, or related field AND one (1) year of information systems experience in data warehouse design, data architecture, and data warehouse administration technologies.

General Knowledge of

• Data storage management and warehousing principles
• Information security knowledge, standards, and principles
• Database infrastructure resource management
• Database infrastructure testing and troubleshooting techniques
• Software development lifecycle, practices, and principles
• Enterprise Architecture standards and principles

Requested Skills

• Extensive experience designing and developing data warehouse solutions;
• Extensive experience with ETL/ELT design methods and tools;
• Experience with real-time and batch data processing and integration.
• Background in machine learning;
• Familiarity with cloud data platforms (AWS, GCP, Azure);
• Solid understanding of data governance, privacy regulations (GDPR, CCPA) and security best practices;
• Experience with Business Intelligence tools like Power BI or other reporting platforms.
• Experience with Agile and Object-Oriented development methodologies;
• Excellent communication skills, both oral and written;

Preferred Skills

Preference will be given to those with the following skills/experience:

• 10+ years of experience in data engineering or data warehouse roles, with at least 7 years as a data warehouse architect;
• Expertise in modern data warehouse solutions and ETL/ELT tools and techniques;
• 3+ end to end migration projects from on-premises data warehouse to Cloud data solutions in a technical capacity (developer or architect);
• Proficiency in languages like Python, SQL, Java;
• Experience with data security, privacy and compliance;
• Strong SQL skills and experience with data modeling (dimensional, star, snowflake schemas).
• Certifications in Data Warehouse like CDMP, Big Data, Cloud;

Application Information

• In the Work Experience section of your application make sure to include the dates and duties of all relevant positions and details to support how you meet these attributes. If you do not include education or work experience meeting the minimum qualifications, you will not be considered for the position. Only the candidates whose experience most closely matches the qualifications and requested skills of this position will be invited to interview. Applicants must meet the minimum qualifications on or before the job posting close date.
• The job posting closes at 11:59 PM (PDT/PST) on the close date. After you submit your application, be sure to respond to the two questionnaires relating to public records requests and veterans’ preference immediately following your submittal. These questions are necessary to complete the application process.
• Please monitor both your email and Workday account for updates regarding this recruitment.
• As part of our selection process, we may require additional assessment stages, such as written exercises, to further evaluate candidates’ qualifications. Meaningful participation in these exercises is required for all applicants moving forward in the process. Failure to complete the required exercise(s) within the specified timeframe will result in disqualification from consideration. All candidates who successfully complete these screening stages and meet the necessary requirements will advance to the next stage in the selection process.
• Please save a copy of this job announcement for reference, as it is not available for you to view after the announcement deadline.

Working Conditions

Working in a standard office environment with extended use of computers and other office technology. Use of video meeting software. Contact with adults in custody. Travel as necessary within the state.

About the Department

The Oregon Department of Corrections is responsible for over 12,000 adults in custody in 12 state prisons throughout Oregon. It advises and evaluates counties regarding administration of probation and parole programs supervising more than 24,000 offenders in Oregon communities. The mission is to protect communities, promote accountability, and transform lives.

The Oregon Department of Corrections serves a diverse and changing population of people who are incarcerated and on supervision. We commit to creating an organization both reflecting the diversity of the population we serve and ensuring all employees thrive in a culture of safety, trust, and belonging. We strive to be an anti-racist corrections system. Welcoming, inclusive, and respectful of all people. Free of discrimination, harassment, and retaliation.

The Department offers a variety of programs and opportunity to create a safe and healthy environment to for our staff, volunteers, and adults in custody. Joining the Oregon Department of Corrections is joining a team working for the benefit of our communities through innovative and proven correctional practices.

Benefits

The salary range listed above is for non-PERS qualifying applicants. PERS qualifying applicants may be eligible for an adjusted range to reflect an additional 6.95%.

The State of Oregon provides a generous benefit package, which includes:

• Family health, vision, and dental insurance
• Vacation, sick leave, and 11 paid holidays
• 21 days paid military leave for national guard and reserve components
• Optional short and long-term disability
• Term life insurance
• Fully paid retirement program
• Oregon Saving Growth Plan
• Flexible spending accounts for health and childcare
• And more

About the Process – What to Expect

• After the application deadline, a recruiter will review submissions for education and experience to identify candidates who best fit the minimum qualifications and requested skills.
• Top candidates will be referred to the hiring manager.
• The hiring manager will review your application and schedule interviews.
• Interview will be held with a panel of stakeholders who have completed panel assessment training. Scores will be determined based on predetermined questions and scoring guides. Preferences points will be applied in compliance with relevant laws and bargaining agreements. There may be multiple rounds of interviews.
• Final candidates will have a background check, PREA check, and reference checks.
• A Classification and Compensation analyst will review the Workday Application of the successful candidate to determine starting wages. Learn more about Equal Pay.
• A job offer will be extended through Workday to the successful candidate. Congratulations, and welcome to the team!

Requirements for Employment

The successful candidate for this position must pass a Criminal Justice Information Systems (CJIS) fingerprint-based background check and maintain CJIS eligibility. Due to CJIS requirements related to system access, there may be some felony convictions that could disqualify you for this position. However, having a felony record does not exclusively restrict you from being considered as an applicant. CJIS clearance is done at the conditional job offer. If you have questions about whether or not your criminal record could disqualify for you, please contact the recruiter for more information.

Equity, Diversity, Inclusion, and Belonging (EDI&B) is embedded in the Department of Corrections core values. The department strives to be a model employer committed to promoting diversity, equity, inclusion, and belonging. Ensuring legal compliance, efficiency, and exceeding expectations to deliver the best public services.

We are proud to be an Equal Opportunity Employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran or protected veteran status, genetic information and other legally protected characteristics. Additional information can be found from The U.S. Equal Employment Opportunity Commission (EEOC) Know Your Rights.

The Oregon Department of Corrections is responsible for complying with the Federal Prison Rape Elimination Act (PREA 42 U.S.C. 1997). PREA prohibits the Oregon Department of Corrections from hiring, promoting, or contracting with anyone, (that will have direct contact with residents), who has engaged in, been convicted of, or been civilly or administratively adjudicated for engaging in sexual abuse in confinement settings. Learn more about PREA.

Under Oregon Law, qualifying veterans may apply for veterans’ preference. Review our veterans’ preference page for details about eligibility. Please note – if you are a veteran, you will receive a task in Workday to upload your documents immediately after you submit your initial application. You will have up until 24 hours after the posted application deadline to submit the appropriate documentation.

Questions

If you have questions about the position, selection process, or need accommodations to participate in the recruitment process please contact the recruiter and reference the requisition number.

Recruiter: Cynthia Rodriguez, [e-mail]

Reference Number: Req-181182

• Workday will timeout after 15 minutes of inactivity. You may lose progress on your application.
• Workday performs weekly maintenance Friday evenings, and the system may be down for several hours.
• ODOC does not offer visa sponsorship. Within three days of hire, applicants will be required to complete an I-9 and confirm authorization to work in the United States.
• This applicant list may be used to fill future vacancies. Application information may be used throughout the entire selection process. This process is subject to change without notice.
• This announcement is intended as a general descriptive recruitment guide and is subject to change. It does not constitute either an expressed or implied contract. The pay and benefits on all announcements may change without notice.