Data Analyst II - Maintenance Division at Texas Department of Transportation

Have a passion for working with data and leveraging data to improve business processes? TxDOT's Maintenance Division is seeking a Data Analyst II to support various maintenance support activities ranging from reviewing data quality in the Maintenance Management System (MMS), providing technical assistance on data entry and reporting within the MMS, and analyzing routine maintenance contract bidding and payment data. The ideal candidate will have some experience working with data, reviewing and developing charts and dashboards, and be willing to learn and adapt on the job as new data challenges arise.

%3Cp class=%22MsoNormal%22%3EAt TxDOT, we value work-life balance and are committed to providing our employees with a comprehensive range of benefits and programs, including:%3Co:p%3E%3C/o:p%3E%3C/p%3E%3Cul%3E%3Cli%3E%3Cp class=%22MsoNormal%22%3ERetirement Plans%3Co:p%3E%3C/o:p%3E%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22%3EAlternative and/or Flexible Work Schedules%3Co:p%3E%3C/o:p%3E%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22%3EPaid Leave and Holidays%3Co:p%3E%3C/o:p%3E%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22%3EHealth Premiums paid at 100% for Full-Time Employees%3Co:p%3E%3C/o:p%3E%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22%3EOn-the-Job Training%3Co:p%3E%3C/o:p%3E%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22%3ETuition Assistance Program%3Co:p%3E%3C/o:p%3E%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22%3EHolistic Wellness Program with Leave Incentives%3Co:p%3E%3C/o:p%3E%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22%3ECareer Development and Advancement Opportunities%3Co:p%3E%3C/o:p%3E%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22%3EFamily-Friendly Policies and Programs%3Co:p%3E%3C/o:p%3E%3C/p%3E%3C/li%3E%3C/ul%3E%3Cp class=%22MsoNormal%22%3EIn 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.%3Co:p%3E%3C/o:p%3E%3C/p%3E%3Cp class=%22MsoNormal%22%3EFor a complete list of our total compensation package please visit our website at: %3Ca target=%22_blank%22 rel=%22noopener noreferrer%22 href=%22https://www.txdot.gov/content/dam/docs/division/hrd/hrd-total-compensation.pdf%22%3ETotal Compensation Package%3C/a%3E%3Co:p%3E%3C/o:p%3E%3C/p%3E%3Cp class=%22MsoNormal%22%3ETo view benefits available to all State of Texas employees visit: %3Ca target=%22_blank%22 rel=%22noopener noreferrer%22 href=%22https://ers.texas.gov/benefits-at-a-glance%22%3EBenefits at a Glance | ERS (texas.gov)%3C/a%3E%3Co:p%3E%3C/o:p%3E%3C/p%3E
*!

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

Essential Duties:

• Creates and maintains standard reports and dashboards; collaborates with end users to gather report requirements and ensure proper testing and validation.
   
• Compiles and queries maintenance data and presents findings and observations to other TxDOT employees.
   
• Analyzes bid and payment data using standard statistical tools, methods, and techniques to identify opportunities for improvement.
   
• Creates regular schedule of data reviews and updates based on evolving business needs.
   
• Reviews programmatic data and identifies problems with data quality; works with end business unit to correct data.
   
• Supports offices statewide in areas of data entry and software troubleshooting in the MMS.
   
• Performs other job responsibilities as assigned.
  

*!

Minimum Qualifications:

Education: Bachelor's Degree in Mgmt Info Systems, Comp Science, Statistics, Mathematics, or related discipline. Relevant work experience may be substituted for degree on a year per year basis. Substitutions for Minimum Qualifications

Experience: 1 year 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.

 

Preferred Qualifications:

• Experience with highway operations and/or maintenance data preferred.
   
• Experience with Tableau or similar analytics platform also preferred.
   
• Experience with Python, R, or similar programming language desired.

 

Competencies:

Proficient skill in

• Using Tableau, Microsoft Power BI, or Qlik
   
• Communicating technical information effectively
   
• The use of technical tools such as Excel, Access, SQL and other heavy data analysis

Ability to

• Analyze data and derive informative conclusions
   
• Translate complex data into user-friendly information
   
• Build, establish, and maintain effective working relationships and coalitions

 

Physical Requirements and Working Conditions:

• 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 click this link to read the standard conditions of employment for all positions: Standard Conditions of Employment (TxDOT)

*!

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

*!

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

Apply Now