TxDMV - Systems Analyst - Data Engineer (Remote in TX)

SUBMISSION OF APPLICATION

To apply for this position, select the “Apply Online” button. Complete your on-line applicant profile and the State of Texas Application for Employment. TxDMV does not accept paper applications.

Effective January 23, 2026:

• You will be required to attach a resume to your application which will be used for screening purposes.
• Please ensure your résumé is detailed and specific, including a full employment history (full time or part time), education, licenses, and skills.
• Your résumé must include the month and year for start and end dates for each listed employer.
• Failure to fully complete the application requirements and pre-screening questions may disqualify you for consideration for this position.

Applicants who require accommodation for the interview process should contact Human Resources at 512-465-4043 when contacted to schedule an interview.

State Classification Title: Systems Analyst V

NOTE: This position is currently eligible for telecommuting within the state of Texas. However, this is subject to change, and the position may transition to an in-office assignment at a designated work location within the state based on space availability and agency needs. Must attend meetings/training at headquarters in Austin, TX as required by management.

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 advanced (senior-level) development work in support of the TxDMV, Information Technology Services Division. Work involves designing, developing, implementing, and maintaining robust and scalable ETL and data pipeline solutions to ingest, transform, and load data from various sources into target data warehouse and reporting structures. Data Engineer will be responsible for ensuring system security, optimizing ETL solutions for performance and accuracy, and integrating modern and AI-driven technologies.

The Data Engineer will manage both legacy and modern ETL solutions, ensuring compatibility and security while transitioning to more advanced solutions where applicable. The position requires a deep understanding of data integration workflows, data lineage, data transformations, database modeling, data warehousing, and relational databases. The Data Engineer will work closely with data/enterprise architects, data analysts, database administrators and infrastructure teams to ensure data quality, consistency, and accessibility for business users and analytics teams.

ESSENTIAL DUTIES

• Design and Development

o Design, develop, test, and deploy ETL pipelines using industry-standard ETL tools and technologies.

o Translate business requirements into technical specifications and efficient ETL processes.

o Implement data quality checks and validation rules within ETL pipelines.

o Optimize ETL processes for performance, scalability, and reliability.

o Document ETL processes, data flows, and technical specifications.

• Data Integration

o Extract data from various sources, including databases, APIs, flat files, and cloud storage.

o Transform data into the required formats and structures for target systems.

o Load data into the data warehouse and data lake.

o Work with data source owners to understand data structures and ensure data accuracy.

• Maintenance and Support

o Monitor ETL pipeline performance and identify areas for improvement.

o Troubleshoot and resolve data integration issues.

o Maintain and update existing ETL processes to accommodate changing business needs.

• Collaboration

o Collaborate with data/enterprise architects, BI developers, and other stakeholders to understand their data requirements.

o Work closely with database administrators and infrastructure teams to ensure proper system performance.

o Participate in code reviews and knowledge sharing.

o May travel up to 5% of the time. Travels by car (may include flying). May include overnight travel. May require working extended hours and some evenings and weekends, as needed.

o Required to attend work regularly and adhere to approved work hours in accordance with department policies and procedures.

o Performs other duties as assigned.

KNOWLEDGE, SKILLS, AND ABILITIES

• 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 and hands-on experience of the limitations and capabilities of computer systems, information technology equipment, applicable programming languages, computer hardware and software, and computer operating systems.
• Knowledge of Data Governance tools like Informatica Enterprise Data Catalog, Axon or similar tools from other Industry providers.
• Knowledge of new cloud technologies and the analytical services available from the major cloud services providers.
• Knowledge of cloud delivery models: PaaS, SaaS, IaaS.
• Knowledge of cloud-based services for AWS, Microsoft Azure or GCP.
• Skills with data engineering, including acquisition/ETL tools such as Informatica PowerCenter, IDQ, and cloud technologies like MS Fabric, Azure Data Factory, Informatica IICS etc.
• Skills and experience acquiring data from multiple data sources/technologies for use by data visualization tools like Power BI and COGNOS. Examples of technologies include DB2 and others such as Oracle, SQL Server, Microsoft Excel, Postgres, MS SharePoint, sales force etc.
• Strong analytical and problem-solving skills with experience as a technical lead for software development, data analytics, performance management system, or data warehousing project.
• Strong technical writing and diagraming skills, including proficiency with modeling and mapping tools (e.g., Visio, Erwin), the Microsoft Office Suite (Word, Excel, PowerPoint, and MS Project).
• Ability to apply analytical, trouble shooting, and problem-solving skills in data related projects.
• An ability to effectively prioritize and manage multiple tasks and directional changes under short and firm deadlines.
• Ability to understand, follow and convey brief oral and/or written instructions.
• Ability to establish and maintain effective and cordial working relationships at all organizational levels, including agency management, direct supervisors, co-workers, internal and external customers.
• Ability to communicate both verbally and in writing, in a clear and concise manner.
• Knowledge of cloud-based services for AWS, Microsoft Azure or GCP.
• Ability to generate ETL Workflow pipelines to support Applications, Data Warehouse, and Reporting needs.
• Knowledge of AI technologies and experience implementing AI features.
• Ability to work independently and as part of a team, and to support and contribute to a cohesive team environment.
• Ability to work with limited supervision and to schedule workload to meet requirements and deadlines of the position.
• Ability to work under pressure and exacting schedules to complete assigned tasks.
• Proficiency in ETL tool(s) (e.g., Informatica Azure Data Factory, AWS Glue, Google Cloud Dataflow, Talend).
• Designing, coding, testing, and debugging complex ETL solutions.
• Ability to develop cloud-based data warehouses.
• Ability to lead advanced-level ETL development tasks with minimal supervision, exercising initiative and independent judgment.
• Ability to document processes, requirements, and code for clarity, maintainability, and handoff readiness
• Ability to remain flexible and innovative in problem-solving while adhering to organizational standards and regulations.

MINIMUM REQUIREMENTS

Education and Experience

• Bachelor's degree from an accredited college or university in the areas of data science, data management, computer information systems, management information systems, computer science, cybersecurity or information security, or in a field related to assignment or a related field, or equivalent experience.
• Two (2) years of experience in a Data Engineer or Developer-related role creating ETL pipelines with a focus on Enterprise Analytics projects.
• Five (5) years of experience working with a variety of relational databases (e.g. DB2, SQL Server).
• Two (2) years of experience in ETL development using industry-standard ETL tools (e.g., Informatica, Azure Data Factory, Microsoft Fabric).
• Two (2) years of experience in administration, configuration, development, and management of data storage, integration, and ETL solutions on cloud (AWS, Azure) and on premise.
• Experience in building data pipelines in AWS or Azure public clouds.

NOTE: Experience may substitute for education. Education may not substitute for the experience requirement.

Experience & Training Preferred

• Five (5) years of experience with development following the Agile formal/structured methodology.
• Five (5) years in implementing scalable and efficient data workflows, including data warehousing, data lakes, and data marts.
• Four (4) years of experience in trouble shooting and performance tuning ETL Workflows and SQL.
• Four (4) years of experience with batch processing in mainframe, DB2, or Oracle batch framework.
• Two (2) years of experience with Data Governance and Data Catalog tools such as Informatica Data Catalog
• Proficient in scripting (SQL, R, Python, etc).
• Azure or AWS cloud certifications.
• AI Knowledge will be preferred.

ADDITIONAL INFORMATION

This position is eligible for remote work in the state of Texas (subject to change). Must attend meetings/training at headquarters in Austin, Texas as required by management.

Remote work employees must meet these criteria for the remote work location:

• Adequate desk space in a dedicated, contained area that is secured and protected at all times.
• Remote work location is in a quiet environment free of background people and noise during business hours.

BENEFITS

The State of Texas offers a variety of benefits for you and your family that are comprehensive and, on average, make up about one-third of total compensation. Benefits include:

QUALIFIED EMPLOYER: In addition, the Texas Department of Motor Vehicles is considered a qualified employer for the Department of Education’s Public Student Loan Forgiveness (PSLF) program.

REGISTRATION, CERTIFICATION AND/OR LICENSURE

A valid Class "C" driver's license is required. If not currently a Texas resident, must obtain a Texas Driver's License within ninety (90) days after entering Texas as a new resident. A satisfactory driving record is required for operating state or personal vehicles to conduct department business.

JOB OFFERS AND CONTINUATION OF EMPLOYMENT IS CONTINGENT UPON:

• Proof of education and experience listed on the application
• Eligibility to work in the United States
• Satisfactory results from a pre-employment criminal history background check and driver’s record check
• Compliance with Selective Service registration for males ages 18-25
• Required to attend work regularly and observe approved work hours in accordance with department policies and procedures.

MILITARY

If selected for the position the following must be provided for proof of military employment preference:

• Veteran must provide form DD 214
• Surviving Spouse or Orphan must provide DD 1300 or DD 214.

Military Occupational Specialty (MOS) codes that may correspond to the state classification title for this position are listed on the State Auditor’s Office Job Descriptions; click on the occupational category for the position. Additional MOS can be found at the State Auditor’s Office Military Crosswalk Guide.

The Texas Veterans Commission provides helpful employment information.

SUBMISSION OF APPLICATION

Your application must be complete, accurate and reflect all experience and education. Omission of data can be the basis for disqualification. "See Resume" is not accepted in lieu of a completed online State of Texas application but attached resumes may be considered as additional supplemental information.

AN EQUAL OPPORTUNITY/AFFIRMATIVE ACTION EMPLOYER

The Texas Department of Motor Vehicles is an equal opportunity employer and does not discriminate on the basis of race, color, religion, sex, national origin, pregnancy, disability, military status, age, or any other characteristic protected by federal or state law. The TxDMV provides accommodations for persons with disabilities in accordance with the American with Disabilities Act. If you need help with the employment process or require other accommodation, please contact the Human Resources office for assistance on 512-465-4043.