King County
Salary:
$155,074.19 - $196,565.41 Annually Location :
Seattle, WA Job Type:
Career Service, Full Time, 40 hrs/week Job Number:
2025BM24988 Department:
DES - Executive Services Division:
Business Resource Center Opening Date:
08/01/2025 Closing Date:
8/15/2025 11:59 PM Pacific FLSA:
Exempt Bargaining Unit:
C19 : PROTEC17-Information Tech Full- or Part-Time:
Full Time Hours/Week:
40 hours/week
Summary This recruitment is open to King County Employees only.
King County Business Resource Center (BRC) is seeking a Data Solutions Architect to join our team! The Data Solutions Architect is a member of the BRC Business Intelligence (BI) Insights team. This role provides leadership, design, and consultation to continuously improve data platforms, delivering business value, and supporting essential business functionality. This role concentrates on data analytics, data warehousing, and other domain specific areas to be defined. ABOUT THE BUSINESS RESOURCE CENTER OVERVIEW The BRC oversees King County's business systems, which include applications, infrastructure, software, and vendor relationships. The team also supports business processes, system governance, and work prioritization to effectively serve county agencies. BRC Director's Office: This team provides guidance to the BRC and advises county leaders on strategies to enhance the county's ERP business systems. They also manage the day-to-day operations of the BRC in support of continuous improvement and a cohesive team approach to govern, manage and support the county's ERP systems. BI Insights Team: This team specializes in developing and managing business intelligence analytics across our suite of Oracle ERP applications and SAP Concur. This team also collaborates and works closely with our business partners and county departments to deliver meaningful analytics in support of county business operations. The team is committed to expanding the use of analytics tools and enhancing ERP data governance across the county. Financials and Procurement Team: This team specializes in Oracle EBS Financials and Procurement, Oracle Procurement Cloud and Supplier Cloud, and SAP Concur travel systems. The team collaborates with our business partners and county departments to deliver finance, procurement, travel expense and treasury services across all county business operations. HR and Payroll System Team: This team specializes in PeopleSoft HR, payroll, and retirement systems, collaborating with our business partners and county departments to deliver HR, benefits, and payroll services across all county business operations. Shared Services Team: This team specializes in training, change management, and help desk support, along with system security, administration, and licensing. There is also a highly skilled and technical team of DBAs who manage day to day running and performance of the systems in Oracle Cloud Infrastructure as well as coordination of system updates and patches. What people have said about working in the Business Resource Center.
"The Business Resource Center provides an environment with highly diverse work groups and business partners, offering opportunities for professional growth and challenges, learning new skills and the latest technology and applications." "Employee ideas and contributions are highly valued and supported by supervisors and managers, and employees are able to offer solutions to issues that can be brought before business partners and stakeholders." "Employees have the freedom to manage their own workload, which is both challenging and rewarding. Work involves not only resolving issues and finding the root cause of problems, but also interacting directly with business partners and experiencing the positive feedback of their appreciation." "The job is constantly evolving, providing new professional challenges and opportunities for growth, and this comes with a supportive environment with others around you who are rooting for your success as much as their own."
Job Duties To be considered for this opportunity , you must at a minimum, demonstrate the knowledge, skill, and ability to: Maintain, Upgrade, and Expand Enterprise Data Warehouse (EDW) and Analytics Capabilities. Perform System Administration of Oracle Analytics Server (OAS), Oracle Business Intelligence Applications (OBIA), Oracle BI Publisher, and Oracle Data Integrator (ODI) on Linux Servers working closely with the BI Insights Oracle Database Administrator (DBA). Perform hands-on development of OBIA based EDW analytics and BI Publisher solutions. Provide technical leadership and architectural guidance to develop scalable, secure, and sustainable data platforms that support governance, analytics, and integration needs. Design and implement end-to-end data analytics solutions across Finance, Procurement, Budget, and Human Resources domains, aligning with business requirements and operational goals. Analyze source systems and enhances existing data platforms by designing and building new data repositories, including operational data stores, data warehouses, and data lakes. Lead hands-on development and prototyping efforts, while identifying opportunities to incorporate advanced technologies such as Machine Learning and Artificial Intelligence into BI analytics solutions. Coordinate across cross-functional teams to align business requirements with technical deliverables, ensuring data structures and services support the BI Insights development lifecycle. Serve as a mentor and technical lead, fostering team growth through skill-building opportunities and collaborative project execution, while promoting King County's values. Develop and maintain key data architecture assets-including data models, flows, dictionaries, and ETL logic-ensuring data integrity, security classification, and appropriate access controls. Assist with Architecture solutions and present them in review forums. Experience, Qualifications, Knowledge, Skills We are looking for candidates who:
Extensive leadership in
enterprise data warehouse and analytics solutions using Oracle Business Intelligence Applications (OBIA), Oracle Analytics Server (OAS) or cloud (OAC), and Oracle Data Integrator (ODI), including system administration on Unix/Linux platforms. Advanced expertise in
Oracle Analytics RPD (or Semantic Modeler) design, development, and deployment, with strong data modeling skills across conceptual, logical, and physical schemas. Proven success in
implementing, customizing, and optimizing OBIA data flows and transformations, including modifying mappings, models, and load plans within Oracle Data Integrator (ODI). Strategic contributor in
data analysis, data profiling, data quality assurance, and data integration across enterprise data warehouse platforms. Demonstrated leadership in
developing high-performance dashboards, complex visualizations, and query optimization techniques using Oracle SQL, PL/SQL, and Oracle BI Publisher. Demonstrated ability to
analyze and design solutions grounded in a deep understanding of Oracle ERP data sources such as Oracle E-Business Suite (EBS) and PeopleSoft. Extensive leadership in
gathering requirements, managing agile development cycles, and collaborating effectively with both business stakeholders and technical teams to deliver data-driven solutions. Advanced expertise in
cross-functional communication and stakeholder engagement, with the ability to translate technical concepts for business audiences and influence decision-makers. Proven success in
applying data security, privacy, and risk management best practices, with working knowledge of complementary tools such as Oracle APEX, Power BI, and Oracle Cloud Infrastructure (OCI). Supplemental Information WORK LOCATION:
The work associated with this position will be performed by teleworking, field work, onsite work and meetings as needed for up to 3 times a week, but onsite work may involve additional days depending on the business needs. Employees must reside in Washington state and within a reasonable distance to their King County worksite to respond to workplace reporting requirements.
WORK SCHEDULE:
This position is Exempt from the provisions of the Fair Labor Standards Act and therefore is not overtime eligible. Employees are paid on a bi-weekly schedule, every other Thursday.
UNION REPRESENTATION:
This position is represented by Protec17: Information Technology
SUPPLEMENTAL INFORMATION:
The successful candidate will be required to pass a thorough background and reference check.
Are you ready to APPLY?
The recruitment for this position is open to
ONLY King County Employees . A completed King County Application is required.
We highly recommend that you also provide a resume and cover letter.
This recruitment is an effort to fill our immediate vacancies as well as create a hire list that will be used for any positions that become vacant within the next 6 months. If you have any questions, please contact
Brittney Marzest , by e-mail at
Forbes named King County as one of Washington State's best employers. Together, with leadership and our employees, we're changing the way government delivers service and winning national recognition as a model of excellence. Are you ready to make a difference?
Come join the team
dedicated to serving one of the nation's best places to live, work and play.
Guided by our , we are making King County a welcoming community where every person can thrive. We value diversity, inclusion and belonging in our workplace and workforce. To reach this goal we are committed to workforce equity. Equitable recruiting, support, and retention is how we will obtain the highest quality workforce in our region; a workforce that shares and will help advance our guiding principles - we are one team; we solve problems; we focus on the customer; we drive for results; we are racially just; we respect all people; we lead the way; and we are responsible stewards. We encourage people of all backgrounds and identities to apply, including Native American and people of color, immigrants, refugees, women, LGBTQ+, people living with disabilities, and veterans. King County is an Equal Employment Opportunity (EEO) Employer
No person is unlawfully excluded from employment opportunities based on race, color, religion, national origin, sex (including gender identity, sexual orientation and pregnancy), age, genetic information, disability, veteran status, or other protected class. Our EEO policy applies to all employment actions, including but not limited to recruitment, hiring, selection for training, promotion, transfer, demotion, layoff, termination, rates of pay or other forms of compensation. King County offers a highly-competitive compensation and benefits package designed to meet the diverse needs of our employees and support our employees' health and well-being. Eligible positions receive the following benefits and have access to the following programs:
Excellent medical, dental, and vision coverage options: King County provides eligible employees with options, so they can decide what's best for themselves and their eligible dependents Life and disability insurance: employees are provided basic coverage and given the opportunity to purchase additional insurance for both the employee and eligible dependents Retirement: eligible King County employees may participate in a pension plan through the Washington State Department of Retirement Systems and a 457(b) deferred-compensation plan Transportation program and ORCA transit pass 12 paid holidays each year plus two personal holidays Generous vacation and paid sick leave Paid parental, family and medical, and volunteer leaves Flexible Spending Account Wellness programs Onsite activity centers Employee Giving Program Employee assistance programs Flexible schedules and telecommuting options, depending on position Training and career development programs For additional information about employee benefits, visit our
This is a general description of the benefits offered to eligible King County employees, and every effort has been made to ensure its accuracy. If any information on this document conflicts with the provisions of a collective bargaining agreement (CBA), the CBA prevails.
NOTE:
Benefits for Term Limited Temporary (TLT) or Short Term Temporary (STT) positions, including leave eligibility and/or participation in the pension plan through the Washington State Department of Retirement Systems, will vary based upon the terms and details of the position. Short Term Temporary positions are not eligible for an ORCA transit pass.
For inquiries about the specifics of this position, please contact the recruiter identified on this job posting. 01
Are you applying to this position as an eligible current or previous King County Employee Priority Placement Program Participant? ANDIs this position the same or lower percentage of full-time when compared to the position held at the point of the notification of layoff? ANDDo you possess the skills and abilities to qualify for this position?
Yes, I was given a layoff notice from my Career Service role at King County and I am within two years of the effective date of my layoff. Additionally, the position I was laid off from was the same or a higher percentage of FT status when compared to this one. No.
02
If you answered yes to the question above and you are applying for this position as a Priority Placement Participant, to be considered, you must provide the following three pieces of information in the space provided:1. The title you held when you received your layoff notice2. The department you worked in3. The effective date of your layoff Required Question
$155,074.19 - $196,565.41 Annually Location :
Seattle, WA Job Type:
Career Service, Full Time, 40 hrs/week Job Number:
2025BM24988 Department:
DES - Executive Services Division:
Business Resource Center Opening Date:
08/01/2025 Closing Date:
8/15/2025 11:59 PM Pacific FLSA:
Exempt Bargaining Unit:
C19 : PROTEC17-Information Tech Full- or Part-Time:
Full Time Hours/Week:
40 hours/week
Summary This recruitment is open to King County Employees only.
King County Business Resource Center (BRC) is seeking a Data Solutions Architect to join our team! The Data Solutions Architect is a member of the BRC Business Intelligence (BI) Insights team. This role provides leadership, design, and consultation to continuously improve data platforms, delivering business value, and supporting essential business functionality. This role concentrates on data analytics, data warehousing, and other domain specific areas to be defined. ABOUT THE BUSINESS RESOURCE CENTER OVERVIEW The BRC oversees King County's business systems, which include applications, infrastructure, software, and vendor relationships. The team also supports business processes, system governance, and work prioritization to effectively serve county agencies. BRC Director's Office: This team provides guidance to the BRC and advises county leaders on strategies to enhance the county's ERP business systems. They also manage the day-to-day operations of the BRC in support of continuous improvement and a cohesive team approach to govern, manage and support the county's ERP systems. BI Insights Team: This team specializes in developing and managing business intelligence analytics across our suite of Oracle ERP applications and SAP Concur. This team also collaborates and works closely with our business partners and county departments to deliver meaningful analytics in support of county business operations. The team is committed to expanding the use of analytics tools and enhancing ERP data governance across the county. Financials and Procurement Team: This team specializes in Oracle EBS Financials and Procurement, Oracle Procurement Cloud and Supplier Cloud, and SAP Concur travel systems. The team collaborates with our business partners and county departments to deliver finance, procurement, travel expense and treasury services across all county business operations. HR and Payroll System Team: This team specializes in PeopleSoft HR, payroll, and retirement systems, collaborating with our business partners and county departments to deliver HR, benefits, and payroll services across all county business operations. Shared Services Team: This team specializes in training, change management, and help desk support, along with system security, administration, and licensing. There is also a highly skilled and technical team of DBAs who manage day to day running and performance of the systems in Oracle Cloud Infrastructure as well as coordination of system updates and patches. What people have said about working in the Business Resource Center.
"The Business Resource Center provides an environment with highly diverse work groups and business partners, offering opportunities for professional growth and challenges, learning new skills and the latest technology and applications." "Employee ideas and contributions are highly valued and supported by supervisors and managers, and employees are able to offer solutions to issues that can be brought before business partners and stakeholders." "Employees have the freedom to manage their own workload, which is both challenging and rewarding. Work involves not only resolving issues and finding the root cause of problems, but also interacting directly with business partners and experiencing the positive feedback of their appreciation." "The job is constantly evolving, providing new professional challenges and opportunities for growth, and this comes with a supportive environment with others around you who are rooting for your success as much as their own."
Job Duties To be considered for this opportunity , you must at a minimum, demonstrate the knowledge, skill, and ability to: Maintain, Upgrade, and Expand Enterprise Data Warehouse (EDW) and Analytics Capabilities. Perform System Administration of Oracle Analytics Server (OAS), Oracle Business Intelligence Applications (OBIA), Oracle BI Publisher, and Oracle Data Integrator (ODI) on Linux Servers working closely with the BI Insights Oracle Database Administrator (DBA). Perform hands-on development of OBIA based EDW analytics and BI Publisher solutions. Provide technical leadership and architectural guidance to develop scalable, secure, and sustainable data platforms that support governance, analytics, and integration needs. Design and implement end-to-end data analytics solutions across Finance, Procurement, Budget, and Human Resources domains, aligning with business requirements and operational goals. Analyze source systems and enhances existing data platforms by designing and building new data repositories, including operational data stores, data warehouses, and data lakes. Lead hands-on development and prototyping efforts, while identifying opportunities to incorporate advanced technologies such as Machine Learning and Artificial Intelligence into BI analytics solutions. Coordinate across cross-functional teams to align business requirements with technical deliverables, ensuring data structures and services support the BI Insights development lifecycle. Serve as a mentor and technical lead, fostering team growth through skill-building opportunities and collaborative project execution, while promoting King County's values. Develop and maintain key data architecture assets-including data models, flows, dictionaries, and ETL logic-ensuring data integrity, security classification, and appropriate access controls. Assist with Architecture solutions and present them in review forums. Experience, Qualifications, Knowledge, Skills We are looking for candidates who:
Extensive leadership in
enterprise data warehouse and analytics solutions using Oracle Business Intelligence Applications (OBIA), Oracle Analytics Server (OAS) or cloud (OAC), and Oracle Data Integrator (ODI), including system administration on Unix/Linux platforms. Advanced expertise in
Oracle Analytics RPD (or Semantic Modeler) design, development, and deployment, with strong data modeling skills across conceptual, logical, and physical schemas. Proven success in
implementing, customizing, and optimizing OBIA data flows and transformations, including modifying mappings, models, and load plans within Oracle Data Integrator (ODI). Strategic contributor in
data analysis, data profiling, data quality assurance, and data integration across enterprise data warehouse platforms. Demonstrated leadership in
developing high-performance dashboards, complex visualizations, and query optimization techniques using Oracle SQL, PL/SQL, and Oracle BI Publisher. Demonstrated ability to
analyze and design solutions grounded in a deep understanding of Oracle ERP data sources such as Oracle E-Business Suite (EBS) and PeopleSoft. Extensive leadership in
gathering requirements, managing agile development cycles, and collaborating effectively with both business stakeholders and technical teams to deliver data-driven solutions. Advanced expertise in
cross-functional communication and stakeholder engagement, with the ability to translate technical concepts for business audiences and influence decision-makers. Proven success in
applying data security, privacy, and risk management best practices, with working knowledge of complementary tools such as Oracle APEX, Power BI, and Oracle Cloud Infrastructure (OCI). Supplemental Information WORK LOCATION:
The work associated with this position will be performed by teleworking, field work, onsite work and meetings as needed for up to 3 times a week, but onsite work may involve additional days depending on the business needs. Employees must reside in Washington state and within a reasonable distance to their King County worksite to respond to workplace reporting requirements.
WORK SCHEDULE:
This position is Exempt from the provisions of the Fair Labor Standards Act and therefore is not overtime eligible. Employees are paid on a bi-weekly schedule, every other Thursday.
UNION REPRESENTATION:
This position is represented by Protec17: Information Technology
SUPPLEMENTAL INFORMATION:
The successful candidate will be required to pass a thorough background and reference check.
Are you ready to APPLY?
The recruitment for this position is open to
ONLY King County Employees . A completed King County Application is required.
We highly recommend that you also provide a resume and cover letter.
This recruitment is an effort to fill our immediate vacancies as well as create a hire list that will be used for any positions that become vacant within the next 6 months. If you have any questions, please contact
Brittney Marzest , by e-mail at
Forbes named King County as one of Washington State's best employers. Together, with leadership and our employees, we're changing the way government delivers service and winning national recognition as a model of excellence. Are you ready to make a difference?
Come join the team
dedicated to serving one of the nation's best places to live, work and play.
Guided by our , we are making King County a welcoming community where every person can thrive. We value diversity, inclusion and belonging in our workplace and workforce. To reach this goal we are committed to workforce equity. Equitable recruiting, support, and retention is how we will obtain the highest quality workforce in our region; a workforce that shares and will help advance our guiding principles - we are one team; we solve problems; we focus on the customer; we drive for results; we are racially just; we respect all people; we lead the way; and we are responsible stewards. We encourage people of all backgrounds and identities to apply, including Native American and people of color, immigrants, refugees, women, LGBTQ+, people living with disabilities, and veterans. King County is an Equal Employment Opportunity (EEO) Employer
No person is unlawfully excluded from employment opportunities based on race, color, religion, national origin, sex (including gender identity, sexual orientation and pregnancy), age, genetic information, disability, veteran status, or other protected class. Our EEO policy applies to all employment actions, including but not limited to recruitment, hiring, selection for training, promotion, transfer, demotion, layoff, termination, rates of pay or other forms of compensation. King County offers a highly-competitive compensation and benefits package designed to meet the diverse needs of our employees and support our employees' health and well-being. Eligible positions receive the following benefits and have access to the following programs:
Excellent medical, dental, and vision coverage options: King County provides eligible employees with options, so they can decide what's best for themselves and their eligible dependents Life and disability insurance: employees are provided basic coverage and given the opportunity to purchase additional insurance for both the employee and eligible dependents Retirement: eligible King County employees may participate in a pension plan through the Washington State Department of Retirement Systems and a 457(b) deferred-compensation plan Transportation program and ORCA transit pass 12 paid holidays each year plus two personal holidays Generous vacation and paid sick leave Paid parental, family and medical, and volunteer leaves Flexible Spending Account Wellness programs Onsite activity centers Employee Giving Program Employee assistance programs Flexible schedules and telecommuting options, depending on position Training and career development programs For additional information about employee benefits, visit our
This is a general description of the benefits offered to eligible King County employees, and every effort has been made to ensure its accuracy. If any information on this document conflicts with the provisions of a collective bargaining agreement (CBA), the CBA prevails.
NOTE:
Benefits for Term Limited Temporary (TLT) or Short Term Temporary (STT) positions, including leave eligibility and/or participation in the pension plan through the Washington State Department of Retirement Systems, will vary based upon the terms and details of the position. Short Term Temporary positions are not eligible for an ORCA transit pass.
For inquiries about the specifics of this position, please contact the recruiter identified on this job posting. 01
Are you applying to this position as an eligible current or previous King County Employee Priority Placement Program Participant? ANDIs this position the same or lower percentage of full-time when compared to the position held at the point of the notification of layoff? ANDDo you possess the skills and abilities to qualify for this position?
Yes, I was given a layoff notice from my Career Service role at King County and I am within two years of the effective date of my layoff. Additionally, the position I was laid off from was the same or a higher percentage of FT status when compared to this one. No.
02
If you answered yes to the question above and you are applying for this position as a Priority Placement Participant, to be considered, you must provide the following three pieces of information in the space provided:1. The title you held when you received your layoff notice2. The department you worked in3. The effective date of your layoff Required Question