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

Flexible work schedules

Paid leave and holidays

Health premiums coverage

Job summary

Texas Department of Transportation in Austin is seeking a Data Analyst IV to design and maintain advanced dashboards, reports, and data integrations in support of the Financial Management Division. You will transform complex data into actionable insights and drive process improvements using modern BI and AI-enabled tools.

The role requires a Bachelor’s degree and 3 years of data analysis experience, with strong skills in Power Platform, SQL, scripting, and data quality.

Qualifications

• Bachelor's degree required, substitutions allowed for experience.
• 3 years of data analysis, research, compilation, and/or report writing and design.
• Experience designing dashboards and automated reporting.
• Experience with data integration and ETL processes.

Responsibilities

• Develop and maintain dashboards and automated reporting.
• Design, develop, and maintain workflows and business solutions.
• Utilize Power Platform, SQL, scripting, and data integrations to automate processes.
• Apply AI tools (Copilot, Google Gemini) to streamline workflows and ensure output accuracy.
• Present analytical findings to management and stakeholders.

Skills

Power Platform

SQL

Scripting

AI tools

Education

Bachelor's degree in related field

Tools

Copilot

Google Gemini

ETL

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

At TxDOT, we value work-life balance and are committed to providing our employees with a comprehensive range of benefits and programs, including:

• 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).

Position Description

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.

Essential Duties

• 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.
• Identify 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.
• Other duties as assigned.

Minimum Qualifications

Education

Bachelor's Degree in a related discipline. Relevant work experience may be substituted for degree on a year per year basis. Substitutions for Minimum Qualifications

Experience

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.

Competencies

• 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
• Close Visual Acuity-work includes data/figures; view a computer screen; extensive reading

Conditions of Employment

Please read the Standard Conditions of Employment (TxDOT) for all positions.

Job

Plan/Aviation/Pub Trans/Legis

Schedule

Full-time

Employee Status

Regular

Job Type

Standard

Job Level

Non-Management

State Job Title/s

Data Analyst IV

State Job Code/s

0653

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.

Applicant Information

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.