Data Engineer (Applications Analyst IV-Generalist) Print (https://www.governmentjobs.com/careers/portlandor/jobs/newprint/4555498) Apply Data Engineer (Applications Analyst IV-Generalist) Salary$48.34 - $68.03 HourlyLocation 1120 SW 5th Ave, ORJob TypeRegularJob Number2024-00662BureauBureau of Technology ServicesOpening Date07/01/2024Closing Date7/15/2024 11:59 PM Pacific
Description
Benefits
Questions
The PositionJob Appointment: Regular, Full timeWork 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 (https://www.portland.gov/policies/human-resources-administrative-rules/employee-behavior-expectations/hrar-4045-employee) . Benefits: Please check our benefit tab for an overview of benefit for this positionUnion Representation: This position is represented by Professional Technical Employees, Local 17 (PROTEC17). To view this labor agreement, please click here (https://www.portland.gov/bhr/employee-relations/labor-relations/documents/cop-2022-2025-collective-bargaining-agreement/download) .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 [email protected] To QualifyThe following minimum qualifications are required for this position:
Experience in 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.
Ability to perform data engineering tasks using programming languages including but not limited to Python and SQL on datasets that could include geospatial data.
Experience using Git for version control.
Applicants must also:
Pass a comprehensive police background investigation.
The Recruitment ProcessSTEP 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 (https://www.oregon.gov/boli/workers/pages/equal-pay.aspx) 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.01 (https://www.portland.gov/policies/human-resources-administrative-rules/employment/hrar-301-recruitment-processes) for 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 InformationClick here (https://www.portland.gov/bhr/career-center/recruitment-policy) for additional information regarding the following:
Veteran Preference
ADA, Pregnancy, and Religious Accommodations
Work Status
Equal Employment Opportunity
A Career with the City of Portland offers many Employee BenefitsWe offer a comprehensive benefits package, including but not limited to
Health Care (Medical, Vision and Dental)
Carrot Fertility
Wellness Benefits
Life Insurance
Short- and Long-term disability coverage to eligible employees and their families.
Employee Assistance Plan
Flexible Spending Accounts
Retirement
Oregon Public Employees Retirement System (PERS), including contributions to the PERS IAP plan paid by employer
Family Medical Leave
City Paid Parental Leave
AND SO MANY MORE! Benefits may vary depending on bargaining unit and employment status. Click here to review the many different benefits the City of Portland offers (https://www.portland.gov/bhr/benefit-offerings/benefits-quickstart-guide/benefit-plan-summaries-highlight-guides) .01 Thank you for your interest in joining the team at the City of Portland. We sincerely value your time and hope to make your application experience as positive as possible.Your cover letter, and resume are an important step in the examination and selection process to assist us in determining if you possess the knowledge, skills, and abilities to succeed in the posted vacancy. A lack of a complete and thorough information in your application materials to each of the qualifications listed in the To Qualify section may result in disqualification from the examination. The information you provide must accurately reflect what is documented in your work history/resume.Your cover letter needs to specifically address all of the qualifications listed in the "To Qualify" section, they are required for this position. Please provide detailed examples for each qualification that specifically address the qualification(s). Saying "See resume", to any of the minimum qualifications may result in elimination from further consideration. If you are requesting veterans' preference, please be sure to indicate that you are a veteran and also upload a copy of your DD214 and/or Veteran's administration letter stating your disability. Veteran's preference documentation must be submitted by the closing time of this announcement.Have you read and understood all of the information listed above?
Yes
No
02
Where did you first learn about this job opportunity? (If on a website or job board, please specify which one)
03
The City of Portland receives public records requests at times. Please indicate which response you find appropriate: (Answer will not disqualify you from the process)
My application was submitted with the understanding that the City of Portland would keep the information confidential and would only disclose the information if ordered to do so. I would not have submitted this application without the promise of confidentiality.
You may release my application; I am waiving confidentiality.
Required Question
AgencyCity of PortlandAddress1120 SW 5th Ave, Room 987 Portland, Oregon, 97204 Websitehttp://www.portlandoregon.gov/jobs Apply Please verify your email address Verify Email