Development Analyst

This is an internal job posting. Only former Multnomah County employees on an active recall list may apply for this opportunity through this site.

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

Pay Range:

Department:

Job Type:

Exemption Status:

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

The Opportunity:

Overview

Are you passionate about software and solving its most complex issues Do you love to analyze data for the purpose of enhancement and improvement Are you skilled at designing developing testing maintaining and interpreting complex reports and studies. Then look no further!

DARTs Development Analyst works independently and takes the lead in evaluating how data assets and applications relate to business processes within the Division and making recommendations and plans to maintain and/or improve technical and analytical support for all critical functions across the Division. This includes investigating and resolving complex data related issues conducting data analysis and preparing reports and visualizations to assist senior management with decision making. The position is also responsible for planning designing developing testing deploying maintaining interpreting and documenting varied and complex data reports and studies for various units in the division.

Responsibilities:

This is not intended to be an all-inclusive list of responsibilities or job description

• Collaborate with Management and functional team to translate DART business/user needs into actionable analytics such as visualizations reports and studies by utilizing a variety of hardware and software

• Coordinate technical tasks through all phases of the software development lifecycle developing and overseeing project work plans programming routines and manage our code base using version control software

• Serve as project or technical lead

• Fully automate reporting deliverables using various technologies such as stored procs sql jobs and SSRS clients like Report Builder

• Perform and analyze advanced statistical studies and research on a broad range of assessment and taxation related assignments

• Analyze information needs to assist in determining appropriate system implementation design input and output documents design and prepare system audits using SQLas well as research solutions to potential data quality issues using SQL scripting or other business intelligence tools

• Perform data audits review and validation to ensure data integrity

• Extract complex data from internal databases to provide customized ad-hoc reports and data visualizations as requested by management

• Support the design preparation and distribution of property tax and delinquent statements

• Manage all aspects of the mandated tax roll functions including: maintenance security training troubleshooting documentation etc.

• Prepare and maintain data dictionaries models and general BI systems documentation

• Project manage and participate as necessary; provide consultation on design related to new software and hardware planning design testing rollout and process improvement projects

Ideal Attributes:

• Demonstrate a strong commitment to providing an inclusive and equitable experience to those you work with and those you support

• Ability to frequently exercise independent professional judgment in designing developing managing and interpreting complex reports and studies

• Passionate about quality improvement

Who we are and what we do:

This position will be a part of the Division of Assessment Taxation and Recording (DART) within the Department of County Management (DCM). In the DCM the public service we carry out is essential to the operation of Multnomah County as a government as well as an employer. DART strives to ensure the stability and quality of life for our community by providing local government with the revenues necessary to fund essential pride ourselves on providing reliable responsive personal service to the public and our co-workers. As a team we are committed to being good stewards of public resources while creating a safe and inclusive environment for employees customers and the communities we serve.

The primary role of DART staff members is to carry out the functions of the Assessors Office in a manner that is friendly respectful resourceful and willing in order to create an environment of safety trust and belonging for all.

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*:

• Bachelors degree; experience may substitute for a degree

• Two (2) years of experience in Extraction Transformation and Loading (ETL) of data software optimization or related experience that demonstrates the ability to perform the duties of the position

• Ability to pass a background check

• Special Knowledge Skills Abilities (KSA):

  • Intermediate knowledge of and skills applying the principles and procedures of property appraising and mass appraisal practices.

  • Knowledge of the property tax program in the State of Oregon including Oregon Revised Statutes and Administrative Rules that apply to assessment appraisal and taxation. Basic understanding and experience in the interpretation of Department of Revenue statutes and rules governing the activitiesinvolvedin theassessment recording levyingcollectionand disbursement of taxrevenuefrom a taxing authorityto local taxing districts.

  • Intermediate experience in a specialized programming language for storing retrieving and manipulating data in a database management system preferably knowledgeable in Structured Query Language (SQL).

  • Intermediate experience performing complex data analysis and the creation of complex queries and reports based on DART business needs while ensuring integrity reliability and relevancy of data.

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.

• Degree in Data Science Math Business or related field

• Proven experience with SQL VBA SSRS data mining and reporting

• Ability to work independently performing deep work and deliver projects

• Ability to research analyze synthesize and summarize complex Assessment and Taxation (A&T) data

*Transferable skills: Your transferable skills are any skills you have gained through education work experience (including the military) or life experience 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: Your completed application must include the following items:

• A completed online application.

• A resume that contains your 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 and if applicable the number of employees under your supervision.

• A cover letter that expands on your resume and addresses

  • why you are interested in this position and;

  • demonstrates how your experience and skill set aligns with the minimum and preferred qualifications listed.

Note: The application resume and cover letter should demonstrate your work experience/skills and how it is related to those shown in the Overview and To Qualify sections of the job announcement. Please be thorough addressing how you meet the minimum and any preferred qualification listed as these materials may be scored and determine if you move forward in the process.

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 phone screen and/or send out additional supplemental questions to identify those highest qualified.

• 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 reference checks and some departments may require a criminal records check.

Additional Details

This recruitment may be used to fill full-time part-time temporary limited duration and on-call positions.

Type of Position: This is an hourly represented position that is eligible for overtime.

Schedule: Monday - Friday; There may be some flexibility with scheduling and daily start and end times.

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. All employees must reside in Oregon or Washington; the county cannot support ongoing telework from other locations. The onsite work location for this position is 501 SE Hawthorne Blvd Portland OR 97214.

Multnomah County offers an exceptional benefits package including employer-funded retirement savings; health and dental insurance at very low cost to full-time employees and their dependents; paid parental leave; wellness programs; a focus on work-life balance; and much more. Find more details on our benefits website.

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 candidates relevant experience and education. 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.

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 in order 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 dont 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:

Email:

Phone:

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: