Data Analyst II, or III - TPP Division - Austin, TX

TxDOT's Transportation Planning and Programming (TPP) Division is looking for a Data Analyst based in Austin, TX, who is passionate about data and is experienced in SQL, creating data driven reports, and responding to data requests; having experience with linear referencing data is a plus. As a Data Analyst in TPP, you will be responsible for assisting in the maintenance of data in the division's geospatial roadway inventory database, as well as providing solutions to improve processes, and daily workflows. The successful candidate will also act as a liaison between the division and TxDOT's district personnel. 

Stassney Campus https://youtu.be/u42vEZacDgA

• Data Analyst II - B20 Salary Range $65,000.00 - $72,500.00
• Data Analyst III - B22 Salary Range $72,500.00 - $80,000.00

****The Texas Department of Transportation reserves the sole right in determining the level of position based on the applicant’s work experience, education, skill level, and all other appropriate factors, and based on business needs. 

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)

Data Analyst Ii:

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.

Data Analyst Iii:

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.

Essential Duties:

Data Management Data Analyst Ii:

• Develops and maintains report standards that encompass multiple data systems for internal and external clients.
• Modifies existing reports and/or develops new reports by analyzing databases, data sources, and structures for the benefit of users
• Accesses information from business organization cross-sections to make good business decisions and provide excellent customer service.
• Consults with internal and external customers to identify user needs.
• Compiles and queries data.
• Interprets results to identify significant differences in data.
• Cleans and prunes data to discard irrelevant information.
• Responds to incoming requests from business areas to design, build, maintain or repair reports and applications.
• Writes programs and/or queries for spreadsheet or database software to create reports and import/export data.
• Performs other job responsibilities as assigned.
• Data Management Data Analyst III:
• All of the above and:
• Participates in preparing and conducting presentations of performance visualizations and reports.
• Identifies and interprets data patterns and trends and assesses data quality.

Minimum Qualifications:

Data Analyst Ii:

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 OR related graduate level education may be substituted for               experience 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 a full-time or prorated part-time equivalent. 

Licenses and Certifications: Valid driver’s license. This position requires driving a state vehicle.

Data Analyst Iii:

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 OR related graduate level education may be substituted for               experience on a year per year basis. Substitutions for Minimum Qualifications

Experience:

• 2 years of experience in data analysis, research, compilation, and/or report writing and design work experience. 
• Experience can be satisfied by a full-time or prorated part-time equivalent. 
• Licenses and Certifications: Valid driver’s license. This position requires driving a state vehicle.
• Preferred Qualifications: Preferred experience with SQL, Python, and Linear Referencing
• Experience can be satisfied by a full-time or prorated part-time equivalent. 
• Licenses and Certifications: Valid driver’s license. This position requires driving a state vehicle.
• Preferred Qualifications: Preferred experience with SQL, Python, and Linear Referencing

Competencies:

Data Analyst Ii:

• Business processes and methodologies, data import and export protocols
• 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
• Using computers, applicable programs, applications, and systems
• Analyze data and derive informative conclusions.
• Build, establish, and maintain effective working relationships and coalitions
• Exercises logic and reasoning to define problems, establish facts and draw valid conclusions; makes decisions that support business objectives and goals

Data Analyst Iii:

• Developing and presenting reports in multiple formats
• Evaluate and make recommendations regarding data integrity

Physical Requirements And Working Conditions:

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