Job Information
Trimet Senior Data Engineering Analyst in United States
Senior Data Engineering Analyst
Print (https://www.governmentjobs.com/careers/trimet/jobs/newprint/4669426)
Apply
Senior Data Engineering Analyst
Salary
See Position Description
Location
Suite 700, OR
Job Type
Non-Union Regular Full-Time
Job Number
24-00198
Department
Transit Systems and Asset Support
Opening Date
09/24/2024
Closing Date
Continuous
Description
Benefits
Description
The Senior Data Engineering Analyst coordinates data processes, scripts, and outputs from a variety of databases, internal applications, and other sources to deliver routine critical reporting on maintenance and transportation operations. Under supervision of the Manager of Service Performance and Analysis, develop and maintain data pipelines that automate processing of raw operations data into intermediate, aggregated, or summarized forms to be used in reporting and deeper analysis using database ETL processes, automated scripts, and other data management software tools. Produce and maintain standards and best practices for operations analysis reporting and development.
This role requires being in the office a minimum of four (4) days per week.
Ensure a commitment to safety and regulatory compliance through effective leadership, training, role modeling and implementing practices that demonstrate safety is a fundamental value and a priority in all aspects of work.
Serve as a good steward of TriMet by regularly utilizing our transit system to maintain a strong and current understanding of customers’ experiences and of TriMet’s product and service offerings.
Essential Functions
Develops data pipelines that prepare raw data produced by internal TriMet applications into consumable forms for analysis and reporting. Design database tables with curated data fields and useful aggregation, abstraction, and features.
Works with IT and operations divisions to ensure that minimum data standards are adhered to.
Develops and maintains automated scripts and programs for data management using SQL, SAS, R, and other software languages.
Produces, maintains, and updates department development procedures to ensure that regular reporting is standardized, maintainable, and up-to-date.
Oversees maintenance of regularly scheduled reporting processes, and train Operations Analysts in reporting requirements and maintenance.
When appropriate, operationalizes one-off analyses performed by Service Performance and Analysis team into scheduled, automated regular reporting.
Position Requirements
A minimum of a Bachelor's Degree is required with a Bachelor's Degree in Engineering, Statistics, Computer Science, or Business being preferred.
A minimum of four (4) years of experience are required. *
Two (2) years of experience conducting research, performing statistical data analysis, business system and process improvement analysis and presenting recommendations are required.
Two (2) years of experience with software development are required.
Or any equivalent combination of experience and training.
*The amount of credit a candidate receives for prior years of experience is based on the relevancy of that experience to the required or preferred prerequisites of the job description. Experience is prorated based on hours worked. LRHR assigns and validates the "credited experience".
Selection Criteria
Type of Position / Grade / FLSA
Grade 15, Exempt, Non-Union, Full-Time.
Salary Range
Minimum: $91,048.00
Maximum: $136,572.00
Salary offers will be determined by a candidate’s education, training and relevant experience. Any final offer of employment will fall within the range stated above. For transparency, we choose to list the full available grade range, however, TriMet’s salary administration process will ultimately determine the final salary offered.
Selection Process
Candidates will be selected based at a minimum on the result of:
Application Review (please include: Cover Letter and Resume)
Panel Interviews
Reference Check
Supplemental Information
Make sure you describe in detail how your education, training and work experience fit with this role. You are encouraged to attach a resume, cover letter, training certificates and/or letters of recommendation with your application. You are permitted five attachments of less than 5MB each.
Internal applicants: Information in your personnel file will not be used in lieu of information requested on your application. Incomplete applications will not be considered.
If you are a qualified veteran and would like to apply for veterans' preference points, you will need to reflect your status on the application and attach supporting documentation at the time of application submission.
If you need accommodation under the Americans with Disabilities Act for any part of the application process, contact our Human Resources staff at 503-962-7505, or the TTY line at 7-1-1. Note that we require a minimum of two workdays' notice prior to the need for accommodation.
TriMet is an equal opportunity employer, committed to developing an organization that is reflective of and sensitive to the needs of the diverse community we serve, including veterans, the elderly, and individuals with disabilities.
ADA Statement
As applied to the workplace, applicants and employees must be qualified to perform the essential functions of the job with or without reasonable accommodation. Essential functions may include required job functions performed infrequently as well as production standards related to the quality and quantity of work.
If a person with a disability could meet job qualifications with a reasonable accommodation, TriMet will work with the employee to accommodate the need. If TriMet's accommodation is effective in allowing the employee to perform the essential functions of the job, it need not be the employee's preferred accommodation.