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.

• Advanced knowledge and skill of SQL to write and execute queries to audit, test, and assess validity of data in BI/BW systems and recommend system and/or business process changes to improve data integrity.

Preferred Qualifications/Transferable Skills*:  You do not need to have the following preferred qualifications/transferable skills to qualify. However keep in mind we may consider some or all of the following when identifying the most qualified candidates. Please clearly explain on your application how you meet any of the following preferred qualifications/transferable skills.

• Advanced knowledge or skill in SQL Server T-SQL including queries, stored procedures and views.

• Working knowledge and skill using Azure Cloud tools, including DevOps and Azure Boards, for managing the software development lifecycle and agile development teams.

• Advanced skills in managing multiple concurrent small to medium-sized projects, including demonstrated knowledge of Agile methodology to manage development teams and deliver custom-developed complex business systems.

• Advanced knowledge and skill in providing consulting support to system owners and users requesting technology solutions.

• Advanced knowledge and skill in defining, writing, and executing test cases and testing applications for two purposes: 1) to validate that requirements were met or defects resolved, and 2) for conducting quality assurance and end-user acceptance testing.

• Working knowledge and skill in Security & Privacy Protocols (HIPAA, SSL, User & File Security).

*Transferable skills: Your transferable skills are any skills you have gained through education, work experience (including the military) or life experiences that are relevant for this position. Be sure to describe any transferable skills on your application and clearly explain how they apply to this position.  

Screening and Evaluation:

The Application Packet:

• A completed online application.

• Required: A resume covering relevant experience and education. Please be sure your resume includes the following for each employer: name of employer, location, dates of employment, your title, a brief summary of your responsibilities, the number of employees under your supervision.

• Required: A cover letter that expands on your resume, addresses why you are interested in this position and demonstrates how your experience and skill set align with the minimum and preferred qualifications listed.

Equal Pay Law: Please be advised that the pay range listed for this position is intended to provide general guidance on the earning potential for the role. However, actual compensation will be determined in accordance with the Oregon Equal Pay Law and will take into account factors such as the candidate's relevant experience, education seniority, training, and/or tenure. Candidates should expect that initial offers will be made within the listed pay range and may not be at or near the top of the range.

Note: The application, resume and cover letter should demonstrate your work experience/skills and how it is related to those shown in the Overview, Essential Job Functions and To Qualify sections of the job announcement. Please be thorough, as these materials will be scored and determine your eligibility for an interview.

The Selection Process: For details about how we typically screen applications, review our overview of the selection process page. We expect to evaluate candidates for this recruitment as follows:

• Initial review of minimum qualifications: We may do an additional preferred review and/or send out additional supplemental questions to identify those highest qualified.

• Evaluation of technical knowledge, skills, and abilities: There is a virtual scored evaluation session with the hiring manager to review the required technical skills and knowledge for this position.

• Technical Exam: Allow up to two hours to complete. Some completed online and some in person.

• Consideration of top candidates: We will consider qualified candidates in order of rank and score from the list of eligible candidates. This may include panel interview(s), a hiring interview, and/or additional testing to determine the best candidates for a position.

• Background check and reference checks: All finalists must pass a thorough criminal records check and reference check.

Our Commitment to Safety, Trust and Belonging: Multnomah County is committed to developing, nurturing and continually improving workforce equity by identifying and addressing the structural and policy barriers to equal employment opportunity faced by our employees and communities. County employees across the organization have stepped forward to develop a strategic plan and help create a workplace where everyone can reach their full potential. Learn more by reading our Workforce Equity Strategic Plan and exploring our Core Competencies for all County employees.

ADDITIONAL INFORMATION:

This recruitment may be used to fill full-time

Routine Telework: This position is designated as “routine telework,” meaning you will be working remotely (from home); a hybrid schedule also is available. As with all routine telework positions, employees may be required to come into the office on occasion. The designation of Routine Telework may be subject to change at a future time.

Residency: All employees must reside in Oregon or Washington.

Visa Sponsorship: We are unable to sponsor work visas (H-1B, F-1 OPT, STEM OP).

Type of Position: This is an hourly, AFSCME Local 88 union-represented position and is eligible for overtime.

Location: This location is officially the Multnomah Building, 501 SE Hawthorne Blvd. Suite 400, Portland, Oregon, 97214.  

Schedule: Monday - Friday 8:00am - 4:30pm. There is flexibility with the start and end times. Alternative schedules may be available on request. 

Serving the Public, Even During Disasters

Everyday, Multnomah County staff work together to serve as a safety net for our communities. During a disaster, this safety net becomes even more critical. All County employees have a role in serving the public during inclement weather, natural disaster, or other types of community emergency response. During these emergency responses, while typically there begins with a call for volunteers, county employees may ultimately be reassigned from their current position to a role in the emergency response to support the critical needs presented by our communities. For more information, please visit the Disaster Service Worker Information page.

In accordance with Oregon Law, Multnomah County is not collecting school attendance dates in the initial application process; please do not include these dates in your resume, cover letter and other application materials.

Diversity and Inclusion: At Multnomah County, we don't just accept difference; we value it and support it to create a culture of dignity and respect for our employees.

We are proud to be an Equal Opportunity Employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran or protected veteran status, genetic information and other legally protected characteristics. The EEO Know Your Rights poster is available for your reference. Multnomah County is a VEVRAA Federal Contractor. We request priority protected veteran referrals.

Veterans’ Preference: Under Oregon Law, qualifying veterans may apply for veterans’ preference. Review our veterans’ preference page for details about eligibility and how to apply.

Accommodation under the Americans with Disabilities Act: We gladly provide reasonable accommodation to anyone whose specific disability prevents them from completing an application or participating in this recruitment process. Please contact the recruiter below in advance to request assistance. Individuals with hearing or speech impairments may contact the recruiter through the Telecommunications Relay Service by dialing 711.

Questions?

Recruiter:

Allison Conkling

Email:

allison.conkling@multco.us

Phone:

+1 (503) 2604572

Application information may be used throughout the entire selection process. This process is subject to change without notice.

Disclaimer: This announcement is intended as a general descriptive recruitment guide and is subject to change. It does not constitute either an expressed or implied contract.

Job Profile:

6055 - Business Systems Analyst Senior