Data and Reporting Risk Analyst I (Letting Data Analyst I) - Design Division - Austin, TX

Data and Reporting Risk Analyst I (Letting Data Analyst I) - Design Division - Austin, TX - (2501343)

Position Information

TxDOT's Design Division is looking for an analyst to assist with the statewide evaluation of project readiness through risk assessments, data, and reporting.
As a vital member of our team, you'll harness data and tools to improve efficiency in how TxDOT delivers transportation projects. Your role will be pivotal in leveraging data insights to manage monthly lettings effectively, steering us towards meeting ambitious annual targets, and ensuring our agency stays on track to deliver projects.
If you are interested in being part of the TxDOT Team that is shaping the future of transportation in Texas, we invite you to apply!

Stassney Campus https://youtu.be/u42vEZacDgA

Minimum Salary: 64,500.00 Maximum Salary: 84,500.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 Hours a Week 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 website at: Total Compensation Package

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

Position Description

Performs moderately complex data analysis in support of the level letting activities & risk analysis process in the Design division. Work involves conducting detailed analysis, and interpretation to identify high risk projects, potential replacement projects, and make recommendations to meet level letting criteria. Responsible for using standard statistical tools, methods and techniques to translate data into actionable insights using data visualization software. Serves as primary coordinator with districts for level letting initiatives & changes. Work requires extensive contact with department staff, management, and external governmental agencies and organizations. Works under general supervision, with limited latitude for the use of initiative and independent judgment.

Essential Duties:

• Designs, develops, and maintains visualizations and reports utilizing data visualization tools and best practices.
• Interprets results to identify significant differences in data.
• Develops reports, dashboards and interactive visualizations using different components of Tableau software including Tableau desktop, Tableau Prep, and Tableau server.
• Prepares and makes presentations.
• Analyzes reports and dashboards to identify high risk projects and mitigate risk.
• Monitor dashboards and project information for trends and identify business needs.
• Develops tools, dashboards, and processes to facilitate the risk mitigation process and competing interests.
• Coordinates with divisions to confirm proposed replacement projects meet level letting criteria.
• Plans and coordinates activities associated with the delivery of highly complex business and information analyses, information repositories, and reporting/dashboard applications.
• Performs other job responsibilities 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:

• 2 years data analysis, statistics, compilation, and/or report writing experience; transportation project development.
• 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, OR 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.

Competencies:

Extensive knowledge of:

• Data analysis and interpretation
• Business processes and methodologies, data import and export protocols
• Knowledgeable of methods, processes, applications used in the analysis and creation of reports and dashboards.

Expert skill in:

• The use of technical tools such as Excel, Access, SQL and other heavy data analysis
• Developing and presenting reports in multiple formats, including Tableau
• Using Tableau, Microsoft Power BI, or Qlik

Proficient skill in:

• Maintaining effective working relationships with others
• Analyzing business, technical, and managerial problems and developing, recommending, and implementing effective solutions

Ability to:

• Communicate effectively
• Analyze data and derive informative conclusions.

Physical Requirements and Working Conditions:

• Sedentary work: Lift up to 10 lbs at a time and occasionally carry files/small tools
• Fingering-picking, pinching, typing; working primarily with fingers rather than whole hand
• Close Visual Acuity-work includes data/figures; view a computer screen; extensive reading

Conditions of Employment:

Please click this link to read the standard conditions of employment for all positions: Standard Conditions of Employment (TxDOT)

Job: Plan/Aviation/Pub Trans/Legis

Schedule: Full-time

Employee Status: Regular

Job Type: Standard

Job Level: Non-Management

Job Posting: May 13, 2025, 9:24:06 AM Unposting Date: May 29, 2025, 11:59:00 PM

State Job Title/s: Data Analyst III State Job Code/s: 0652

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.

To view the MOS codes please click on link below and click on the appropriate occupational category.

https://hr.sao.texas.gov/CompensationSystem/JobDescriptions

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.

Please click this link to read the information for applicants: Additional Applicant Information