Washington State Department of Transportation (WSDOT) is the steward of an integrated, multimodal transportation system that helps to ensure people and goods move safely and efficiently throughout the state. In addition to building, maintaining, and operating the state highway system, WSDOT operates the largest ferry system in the nation, manages the world's longest floating bridge, and recently completed the world's widest tunneling project.
WSDOT is currently seeking to fill three IT Data Management – Journey vacancies located in Olympia, WA. These positions are members of our Project Propel Technology Transformation Team will serve as Extract, Transform, and Load (ETL) Developers. Project Propel is supporting One Washington’s efforts to modernize technology and administrative business functions related to finance, procurement, budget, human resources, and payroll through the implementation of Workday. In the interim, Propel is upgrading Transportation Reporting Accounting & Information System (TRAINS), WSDOT’s core financial system, to the modern, cloud version of CGI Advantage 4. Reporting to the Project Propel’s Integration Remediation Lead, these positions will be responsible for supporting and performing the activities of the Integration Remediation Workstream. In these roles, you will support the data management efforts of the Integration Remediation Workstream to complete the TRAINS upgrade and to support OneWa’s efforts to implement Workday. The ETL Developers will ensure that WSDOT data interfaces that are identified as in-scope have been appropriately remediated to ensure WSDOT is able to successfully continue critical business activities.
What to Expect
These positions will focus on modernizing WSDOT’s business processes, integrations and supporting WSDOT employees through the transition to the upgrade and the new statewide enterprise system, Workday.
Among the varied range of responsibilities held within these roles, the ETL Developers will:
Independently modernize data integration and processes to support migration from legacy on-premise systems to cloud-modern and SaaS vendor-based technologies.
Perform data analysis on highly complex databases.
Design, create, and maintain modern data integration routines.
Consult with and direct customers to identify emerging business reporting needs.
Perform data analysis on highly complex databases on multiple platforms and architectures to identify the correct data needed to meet the business’ reporting requirements.
Ensure that the data in the data layer is correct, complete, and timely.
Contribute to the design and implementing test plans.
Monitor ETL job status to ensure all jobs complete successfully.
To be considered for this opportunity, the following are required:
Six (6) years of experience working in Information Technology within data management or four (4) years of experience working in Information Technology within data management and a four-year degree in computer science, mathematics, or closely related field.
Four (4) years of experience writing complex queries in SQL for reporting and data validation purposes.
Four (4) years of experience creating and maintaining highly complex ETL routines.
Experience working with Azure Data Factory.
Two (2) years of experience in designing, creating, and maintaining data layer on modern database platforms and ETL routines.
Ability to meet with customers, gather requirements and work with team members to design solutions.
Ability to clearly communicate both orally and in writing to technical and non-technical audiences.
It is preferred that qualified candidates also have:
Experience working with Mainframe systems, data sets and databases.
A Bachelor's degree or higher in computer science, mathematics, or related field.
*To review the full Position Description, please contact the recruiter listed in the Contact Us section of this posting.
These are project, limited duration positions, anticipated to last until December 31, 2025.
This recruitment will be used to fill two (2) project positions and may also be used to fill additional positions per business needs.
In addition to base salary, employees may be entitled to other forms of compensation depending on the type, duties, or location of the position. For union-represented positions, more information on other forms of compensation can be found in the applicable Collective Bargaining Agreements. Information on other compensation types for non-represented positions can be found in Chapter 357-28of the Washington Administrative Code.
This position is eligible for remote work up to 100%, per supervisor approval. This Remote work opportunity is available to residents of Washington or bordering states.
The recruiting efforts for these positions have been extended to establish a sufficient candidate pool. The Appointing Authority reserves the right to make a hiring decision at any time thereafter. It is to your benefit to submit your application as soon as possible.
WSDOT does not use the E-Verify system. For more information, please visit www.uscis.gov
Work-Life Balance – We are committed to ensure that our staff experience the reward of public service, while also sustaining a routine that suits each individuals’ lifestyle. As such, there are a number of flexible schedule options available, including occasional telework for eligible positions.
Paid Leave – In addition to 12 paid holidays, full-time employees may earn up to 25 paid vacation days per year!
Tuition Assistance – Permanent employees have several options for assistance with education expenses, including tuition reimbursement programs, government discounts at participating colleges throughout the state, and eligibility for federal student loan forgiveness.
Plan For Your Future – WSDOT offers a comprehensive benefits package that includes a variety of healthcare options. Employees also have their choice of state retirement programs, and much more. Go to State Benefits for more information.
Check out this video to learn more: Why WSDOT?
How to Apply
Applications for this recruitment will be accepted electronically. Your relevant experience may be evaluated to determine salary. Therefore, it is very important that the “Work Experience” portion of the application be completed in as much detail as possible.
In order to be considered for this opportunity, please include the following with your online application:
An attached Resume outlining (in reverse chronological order) your experience to date.
An attached Cover Letter that further explains your qualifications and indicates why you believe you are a viable candidate for this role.
Contact details for a minimum three (3) individuals who can attest to your work performance, technical skills, and job-related competencies. NOTE: This information may be entered in the “References” section of the online application; does not require an additional attachment.
Please click the "APPLY" button to proceed. Note that you will be prompted to either sign in or create an account. This step is required in order to submit an application to this opportunity.
WSDOT is an equal opportunity employer. We value the importance of creating an environment in which all employees can feel respected, included and empowered to bring unique ideas to the agency. Our diversity and inclusion efforts include embracing different cultures, backgrounds and viewpoints while fostering growth and advancement in the workplace. All persons, regardless of race, ethnicity, age, veteran status, sexual orientation, and/or gender identity, are encouraged to apply. Persons with disabilities needing assistance in the application process, or those needing this job announcement in an alternative format may contact the listed Recruiter via email.
For inquiries about this posting, you may contact the assigned Recruiter, Robyn Lovely at [email protected]. Please be sure to reference 23DOT-HQ-0P415m in the subject line.
Application Method: Online: https://www.governmentjobs.com/careers/washington/wsdot/jobs/4073560-0/etl-developer-multiple-positions-project-remote
Base Pay: $6,939.00 - $9,332.00 /YR
2011 W. Washington Ave
Yakima, WA 98903