Data Warehouse Developer

Data Warehouse Developer

Job ID: 108182

Location: Oregon City, Oregon

Full/Part Time: Full Time

Regular/Temporary:Regular

CLACKAMAS COUNTY CORE VALUES

Clackamas County employees work to serve the public and enrich our community. In that spirit, we pledge to hold ourselves to these standards at all times in our interactions with customers and one another:

• Service

• Professionalism

• Integrity

• Respect

• Individual accountability

• Trust

By incorporating these values into our daily routines, we can better serve our customers, ourselves, and our projects. We're always looking to improve. That's the Clackamas County SPIRIT. https://www.clackamas.us/countyadmin/spirit

Clackamas County is committed to building a community where people thrive, have a sense of safety, connection, and belonging, so that everyone is honored and celebrated for the richness in diversity they bring. We encourage applicants of diverse backgrounds and lived experiences to apply.

WHO MAY APPLY

Clackamas County does not offer visa sponsorships. Once a job applicant accepts the position, they will be required to complete an I-9 and confirm their authorization to work in the United States prior to their first day.

This is not a remote work position. The incumbent will be expected to report on-site for in-person meetings, team collaboration, trainings, or other operational needs as determined by the department.

CLOSE DATE

This position will remain open until filled. The first application review will be on Thursday, March 5, 2026. We reserve the right to close this recruitment at any time on or after that date.

PAY AND BENEFITS

Annual Pay Range: $102,867.21 - $130,459.38

Hourly Pay Range: $49.455391 - $62.720856

Salary offers will be made within the posted pay range and will be based on a candidate's experience (paid or unpaid) that is directly relevant to the position. This position is classified as a Systems Project Analyst, Senior.

Clackamas County proudly offers an attractive compensation and benefits package, including competitive wages, cost-of-living adjustments, merit increases (for eligible employees), and a robust sick and vacation plan for regular status employees.

We encourage and support employee health and wellness by offering, health and wellness classes and events, and alternative care benefits, so you can customize your wellness needs to fit your lifestyle. Employee benefits become effective the first of the month following an employee's date of hire.

Attractive benefits package and incentives for employees in regular status positions are detailed below.

Generous paid time off package, including:

• 12 hours of vacation accrued per month

• Eligible newly hired employees will have the one-time option to frontload their first year of vacation accruals! This means you have access to vacation leave at time of hire.

• 8 hours of sick accrued per month

• 10 paid holidays and 1 personal day per year

Other Benefits:

• Membership in the Public Employees Retirement System (PERS)/Oregon Public Service Retirement Plan (OPSRP):

• Employer paid 6% PERS retirement contribution (The county currently pays the employee's share of the retirement contribution.)

• A Choice of Medical Plans that include chiropractic coverage, alternative care, vision, and prescription drug coverage

• A Choice of Dental Plans

• Longevity pay

• Other retirement Savings Options that allow for additional retirement funds savings, including an option to contribute a portion of employee earnings on a pre or post-tax basis to a 457b Deferred Compensation Plan

• A variety of additional optional benefits (see links below for additional information)

This is a full-time county position represented by the Employees' Association.

https://dochub.clackamas.us/documents/drupal/1e311321-f9ff-4daa-8753-bbdfb4e8d1b4

http://www.clackamas.us/des/benefits.html

JOB DETAILS AND QUALIFICATIONS

Clackamas County's Department of Technology Services (TS) is seeking a dedicated and experienced Data Warehouse Developer to support and enhance the data warehouse serving the Housing & Community Development (HCD) Department.

This position will work closely with the county's Housing & Community Development Division (HCDD) to provide data management and analysis needs to build and implement a regional approach to ending homelessness in Clackamas County. HCDD is in its founding phase and seeks a skilled leader in data system analytics to lead data integration across HMIS and other systems. This position will oversee the ongoing design, enhancement, and implementation of a data warehouse solution that extracts, transforms, and loads (ETL) HMIS data for accurate and efficient reporting. The selected candidate will join the TS Applications team, collaborating with colleagues to build, enhance, and maintain the database environment effectively. Working closely with the Clackamas Housing and Community Development, the Data Warehouse Developer will identify business requirements and build data extraction and reporting applications that meet regulatory and strategic funding compliance.

Key responsibilities of this role include:

• Leading complex projects, developing policies and guidelines, and providing advanced technical expertise in data warehouse development, design, and architecture.

• Implement and maintain security measures to protect sensitive data and manage user access to the data warehouse.

• Create and optimize complex ETL workflows to ensure data accuracy, completeness, and reliability.

• Develop and maintain scripts, queries, and routines for data cleansing, transformation, and loading.

• Collaborate with external entities to determine tools, design, and build system components to extract, process, and integrate data from multiple sources, ensuring automated processing where possible.

• Utilizing software tools for systems analysis, logic design, applications programming, database management, troubleshooting, and ensuring operational integrity;

• Managing contracted relationships with OCHIN's Professional Services Group for report development, coordinating requirements, validation, and results verification;

• Providing technical leadership for Housing and Community Development projects, including system design, building, testing, and implementation of various components; and

• Develop, support, and maintain data extraction and transmission tools to external entities for grants, security, and business needs.

The Housing Program provides support to those in the region experiencing homelessness or at risk of homelessness. Equity, diversity, and inclusion are at the core of everything we do. Clackamas County is committed to building a workforce that reflects the community we serve. In that spirit, we encourage applicants of diverse backgrounds and experiences to apply.

Required Minimum Qualifications/ Transferrable Skills:*

• A minimum of seven (7) years of experience in data warehouse development, ETL processes, and database design

• Demonstrated proficiency in ETL tools and languages such as SQL or other scripting languages

• Demonstrated knowledge of database management principles and techniques (SQL coding, writing TSQL queries, data warehouse schema design)

• Strong project management and leadership skills

• Strong problem-solving abilities and analytical thinking

• Effective communication skills to collaborate with internal and external partners

Preferred Special Qualifications/ Transferrable Skills:*

• These are preferred but not required qualifications. No experience in any or all of the following will not necessarily disqualify you from consideration.

• Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience)

• Experience with data visualization and reporting tools (e.g., Tableau, Power BI)

• Experience working with Homeless Management Information System (HMIS)

• Demonstrated proficiency in C# or other .NET development languages, Python, and Java, with the ability to apply object-oriented programming principles in data-driven environments

Pre-Employment Requirements:

• Must pass a criminal history check, which may include national or state fingerprint records check

• Driving is required for county business on a regular basis or to accomplish work. Incumbents must possess a valid driver's license, and possess and maintain an acceptable driving record throughout the course of employment. http://dochub.clackamas.us/documents/drupal/828106a0-265a-47cc-a3a6-0a2c8b028673

*For veterans qualified for Veterans' Preference: If you believe you have skills that would transfer well to this position and/or special qualifications that relate to this position, please list those skills and/or qualifications in the open-ended question at the end of the application and explain how those skills and/or qualifications relate to this position.

TYPICAL TASKS

Duties may include, but are not limited to the following:

• Consult with personnel across various departments (QI, Financial, and health care clinic management) to determine business requirements, then analyze, design, build, and maintain reports and data extracts needed for the monitoring and operation of the health care clinics, as well as reporting to various internal departments and regulatory bodies.

• Work with OCHIN EPIC and Clackamas Network personnel to implement a facility to automatically run reports in EPIC and deliver the output to a Clackamas file share for consumption by Health Centers leadership and staff.

• Work with outside entities (i.e., CareOregon, Crossroads, PreManage) to determine the tools to be used, design, and build the multiple components of the system to extract/import data from multiple sources, perform complex processing, and produce the required output. Where possible, the system retrieves and sends input/output data electronically on a scheduled basis without manual intervention.

• Utilize appropriate software tools and techniques for systems analysis, logic design, applications programming and coding, database management, computer operations, troubleshooting equipment problems, and maintaining operational integrity of the computer system. Determine business requirements, design, build, document, and maintain a C# application and MS-SOL database, to extract, transform, and load data from enterprise applications.

• Participate in meetings, forums, webinars, etc., with internal departments and external entities to advise on the impacts of upcoming changes and identify opportunities for improvement and efficiency.

• Manage the contracted relationship with OCHIN's Professional Services Group to build business objects reports for Health Centers. Develop the business requirements, coordinate between end users and OCHIN developers, and validate the results.

• Provide technical leadership and expertise to Health Centers' projects, determining technology needs and purchasing or building systems to meet those needs. Overall systems design, building, testing, and implementing the various components.

• Develop and maintain tools to extract and import data from multiple sources, then process and transmit the data to outside entities for grants, security, and other business needs (OHA, SAM/OIG exclusion screening, 340B partners, UDS, etc.).

• Develop detailed design specifications, definitions, flow charts, diagrams, performance criteria, and testing methods; writes, develops, and documents operational procedures for data elements and sources; coordinates systems maintenance, testing, and production runs; devises schedules for implementation; provides training and technical guidance to users and staff in the use of new or modified systems and procedures.

WORKING CONDITIONS

Frequently works early and late hours to meet timelines, provide off-hour upgrade and maintenance, and respond to emergency situations.

WORK SCHEDULE

This position is included in the county's alternate workweek program, working 40 hours during a standard workweek of Monday through Thursday (Fridays off). Specific hours of work will be discussed with the candidate selected for this position at the time an offer of employment is extended.

This is not a remote work position. This position is eligible for hybrid on-site/telework, subject to the https://dochub.clackamas.us/documents/drupal/9065b5fb-2237-47ce-9534-e7c8c40fc2bc and based on the Department's business needs. The exact amount of on-site/telework and schedule will be discussed with the hiring manager at the time of offer. The incumbent will be expected to report on-site for in-person meetings, team collaboration, trainings, or other operational needs as determined by the department.

Telework locations cannot be located outside of Oregon or Washington. Telework from any other state is not allowed. Washington residents must perform 50% of their time on-site at Clackamas County.

EXPLORE CLACKAMAS COUNTY

Clackamas County is in a prime location in the Portland, Oregon metropolitan area and is recognized nationally as one of the most livable areas in the United States. Located on the southern edge of the City of Portland and extending to the top of Mt. Hood, Clackamas County is part of a thriving region in the Northwest. It has a population of about 420,000 residents.

• http://www.clackamas.us/

• http://www.clackamas.us/onboarding/

• https://www.mthoodterritory.com/

ABOUT THE DEPARTMENT

High-quality, innovative, cost-effective technology for county commissioners and departments

While it is not possible to know with certainty all of the challenges that the future will bring, one assumption seems certain: today's practices will not be adequate to meet tomorrow's needs.

Additionally, we know that technology is constantly changing. Therefore, as Clackamas County is committed to providing high-quality public service, we must continually strive to improve. We can accomplish this by providing the necessary ongoing training, improving and upgrading our computer systems — both software and hardware — whenever feasible, and implementing county-wide technical standards to ensure compliance.

The Technology Services staff is committed to meeting these goals and looks forward to the challenges and opportunities of the future.

http://www.clackamas.us/ts/

APPLICATION PROCESS

Clackamas County only accepts online applications.

Help With Your Application:

• https://dochub.clackamas.us/documents/drupal/6b3147a3-bf84-4f52-8238-64a37e936b4f

• https://www.clackamas.us/jobs#helpwiththeapplication

If you have any questions or issues you may contact the Department of Human Resources at 503-655-8459 or mailto:jobs@co.clackamas.or.us?subject=Application%20Materials%20Question. Our office hours are Monday - Thursday 7:00 a.m. - 6:00 p.m. Pacific Time (closed on Fridays).

HOW TO CLAIM VETERAN'S PREFERENCE

• https://www.clackamas.us/des/jobs.html

• https://dochub.clackamas.us/documents/drupal/a67ee11c-861c-4126-aa5a-4dec6174f6eb

VISA SPONSORSHIP

Clackamas County does not offer visa sponsorships. Once a job applicant has accepted a position, they will be required to complete an I-9 and confirm authorization to work in the United States prior to their first day.

EQUAL EMPLOYMENT OPPORTUNITY

Clackamas County is an Equal Opportunity Employer. We value diversity, equity, and inclusion as essential elements that create and foster a welcoming workplace. All qualified persons will be considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, political affiliation, disability or any other factor unrelated to the essential functions of the job.

If you wish to identify yourself as a qualified person with a disability under the Americans with Disabilities Act and would like to request an accommodation, please address the request to the Department of Human Resources prior to the recruitment close date. You may request an accommodation during the online application process.

RECRUITING QUESTIONS?

James Callahan, Recruiter

mailto:JCallahan@clackamas.us?subject=RECRUITMENT%20QUESTIONS

To apply, visit https://apptrkr.com/6942275

Copyright ©2025 Jobelephant.com Inc. All rights reserved.

https://www.jobelephant.com/

jeid-7ac38b21c8a1d546b87ea01f203a0364