Development Analyst

Multnomah County • Portland, OR

2d • Hybrid

About The Position

This position will be a part of the Division of Assessment, Taxation and Recording (DART), within the Department of County Management (DCM). DART strives to ensure the stability and quality of life for our community by providing local government with the revenues necessary to fund essential services. We 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 Assessor’s Office in a manner that is friendly, respectful, resourceful and willing in order to create an environment of safety, trust and belonging for all. The 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.

Requirements

• Bachelor’s 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
• 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 activities involved in the assessment, recording, levying, collection, and disbursement of tax revenue from a taxing authority to 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.

Nice To Haves

• 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

Responsibilities

• 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 SQL as 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

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level