Employer: Washington State Department of Transportation
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 an Information Technology Division (ITD) Data Management Journey to serve as a Data Integration Modernization Specialist. We welcome candidates with excellent teamwork, inter-personal, and SQL skills. The successful candidate will need to demonstrate the desire and ability to learn independently and expand their skillset as technology changes. This is a team-oriented role, and the successful candidate will follow and synthesize WSDOT standards, state-wide (OCIO) standards, and emerging industry best practices. This position is part of the WSDOT ITD Data Management Services Information Resource Management (IRM) Team. The IRM team designs databases and prepares data and tools for reporting to facilitate its usage to meet agency business goals. Reporting directly to the Business Intelligence Coordinator, this position provides technical data integration support and development for WSDOT’s Modernization effort, WSDOT Data Warehouse, any Operational Data Stores, and cloud-modern Data Lakes, as well as cloud and legacy transactional system interfaces. The Data Integration Modernization Specialist provides journey level data integration with an emphasis on the modernization of on-premises ETL processes, and the support of data integration needs for new cloud and SaaS undertakings by the agency. As a Shared Service Data Integration Modernization Specialist, this position provides advanced technical support for the extraction, transformation and loading of data from and between a variety of on-premise, cloud, and SaaS transactional systems as well as into the WSDOT data warehouse repository for decision support and business intelligence reporting use across all ITD portfolios.
What to Expect
Among the varied range of responsibilities held within this role, the Data Integration Modernization Specialist will:
Independently modernize data integration processes to support migration from legacy on-premises systems to cloud-modern and SaaS vendor-based technologies.
Collect business requirements, institutional knowledge, and implementation details of existing data integration processes and needs.
Design, create, and maintain modern data integration routines to connect legacy and modern systems using cloud based modern data integration technologies.
Troubleshooting performance and data quality issues to ensure accurate and timely delivery of the data.
Independently create and maintain processes to extract, transform and load (ETL) data.
Perform data analysis on highly complex databases on multiple platforms and architectures to identify the correct data needed to meet the business’ reporting requirements.
Provide development and implementation database support for modernizing WSDOT’s client/server and web applications.
Participate on application modernization teams across ITD Portfolios as an expert on data integration and data migration for transactional systems.
Administer on-premise and cloud-based data storage, warehousing, and integration systems across ITD portfolios.
This is an IT Data Management Journey position. However, the hiring manager reserves the right to fill the position at a lower level, IT Data Management Entry, depending on qualifications, providing an opportunity for an individual to gain the required experience on the job as part of a formal “in-training” plan.
To be considered for this opportunity at the ITD Data Management Entry level, at least one of the following are required:
Associates (2 year) degree in computer science or equivalent certification program and two (2) years of experience working in Information Technology within data management or application development. Or
Bachelors (4 year) degree in computer science, mathematics, or related field and experience writing complex queries in SQL.
To be considered for this opportunity at the ITD Data Management Journey level, the following are required:
Six (6) years of experience working in Information Technology within data management or application development OR four (4) years of experience working in Information Technology within data management or application development 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 Extract, Transform and Load (ETL) routines.
Knowledge of the Office of the Chief Information Officer’s Policies, Procedures and Guidelines.
It is preferred that qualified candidates also have:
Experience using Informatica software.
One (1) year of experience working with Kimball Data Warehouse design principles.
Experience with SSIS and Azure Data Factory.
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.
This recruitment may also be used to fill additional positions per business needs.
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.
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-28 of the Washington Administrative Code.
The recruiting efforts for this position may be extended beyond the displayed closing date for as long and until a sufficient candidate pool has been established. However, the first review of applications will be conducted May 22, 2023. 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.
The hiring manager is looking to hire at the goal class, IT Data Management Journey level. However, this position has been approved for in-training, which means the hiring manager is able to considered candidates at the IT Data Management Entry level, if not qualified at the highest level. The in-training plan will allow candidates to complete a series of measured training steps to promote to the goal class. The salary for each in listed below:
IT Data Management Entry: $61,368 – $82,548 Annually
IT Data Management Journey: $80,064 – $107,676 Annually
Washington Administrative Code (WAC) 357-16-197 mandates that all employees who work for executive cabinet agencies (which includes the Department of Transportation) must be fully vaccinated against COVID-19. Compliance with this mandate is a condition of employment with WSDOT. Exemption may be granted for religious or medical purposes; however, accommodations will be subject to approval based on the essential functions required of the position.
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 LovelyR@wsdot.wa.gov. Please be sure to reference 23DOT-HQ-01022 in the subject line.
Contact Person: Robyn Lovely
Location: Thurston County - Tumwater, WA Remote optional
Application Method: Apply online https://www.governmentjobs.com/careers/washington/wsdot/jobs/4029284/data-integration-modernization-specialist-in-training-remote
Base Pay: $61,368.00 - $107,676.00 Annually
2011 W. Washington Ave
Yakima, WA 98903