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 . Clackamas County Core Values

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 experience to apply.

Who May Apply

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.

CLOSE DATE

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

Pay And Benefits

Annual Pay Range: $ 91,032.83 - $ 115,249.47

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.

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! 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.

Employees' Association (EA) Full Time Benefits

Learn More About Benefits

JOB DETAILS AND QUALIFICATIONS

Clackamas County's Department of Technology Services seeks a data-driven problem-solver passionate about healthcare for vulnerable populations and skilled at transforming complex information into actionable insights. The Business Intelligence (BI) Developer and Analyst will play a vital role in designing, developing, and implementing data solutions that support informed decision-making and improve operational outcomes throughout Clackamas Health Centers. This position requires a strong analytical mindset, technical expertise, and a commitment to collaboration in a dynamic public service environment.

The BI Developer and Analyst will work closely with stakeholders across the Health Centers to gather and interpret business needs, then translate those requirements into efficient, scalable business intelligence solutions. The individual in this role will design and develop Extract, Transform, Load (ETL) processes to integrate data from Electronic Health Record (EHR) systems into the enterprise data warehouse. They will construct and optimize complex SQL queries and stored procedures to ensure data accuracy and performance, while also developing and maintaining dashboards and reports using tools such as Power BI. Additional responsibilities include documenting workflows and data definitions, coordinating testing and production schedules, and training staff in the use of new systems and reporting tools. The BI Developer and Analyst will contribute technical expertise to broader systems design and project planning efforts, participate in forums and stakeholder meetings, and help identify process improvement and innovation opportunities.

The ideal candidate will bring significant experience in writing and optimizing SQL queries and demonstrated proficiency in business intelligence tools and data visualization techniques. A deep understanding of ETL development and data integration from complex systems is essential, particularly in a healthcare or regulatory context. This individual will possess strong communication skills and the ability to present technical information clearly to both technical and non-technical audiences. Familiarity with data governance, compliance reporting, and healthcare information systems will further support success in this role.

Apply today to join a forward-thinking team that's leveraging technology to build a healthier community.

Required Minimum Qualifications/ Transferrable Skills:*

• A minimum of five (5) years of related experience in business intelligence development, systems analysis, or data analytics, including significant experience developing complex SQL queries and stored procedures that would provide the required knowledge and skills to perform the responsibilities of this position
• Experience and proficiency with designing, developing, and supporting BI tools such as Power BI, Tableau, or similar platforms
• Experience gathering and analyzing business requirements, translating them into technical specifications, and delivering reporting solutions
• Proficiency in designing and maintaining ETL processes using industry-standard tools and methodologies such as SSIS, ADF or similar
• Proficiency in SQL for designing, optimizing, and managing relational databases to support data analysis and reporting.
• Strong understanding of relational databases, data modeling, and performance optimization
• Ability to communicate technical concepts clearly and effectively to both technical and non-technical stakeholders
• Ability to work early and late hours to meet timelines, provide off-hour upgrade and maintenance, and respond to emergency situations
  
  

Preferred Special Qualifications/ Transferrable Skills:*

• Experience working with Electronic Health Records (EHR) systems, especially within Federally Qualified Health Centers (FQHCs) or similar healthcare environments
• Familiarity with the OCHIN network or Epic EHR system
• Prior experience supporting public sector, healthcare, or nonprofit organizations with regulatory and compliance reporting
• Knowledge of data governance practices, HIPAA compliance, and health informatics
• Experience with data warehouse architecture and tools such as Data Bricks, Azure SQL Database or Azure Synapse.
• Demonstrated ability to lead or contribute to cross-functional project teams
  
  

Pre-Employment Requirements

• Must pass a criminal history check which may include national or state fingerprint records check
• For Veterans qualified for Veteran’s 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 Health Centers' stakeholders to determine business requirements, then analyze, design, develop, and maintain reports and data extracts needed for the monitoring and operation of the health care clinics, as well as report to various internal and external stakeholders.
• Develop complex SQL queries and stored procedures to efficiently extract, transform, and load data from Health Centers' EHR, ensuring accurate reporting. Collaborate with Data Warehouse Developers to design and implement ETL processes that seamlessly integrate data into the data warehouse.
• Utilize appropriate software tools and techniques to analyze systems, design logical solutions, and develop and maintain Business Intelligence (BI) dashboards and applications.
• Develop detailed design specifications, definitions, flow charts, diagrams, performance criteria, and testing methods; write, develop, and document operational procedures for data elements and sources; coordinate systems maintenance, testing, and production runs; devise schedules for implementation; and provide training and technical guidance to users and staff in the use of new or modified systems and procedures.
• Provide technical expertise to Health Centers' projects in determining technology needs, purchasing or building systems to meet those needs, and overall systems design, building, testing, and implementation of the various components.
• Participate in meetings, forums, webinars, etc., with Health Centers' personnel and outside entities to advise on the impacts of changes and identify opportunities for improvement and efficiency.
• Develop business requirements, coordinate between end users and OCHIN as needed, and validate the results.
  
  

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 position is eligible for hybrid on-site/telework subject to the Clackamas County Teleworking Policy and based on the Department’s business needs. The exact amount of on-site/telework and schedule will be discussed with the hiring manager during time of offer. Telework locations cannot be located outside of Oregon or Washington. 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.

• Explore Clackamas County
• Working for Clackamas County
• Recreation, Arts & Heritage
  
  

About The Department

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

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.

Along with this, 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 on-going training; improve and upgrade our computer systems, both software and hardware, whenever feasible; and implement county-wide

technical standards to ensure compliance.

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

Learn more about Clackamas County Technology Services

APPLICATION PROCESS

Clackamas County only accepts online applications.

Help With Your Application

• Application Process
• Help with the Application
  
  

If you have any questions or issues you may contact the Department of Human Resources at 503-655-8459 or e-mail us . 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

• Request Veterans' Preference
• Learn more about the County's Veterans' Preference
  
  

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 OPPORTUNIT Y

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

[email protected]