Data Analyst III or IV

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

Benefits offered by this job

Retirement Plans

Flexible Work Schedules

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

The Texas Department of Transportation is seeking a Data Analyst III or IV in Austin to conduct detailed data analysis and research, translate findings into actionable insights, and develop dashboards using Tableau or related tools.

You will collaborate with teams statewide, ensure data quality, and prepare concise reports. The role emphasizes data visualization, reporting, and ongoing data standards, with onsite duties at Stassney HQ and opportunities for career advancement.

Qualifications

• 2 years of experience in data analysis, research, compilation, and/or report writing and design work experience.
• 3 years of experience in data analysis, research, compilation, and/or report writing and design work experience.

Responsibilities

• Participates in preparing and conducting presentations of performance visualizations and reports.
• Develops reports, dashboards and interactive visualizations using Tableau/Power BI.
• Identifies and interprets data patterns and trends and assesses data quality.
• Cleans and prunes data to discard irrelevant information.
• Modifies existing reports or develops new reports by analyzing databases, data sources, and structures.

Skills

Data analysis

Tableau

Power BI

SQL

Excel

Data visualization

Tools

Tableau Server

Tableau Desktop

Tableau Prep

Tableau

Power BI

SQL

Excel

Access

Job description

Job Description - Data Analyst III or IV (2602290)

Job Description

Data Analyst III or IV - (2602290)

Position Information

TxDOT's Transportation Programs Division is looking for a Data Analyst III or IV. This position involves conducting detailed analysis and extensive
research on data and providing results in various formats. We have a diverse workforce of over 12,000 employees statewide. If you want to build an exciting career, let’s talk!

At TxDOT we value employee work-life-balance. In keeping with our commitment to this, our employees benefit from a wide array of programs and activities that include flexed and compressed work schedules, wellness leave incentive, in-house wellness center, career development programs, tuition assistance, and various other benefits.

• Data Analyst III, B22, $57,614 - $93,138
• Data Analyst IV, B24, $65,104 - $106,634

Work Location: 6230 E Stassney Lane Austin, TX 8744

Minimum Salary

57,614.00

Maximum Salary

93,138.00

Pay Basis

Yearly FLSA Status : Exempt

Work Locations

Stassney Hq - Main 6230 East Stassney Lane Austin 78744

Travel

Yes, 10 % 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 T otal Compensation Package website

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

Performs moderately complex data analysis and data research work. Work involves conducting detailed analysis and extensive research on data and providing results in various formats. Monitors and implements measures to ensure data quality. Responsible for using standard statistical tools, methods, and techniques to translate data into actionable insights using data visualization software. Works under general supervision, with limited latitude for the use of initiative and independent judgment.

Data Analyst IV

Performs complex data analysis and data research work. Work involves conducting detailed analysis and extensive research on data and providing results in various formats. Monitors and implements measures to ensure data quality. Responsible for using standard statistical tools, methods, and techniques to translate data into actionable insights using data visualization software. Works under general supervision, with moderate latitude for the use of initiative and independent judgment.

Data Analyst III

• Participates in preparing and conducting presentations of performance visualizations and reports.
• Participates in data visualization tool system administration monitoring and upgrades.
• Identifies and interprets data patterns and trends and assesses data quality.
• Prepares concise, comprehensive technical reports to present and interpret data, identify alternatives, and make and justify recommendations on data revisions.
• Develops reports, dashboards and interactive visualizations using different components of Tableau software including Tableau desktop, Tableau Prep, and Tableau server.
• Accesses information from business organization cross-sections to make good business decisions and provide excellent customer service.
• Reviews and edits materials and recommends revisions in scope, format, and content.
• Compiles and queries data.
• Analyzes data using standard statistical tools, methods, andtechniques.
• Interprets results to identify significant differences in data.
• Cleans and prunes data to discard irrelevant information.
• Modifies existing reports and/or develops new reports by analyzing databases, data sources, and structures for the benefit of users
• Assists in defining, developing, and implementing data standards.

Data Analyst IV

all of the above and

• Drives the selection of data visualization tools, the development of standards, usage guidelines, and procedures forthose tools.
• Identifies data gaps, errors, anomalies, inconsistencies, and redundancies by analyzing the content, structure, andrelationships within data.
• Performs quality assurance and serves as a subject matter expert on data integrity, extraction, and compilation.
• Manages and maintains the Tableau Server and Desktop Developer environment.
• Designs, develops, and maintains visualizations and reports utilizing data visualization tools and best practices.
• Consults with performance analysts, program staff, and vendors to understand the business requirements that drive theanalysis and design of visualizations
• Collaborates with performance analysts to analyze and interpret data patterns, to understand correlations between datasets.
• Participates in preparing and conducting presentations of performance visualizations and reports.
• Participates in data visualization tool system administration monitoring and upgrades.
• Consults with internal and external customers to identify user needs.
• Identifies and interprets data patterns and trends and assesses data quality.
• Performs other job responsibilities as assigned

2 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.

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.

Licenses and Certifications

Valid driver’s license. This position requires driving a state vehicle.

Data Analyst III

Considerable knowledge of:

• Data analysis and interpretation
• Designing complex graphic materials using graphic software, applications and/or traditional methods
• Business processes and methodologies, data import and export protocols
• Technical requirement analysis, business process modeling/mapping, methodology development and data modeling
• Communicating technical information effectively
• The use of technical tools such as Excel, Access, SQL and other heavy data analysis
• Developing and presenting reports in multiple formats
• Report writing and design
• Working with streaming data and unstructured data from multiple data sources
• Using Tableau, Microsoft Power BI, or Qlik
• Using computers and applicable programs, applications, and systems
• Creating graphical user interfaces, visualizations, mockups, prototypes, and design documents

Ability to:

• Analyze data and derive informative conclusions.
• Effectively organize and prioritize work demands in a fast-paced environment
• Evaluate and make recommendations regarding data integrity
• Translate complex data into user-friendly information
• Implement and use new technology and work processes to enhance decision-making
• Build, establish, and maintain effective working relationships and coalitions

Other Attributes:

• Exercises logic and reasoning to define problems, establish facts and draw valid conclusions; makes decisions that support business objectives and goals
• Protects sensitive and confidential information

Data Analyst IV

all of the above and

• Creating graphical user interfaces, visualizations, mockups, prototypes, and design documents

Physical Requirements and Working Conditions

Data Analyst III/Data Analyst IV

• Sedentary work: Lift up to 10 lbs at a time and occasionally carry files/small tools
• Sitting - prolonged periods of time
• Fingering-picking, pinching, typing; working primarily with fingers rather than whole hand

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.