Data Integration Modernization Specialist (IT Data Management Journey)

$85,764 - $115,344/Yr

State of Washington - Tumwater, WA

Full-time - Mid Level

Remote - Tumwater, WA

Executive, Legislative, and Other General Government Support

About the position

The Data Integration Modernization Specialist at WSDOT is a journey-level IT role focused on modernizing data integration processes to support system integration, artificial intelligence, machine learning, and business intelligence. This position plays a critical role in managing and governing agency data, providing advanced technical support primarily to the Multimodal Development and Delivery (M2D2) portfolio. The specialist will work with various data integration technologies and ensure data quality for effective governance and architecture.

Responsibilities

• Independently modernizes data integration processes to support business intelligence, artificial intelligence, machine learning, and system integration.
• Creates and maintains processes to extract, transform, and load (ETL) data from legacy, cloud, and SaaS transactional systems.
• Provides development and implementation database support for modernizing WSDOT's client/server and web applications.
• Participates on application modernization teams as an expert on data integration and data migration for transactional systems.
• Administers legacy and cloud-based data storage, warehousing, and integration systems.
• Supports M2D2's TDGMG GIS data integration and data migration needs regarding spatially enabled data designed for decision support activities.

Requirements

• Six (6) years of experience working in Information Technology within data management or application development, OR Four (4) years of experience in the same field 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.
• Ability to communicate both orally and in writing to technical and non-technical audiences.
• Ability to read and understand an Entity Relationship (ER) diagram.
• Understanding of data warehouse principles and star schema design.
• Understanding of modern cloud data architecture, data lakes, and integration design.

Nice-to-haves

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

Benefits

• Flexible schedule
• Loan forgiveness
• Paid holidays
• Tuition reimbursement