Senior Business System Analyst

Current employees: Please apply through the employee portal to be considered for this opportunity.

Pay Range:

$60.61 - $74.55 Hourly

Department:

Department of County Assets (DCA)

Job Type:

Regular Represented

Exemption Status:

United States of America (Non-Exempt)

Closing Date (Open Until Filled if No Date Specified):

May 03, 2026

The Opportunity:

Please note: This recruitment will close once 150 applications are received. 

Overview

Join Our Team

Multnomah County’s Office of Information Technology is one of the most innovative government IT groups in the nation. We stay ahead of industry trends while fostering an inclusive, and diverse environment. We are a team of creative and talented people who believe our strength comes from our different backgrounds and perspectives.

Who You Are

 You are a data-focused professional with extensive experience and knowledge of business intelligence technology, methodologies, tools and processes who loves solving complex problems. You have the technical "know-how" to handle big data projects and the people skills to build strong partnerships. You are a bridge-builder who can talk to software developers, vendors, and department leaders to ensure our technology truly serves the community. You are forward-thinking, collaborative, and ready to lead. 

What You’ll Do

As a Senior Business System Analyst on our Health Portfolio Team, you will help us turn data into meaningful tools for public health. In this role, you will:

• Partner with Department Data and Analytics teams to manage the intake of customer demand for IT data projects and services.

• Manage agile development teams (customers, peers, engineers and developers) to deliver small to medium projects.

• Develop a thorough understanding of the existing IT BI tools and platforms and apply to specific customer business problems.

• Translate business needs into clear requirements and collaborate with Application and Data Services teams to design solutions.

• Understand customer’s usage and desired outcomes from their data and capture complex business rules for data transformation, calculations, and schema design.

• Support transition of existing on-prem SQL Data Marts to Snowflake and implementation of new warehouses in Snowflake.

• Document requirements and specifications, and perform testing for development of ETL/ELT pipelines.

• Use SQL to perform data analysis, validation, and testing of SQL database and Snowflake objects and stored procedures.

• Develop technical documentation including data dictionaries, data flows, business rules, and other important BI metadata.

• Provide customer support and enablement, incident resolution, and operational maintenance support. 

To Qualify

We will consider any combination of relevant work experience, volunteering, education, and transferable skills as qualifying unless an item or section is labeled required. Please be clear and specific about how your background is relevant.

Minimum Qualifications/Transferable Skills*:

• Bachelor's degree (in lieu of degree, equivalent years of experience will be considered)

             AND 

• 3 years of experience that demonstrates the ability to perform the duties of the position. (Equivalency 7 years of qualifying training and/or experience).

• Ability to pass a criminal records check.

• You must have the Specific knowledge, Skills and Abilities (KSAs) listed below.

Specific knowledge, skills and abilities (KSAs) required for this role:

• Advanced knowledge and skill in business intelligence technologies such as data integration, data quality, data warehousing, and data analytics.

• Advanced knowledge and skill capturing and documenting requirements, business rules, and specifications for design of business intelligence/business warehouse (BI/BW) solutions.

• Advanced knowledge and skill of reporting features in tools such as Tableau, SQL Server Reporting Services, Snowflake, and Power BI.