IT Data Architect; Senior​/Specialist

Salary

$ - $ Annually

Thurston County
- Tumwater, WA

• Job Type: Full Time
  - Permanent
• Remote Employment: Flexible/Hybrid
• Job Number: 26
  
  DOT-HQ-00438-1
• Department: Dept. of Transportation
• Division: Headquarters
• Opening Date: 06/11/2026
• Closing Date: 6/29/2026 11:59 PM Pacific

The Washington State Department of Transportation (WSDOT) is an agency that manages state transportation infrastructure.

WSDOT is seeking a professional to serve as the agency's principal expert on data architecture, data governance, and enterprise data modeling.

• Act as lead subject matter expert on data architecture, tool stack, best practices, and engineering offerings of the Enterprise AI and Data Services (EADS) Team.
• Act as liaison to TSD teams and business customers on data architecture and solutions for ingestion patterns, consumption optimization, data security, access framework, governance, modernization, and innovation.
• Implement and support automated, repeatable, reproducible deployment methodologies for data systems.
• Collaborate closely with business and technical stakeholders to design scalable, secure, and maintainable data solutions.
• Lead agency data governance, data architecture, and data modeling in conjunction with cross-functional teams.
• Establish and update agency-wide data architecture and standards.
• Represent WSDOT, TSD, and EADS by communicating and promoting data architecture standards to internal and external partners.
• Create technical requirements documents, data models, and SQL scripts.

• Experience using Azure Dev Ops to build, maintain, and implement reproducible automated database build and deploys.
• Ability to train team members in automated deployment best practices.

• Ability to create data science, engineering, and integration solutions using big data platforms.
• Experience architecting and implementing complex technology solutions.
• Architect data solutions that support AI and machine learning initiatives.
• Ability to lead all phases of data management and/or application development.

• Experience producing proofs of concept with different technologies.
• Advanced skills in designing modern data platforms (cloud/hybrid), including conceptual, logical, and physical data modeling.
• Strong background in Data Warehousing, Data Marts, relational databases, distributed computing, Oracle, SQL Server, and data security frameworks.

• Experience with modern cloud data platforms (e.g., Azure Synapse, Fabric, Snowflake, Databricks) and Python/Pyspark.
• Proficient in Microsoft Transact-SQL (T-SQL) for query writing, schema modification, and administrative tasks.

• Effectively elicit, document, and analyze business requirements.
• Translate business needs into data models, structures, or technical specifications.

• Ability to work effectively within technical and cross-functional teams.
• Experience leading data modeling or database design efforts and overseeing project activities.

• Work-Life Balance:
  Flexible schedule options, including telework.
• Paid Leave: 12 paid holidays and up to 25 paid vacation days per year.
• Tuition Assistance:
  Programs for education expenses, including tuition reimbursement and student loan forgiveness eligibility.
• Benefits:
  Comprehensive healthcare options, state retirement programs, and more.

WSDOT is an equal opportunity employer. All persons, regardless of race, ethnicity, age, veteran status, sexual orientation, and/or gender identity, are encouraged to apply.