Business Intelligence (BI) Developer and Analyst
Job ID: 107919
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 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.
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.
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.
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.
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 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
To apply, visit https://apptrkr.com/6238763
jeid-4da8a7a541198047bfa69cfd6d915791