Data Analyst IV

Texas Department of Transportation; Austin (TX); On-site; USD 94,000 - 96,000; Full time

Benefits offered by this job

Retirement Plans

Alternative and/or Flexible Work Sched

Paid Leave and Holidays

Health Premiums paid at 100% for Full‑

On-the-Job Training

Tuition Assistance Program

Holistic Wellness Program with Leave</

Career Development and Advancement

Family-Friendly Policies and Programs

Job summary

Texas Department of Transportation in Austin, TX is seeking a Data Analyst IV to develop dashboards, reports, and data integrations within the Financial Management Division. The role focuses on transforming complex data into actionable insights and enhancing enterprise data workflows.

The candidate will leverage Power Platform, SQL, and scripting to automate processes and support enterprise systems, while collaborating with stakeholders on data-driven solutions.

Qualifications

• Minimum 3 years of data analysis, research, compilation, and/or report writing experience.
• Graduate-level education may substitute for experience on a year-for-year basis.

Responsibilities

• Serve as a functional resource for division business systems, reporting platforms, and enterprise data repositories.
• Design, develop, and maintain automated reporting, dashboards, workflows, and business solutions.
• Utilize Power Platform, SQL, scripting, data integrations to automate processes.
• Apply AI tools such as Microsoft Copilot and Google Gemini to streamline workflows and validate outputs.
• Lead or support technology, reporting, and business process improvement initiatives.
• Identify data gaps, errors, and inconsistencies across data sources.
• Develop and maintain data connections across multiple enterprise systems and ETL processes.
• Create and maintain system documentation and reporting structures.
• Coordinate with IT staff, vendors, and partners to resolve technical issues.

Skills

Data analysis

Power Platform

SQL

Scripting

AI tools

Education

Bachelor's degree in related field

Tools

Power Platform

SQL

Job description

Job Description - Data Analyst IV (2602673)

Job Description

Data Analyst IV - ( 2602673 )

Position Information

Home to SXSW, Austin City Limits (ACL), and glorious natural springs and parks, Austin, Texas, is one of the fastest-growing areas in the United States, as well as the Live Music Capital of the World. Austin is the historic state capital of Texas and is the location of the Texas Department of Transportation Headquarters. TxDOT's Financial Management Division is seeking Data Analyst IV. Come join our team at our beautiful, new Stassney campus in Austin, where you will have access to covered employee parking, walking trails, on-site fitness center, coffee bar, and on-site cafeteria. We have a diverse workforce of over 13,000 employees statewide. If you want to build an exciting career, let's talk!

Stassney Campus: https://youtu.be/u42vEZacDgA

Minimum Salary

94,000.00

Maximum Salary

96,000.00

Pay Basis

Yearly FLSA Status : Exempt

Work Locations

Stassney Hq - Main 6230 East Stassney Lane Austin 78744

Travel

Yes, 5 % of the Time Shift : Day Job Shift Details : 40 Location Flexibility : Onsite

Benefits and Perks

• Retirement Plans

• Alternative and/or Flexible Work Schedules

• Paid Leave and Holidays

• Health Premiums paid at 100% for Full-Time Employees

• On-the-Job Training

• Tuition Assistance Program

• Holistic Wellness Program with Leave Incentives

• Career Development and Advancement Opportunities

• Family-Friendly Policies and Programs

In 2024, TxDOT was recognized as a Best Place for Working Parents, and many of our offices statewide are also designated as Texas Mother-Friendly Worksites. These recognitions reflect our dedication to supporting families and promoting a healthy work-life balance.

For a complete list of our total compensation package please visit our Total Compensation Package website

To view benefits available to all State of Texas employees visit Benefits at a Glance | ERS (texas.gov)

The Data Analyst IV performs advanced analytical, reporting, systems, and business intelligence work supporting the Financial Management Division's operational, financial, and strategic objectives. The position develops and maintains dashboards, reports, data integrations, automation solutions, and reporting environments while serving as a liaison between business stakeholders and technical resources. The role is responsible for transforming complex data into meaningful insights, supporting enterprise systems, streamlining business processes, and recommending technology-based solutions that improve efficiency and decision-making.

• Serve as a functional resource for division business systems, reporting platforms, and enterprise data repositories.
• Design, develop, and maintain automated reporting, dashboards, workflows, and business solutions that improve operational efficiency and data accessibility.
• Utilize Power Platform, SQL, scripting, data integrations, and other technologies to automate processes and reduce manual effort.
• Utilize AI tools such as Microsoft Copilot and Google Gemini, and apply them to streamline analytical workflows, automate repetitive tasks, and validate AI-generated outputs for accuracy.
• Lead or support technology, reporting, and business process improvement initiatives, including requirements gathering, solution design, testing, implementation, and deployment.
• Identifies data gaps, errors, anomalies, inconsistencies, and redundancies by analyzing the content, structure, and relationships within data.
• Develop and maintain data connections across multiple enterprise systems and support data extraction, transformation, and loading (ETL) processes.
• Create and maintain system documentation, including business requirements, business rules, data definitions, procedures, and reporting structures.
• Coordinate with IT staff, vendors, and business partners to resolve technical issues and support system enhancements.
• Analyze data to identify gaps, errors, anomalies, inconsistencies, and redundancies while ensuring compliance with agency security, governance, and data quality standards.
• Present complex analytical findings to management and external stakeholders, tailor messaging to varied audiences, and prepare written recommendations

3 years of experience in data analysis, research, compilation, and/or report writing and design work experience. (Experience can be satisfied by full time or prorated part time equivalent). Related graduate level education may be substituted for experience on a year per year basis.

Preferred Qualifications:

• Bachelor's degree in Data Analytics, Information Systems, Computer Science, Business Administration, Finance, Public Administration, Statistics, Mathematics is highly preferred
• Serve as a functional resource for division business systems, reporting platforms, and enterprise data repositories.
• Design, develop, and maintain automated reporting, dashboards, workflows, and business solutions that improve operational efficiency and data accessibility.
• Utilize Power Platform, SQL, scripting, data integrations, and other technologies to automate processes and reduce manual effort.
• Utilize AI tools such as Microsoft Copilot and Google Gemini to streamline analytical workflows, automate repetitive tasks, and validate AI-generated outputs for accuracy.
• Lead or support technology, reporting, and business process improvement initiatives, including requirements gathering, solution design, testing, implementation, and deployment.
• Develop and maintain data connections across multiple enterprise systems and support data extraction, transformation, and loading (ETL) processes.
• Create and maintain system documentation, including business requirements, business rules, data definitions, procedures, and reporting structures.
• Coordinate with IT staff, vendors, and business partners to resolve technical issues and support system enhancements.
• Analyze data to identify gaps, errors, anomalies, inconsistencies, and redundancies while ensuring compliance with agency security, governance, and data quality standards.
• Present complex analytical findings, recommendations, and reports to management and stakeholders, tailoring communications to diverse audiences.

Physical Requirements and Working Conditions:

Sedentary work: Lift up to 10 lbs at a time and occasionally carry files/small tools

Standing-prolonged periods of time

Repetitive Motion-substantial movements of the wrists, hands, and/or fingers

Military Occupational Specialty (MOS)

TxDOT is committed to hiring veterans. To assist in determining whether your military experience may pertain to the minimum requirements for this position, Military Occupational Specialty (MOS) codes from each branch of the U.S. Armed Forces have been assigned to each state classification code/title where applicable. The MOS codes are grouped by occupational category.

Click on the appropriate occupational category to view the MOS codes.

The Texas Department of Transportation is an Equal Opportunity Employer.

If requested, reasonable accommodations will be made for persons with disabilities for any part of the employment process in accordance with the Americans with Disabilities Action of 1990.