IT Data Architect; Senior​/Specialist

Position: IT Data Architect (Senior/Specialist)
About WSDOT

The Washington State Department of Transportation (WSDOT) is a multimodal agency with a global reputation for excellence. Our dedicated workforce plans, designs, builds, and operates an integrated transportation system that safely and efficiently moves people and goods throughout the state. In addition to maintaining over 20,000 lane miles of state highway and 4,100 bridges, WSDOT leads an award-winning Active Transportation Plan, manages the world's longest floating bridge, and operates the largest ferry system in the nation!

The Opportunity

WSDOT is seeking a Data Architect to serve as the agency's principal professional on data architecture, data governance, and enterprise data modeling. This critical position will design and oversee modern, compliant data solutions across multiple technologies and environments; establish and maintain enterprise-wide data architectures, standards, and policies; and lead automated, reproducible database deployment practices. In this role, you will provide strategic technical consultation on database design, lead complex data architecture efforts, manage data-modeling tools and standards, and collaborate closely with database administrators, application developers, project managers, and business partners to align data solutions with WSDOT's strategic goals.

A strong candidate will demonstrate deep expertise in data architecture and governance, proficiency with data-modeling tools, experience designing enterprise database solutions, knowledge of automated deployment practices, strong analytical and problem-solving skills, and the ability to communicate, lead, and influence across technical and non-technical teams.

What to Expect

Among the varied range of responsibilities held within this role, the IT Data Architect will:

* 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 both TSD teams and business customers on the best 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 that align with enterprise standards and strategic objectives of WSDOT.

* Lead agency data governance, data architecture and data modeling in conjunction with business analysts, developers, database administrators, project managers, and clients.

* Apply advanced strategic expertise and comprehensive technical business process knowledge in leading all aspects of Enterprise AI and Data Services (EADS) related to data architecture.

* Direct the work of data modelers in EADS and consult with data modelers throughout the Department.

* Establish and update agency wide data architecture and data standards and select technical tools to enable support and implementation of data standards; advise TSD and other agency managers on matters of data architecture.

* Represent WSDOT, TSD, and EADS by communicating, presenting, and promoting data architecture standards to internal and external partners.

* Lead and contribute to technical teams as an expert on the principles of data architecture and data modeling.

* Create technical requirements documents and data models.  

* Create physical data models and Structured Query Language (SQL) scripts that will create data schemas and data objects.

Qualifications

To be considered for this opportunity, the following are required:

Automated Deployment

* Experience using Azure Dev Ops to build, maintain, implement reproducible automated database build and deploys.  

* Skills and ability to assist and train other team members in the best practices and use of automated deployments.  

Data Architecture, Management & Governance

* Demonstrates ability to create Data science, engineering and Integration solutions using big data platforms and analytics including work on large scale data architectures or related areas.

* Demonstrated experience architecting, implementing, and creating complex technology solutions.

* Architect data solutions that support artificial intelligence and machine learning initiatives, ensuring data is AI-ready, accessible and governed.

* Demonstrates the ability to work independently and lead all phases of data management and/or application development, including requirements gathering, system design and architecture, development and coding, testing and quality assurance, change management and implementation and deployment.

* Skills to apply logical problem-solving techniques to design and implement scalable and maintainable solutions.

* Ability to communicate effectively with technical and non-technical stakeholders using clear written and verbal communication.

Data Platform Design

* Experience producing proofs of…