Data Engineer (Applications Analyst Iv-Generalist)

The Position

Job Appointment: Regular, Full time

Work Schedule: Monday - Friday, 8am-5pm. Alternate schedule may be available.

Work Location: This position has an exception to work primarily remote. However, there will be instances when it is necessary to come onsite for work (with advance notice). Remote work must be performed within Oregon or Washington. For more information,click here.

Benefits: Please check our benefit tab for an overview of benefit for this position

Union Representation: This position is represented by Professional Technical Employees, Local 17 (PROTEC17). To view this labor agreement, please clickhere.

The City Council has approved a 3.3% cost of living adjustment (COLA) for all eligible employees of the City of Portland for the fiscal year, effective from July 1, 2024. As a result, the salary for this position may increase due to the approved COLA.

Application Material:Please click APPLY to submit your application via the City of Portland's online portal. You will need to attach a cover letter and resume.

About the Position:

This Data Engineer position within the Bureau of Technology Services will be assigned to the Portland Bureau of Transportation (PBOT) Technology Team. In this role, you'll be helping PBOT drive towards data informed decision making. This role is pivotal in utilizing data at any scale across platforms that exist both on-premises and in the cloud. Your expertise will help create and integrate datasets that assist PBOT with operating efficiently and accurately.

Key Responsibilities:

• Data Pipeline Development: Design, develop, administer, and maintain processes that move and integrate data between systems that are internally or externally hosted using Python, SQL Server, Apache Spark, and PowerShell. Systems include but are not limited to SQL Server, ESRI geodatabases, IBM Maximo, Azure storage, external and internal APIs, and file shares.Guide other team members when developing and maintaining data pipelines.

• Database Administration: Develop database schemas, manage users and roles, perform data maintenance tasks and ad-hoc queries. Optimize queries to increase efficiency and handling of large volumes of data. Manage promotion and testing of changes through deployment environments.

• Data Reporting: Design and develop reports, visualizations, and dashboards using SQL Server Reporting Services, Crystal Reports, and PowerBI. Collaborate with users to understand needs and develop solutions to help them understand and use data.

• Collaboration: Work closely with cross-functional teams including software developers, data analysts, and business system analysts to develop solutions for PBOT. Document data processes, systems, and workflows to ensure transparency and facilitate knowledge sharing.

The Team:

PBOT is dedicated to planning, building, managing, and maintaining an effective and safe transportation system that provides people and business access and mobility. As part of the PBOT Technology Team, you will have the opportunity to contribute to innovative solutions that improve transportation infrastructure and services throughout the city.

We invite candidates who are passionate about leveraging data and technology to drive positive change in transportation. Join us in building a more connected and sustainable future for Portland.

Questions?

Jaclyn Snyder, Senior Recruiter

Bureau of Human Resources

Jaclyn.Snyder@portlandoregon.gov

To Qualify

The following minimum qualifications are required for this position:

• Experiencein software development, database administration, data engineering, or data science with a focus on designing datasets.

• Expert knowledge of data modeling, database design, database administration, data warehousing concepts, and extract-transform-load processes.

• Abilityto perform data engineering tasks using programming languages including but not limited to Python and SQL on datasets that could include geospatial data.

• Experienceusing Git for version control.

Applicants must also:

• Pass a comprehensive police background investigation.

The Recruitment Process

STEP 1: Apply online between

Monday, July 1,2024 - Monday, July 15, 2024

Required Application Materials:

• Resume

• Cover Letter

• Answer to three (3) Supplemental Questions (click on the Questions tab to preview the questions)

Optional Application Materials:

• Veteran documents to request for Veteran Preference (ex, DD214-Member 4, VA Benefit Letter, etc.)

Application Tips:

• Your cover letter should include details describing your education, training and/or experience, and where obtained, which clearly reflects your qualifications for each of the numbered items in the "To Qualify" section of this announcement.

• Your resume should support the details described in your cover letter.

• Salary Range/Equity Pay Analysis: Please note per the Oregon State Pay Equity Law your salary is determined based on the experience and education listed in your resume/application. It is strongly encouraged to include any transferable experience (paid or unpaid regardless of how recent) to ensure your offer is reflective of all directly related and equivalent experience.

• Do not attach materials not requested.

• All completed applications for this position must be submitted no later than on the closing date and time of this recruitment.

• All applications must be submitted via the City's online application process. E-mailed and/or faxed applications will not be accepted.

Step 2: Minimum Qualification Evaluation:Week of July 15, 2024

• An evaluation of each applicant's training and paid and unpaid experience, as demonstrated in their resume and cover letter, weighted 100%.

• Your resume and cover letter will be the basis for our evaluation of your qualifications for this position. Incomplete or inappropriate information may result in disqualification.

• You have 14 days from the notice of the minimum qualification evaluation results to let us know if you like to review and discuss your evaluation result. Please read the

City of Portland Administrative Rule 3.01for complete information.

• Additional evaluation may be required prior to establishment of the eligible list and/or final selection.

Step 3: Establishment of Eligible List:Week of July 22 or July 29, 2024

• Candidates who meet the minimum qualifications will be placed on the equally ranked eligible list.

Step 4: Selection (Interview):August

• Hiring bureau will review and select candidates to interview.

• Please note, the selection process may take up to 90 days from the notification of being placed on the eligible list.

Step 5: Offer of Employment:September

Step 6: Start Date:October

• A start date will be determined after all conditions of employment have been met.

• Timeline is approximate and subject to change*

Additional Information

Click herefor additional information regarding the following:

• Veteran Preference

• ADA, Pregnancy, and Religious Accommodations

• Work Status

• Equal Employment Opportunity