Job Opportunities in United States

Description

• Independently modernizes data integration processes to support business intelligence, artificial intelligence, machine learning, and system integration.
• Independently creates and maintains processes to extract, transform, and load (ETL) data from legacy, cloud, and Saa S transactional systems.
• Provide development and implementation database support for modernizing WSDOT’s client/server and web applications.
• Participate on application modernization teams as an expert on data integration and data migration for transactional systems.
• Administer legacy and cloud-based data storage, warehousing, and integration systems.
• Support M2D2s TDGMG GIS data integration and data migration needs regarding spatially enabled data designed for decision support activities.

• 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 bachelor's degree in computer science, mathematics, or a 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 with Microsoft SSIS and Azure Data integration.
• The ability to communicate both orally and in writing to technical and non-technical audiences.
• The ability to read and understand an Entity Relationship (ER) diagram.
• An understanding of data warehouse principles and star schema design.
• An understanding of modern cloud data architecture, data lakes, and integration design.

• Experience using artificial intelligence and machine learning algorithms.
• Experience with data quality analysis, data cleansing, metadata, and governance.
• Experience using Informatica software.
• A bachelor's degree or higher in computer science, mathematics, or a related field.

• 
  To review the full Position Description, please follow the directions in the Contact Us section of this posting.

• This recruitment may also be used to fill additional positions per business needs.
• This position offers flexible/hybrid remote work options.
• Travel may be required for this position.
• This position may need to respond to after-hours support issues to ensure the availability of the agency’s data assets.
• 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.
• WSDOT does not use the E-Verify system, therefore we are not eligible to extend STEM Optional Practical Training (OPT). 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.

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 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 of 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.