TxDMV - Data Architect; Remote

Overview

GENERAL DESCRIPTION

Our mission at the Texas Department of Motor Vehicles (TxDMV) is to serve, protect and advance the citizens and industries in the state with quality motor vehicle related services. We are a dynamic state agency dedicated to customer service, consumer protection and the success of motor vehicle-related industries.

Performs highly complex (senior-level) data analysis and architecture work. Work involves data modeling and data analytics. Implements and managing database systems and data warehouses. Designs strategies and setting standards for operations, programming, and security. May supervise the work of others. Works under minimal supervision, with extensive latitude for the use of initiative and independent judgment. This position reports to the agency Chief Data Officer.

JOB TITLE:
State classification title Data Architect I. This position is eligible for remote work within the state of Texas (subject to change). Must attend meetings/training at headquarters in Austin, TX as required by management.

Determines database requirements by analyzing business operations, applications, and programming; reviewing business objectives; and evaluating current systems.

Obtains data model requirements, develops and implements data models for new projects, and maintains existing data models and data architectures.

Develops physical databases meeting performance requirements. Develops strategies for database implementation.

Develops data structures for data warehouses and data mart projects and initiatives; and supports data analytics and business intelligence systems.

Implements corresponding database changes to support new and modified applications, and ensures new designs conform to data standards and guidelines; are consistent, normalized, and perform as required; and are secure from unauthorized access or update.

Defines and implements processes for extracting and loading data; identifies appropriate data sourcing and extraction processes, and in identifying and nominating sources as systems of record for data usage in various applications.

Provides guidelines on creating data models and various standards relating to governed data.

Reviews changes to technical and business metadata, realizing their impacts on enterprise applications, and ensures the impacts are communicated to appropriate parties.

Configures and establishes data catalog to inventory, classify, and map data throughout the enterprise.

Establishes measures to chart progress related to the completeness and quality of metadata for enterprise information; to support reduction of data redundancy and fragmentation and elimination of unnecessary movement of data; and to improve data quality.

Assists in selecting data management tools and developing the standards, usage guidelines, and procedures for using those tools.

Assists in performing root cause analyses related to information issues and non-conformance to published data standards based on review of technical metadata of various source systems.

May supervise the work of others.

May travel up to 5% of the time. Involves overnight travel. Travels by plane and/or car. May require working extended hours and some evenings and weekends, as needed.

Performs related work as assigned.

Knowledge of master data, metadata, reference data, relational data modeling, data warehousing, and business intelligence principles and processes, including the technical architecture of enterprise information management processes and methodologies, relational database management systems, metadata management, business intelligence, and business analytics tools.

Knowledge of local, state, and federal laws and regulations relevant to data management and data governance.

Knowledge of the limitations and capabilities of computer systems.

Knowledge of technology across all network layers and computer platforms.

Knowledge of operational support of networks, operating systems, Internet technologies, databases, and security applications.

Knowledge of project management software and system development life cycle concepts.

Knowledge of cloud-based services for AWS, Microsoft Azure or GCP.

Knowledge of AI technologies and experience implementing AI features.

Ability to apply analytical, trouble shooting, and problem-solving skills in data related projects.

Demonstrated ability to communicate effectively with all project stakeholders, including executive leadership, business subject area leaders, and project staff.

Demonstrated ability to communicate effectively to individuals and groups; to make effective presentations in formal and informal settings.

Demonstrated ability to communicate effectively, both verbally and in writing, to a variety of audiences. Must be an articulate and persuasive leader, able to communicate concepts to a broad range of technical and non-technical staff.

Ability to make critical decisions in the best interest of the agency and its mission and goals, while following…