STIP Data Analyst III, IV, or V - TPP Division - Austin, TX

Job Description - STIP Data Analyst III, IV, or V - TPP Division - Austin, TX (2602427) Job Description STIP Data Analyst III, IV, or V - TPP Division - Austin, TX - ( 2602427 ) Position Information The Statewide Transportation Improvement Program (STIP) Branch is seeking a highly skilled and motivated Data Analyst III -V to support critical statewide transportation planning and programming efforts. This position plays a key role in managing, analyzing, and validating transportation project data associated with the STIP, including coordination with Metropolitan Planning Organizations (MPOs), TxDOT Districts, and federal partners. The selected candidate will perform advanced data analysis, develop and maintain data quality controls, support consistency reviews between planning documents (e.g., STIP, TIP, and long-range plans), and contribute to process improvements and system enhancements such as automation and the eSTIP platform. Responsibilities include interpreting federal and state requirements, preparing reports and decision-support tools, and ensuring accuracy and compliance in project programming data. Ideal candidates will demonstrate strong analytical skills, proficiency in data tools (e.g., Excel, databases, data visualization tool, or programming languages), attention to detail, and the ability to collaborate across multidisciplinary teams. Experience with transportation planning, project programming, or public‑sector data systems is highly desirable. Stassney Campus Data Analyst III - B22 - Salary Range $75,000.00 - $85,000.00 Data Analyst IV - B24 - Salary Range $85,000.00 - $95,000.00 Data Analyst V - B26 - Salary Range $95,000.00 - $105,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. Minimum Salary 75,000.00 Maximum Salary 105,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 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 T otal Compensation Package website To view benefits available to all State of Texas employees visit Benefits at a Glance | ERS (texas.gov) 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. 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 V Performs highly 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. Serves as a project lead. Works under limited supervision, with moderate latitude for the use of initiative and independent judgment. Responsibilities for Data Analyst III Analyzing, validating, and maintaining Statewide Transportation Improvement Program (STIP) project data to ensure accuracy and completeness. Supports Statewide Transportation Improvement Program (STIP) development and quarterly revision activities, including data entry, updates, and basic reconciliation tasks. Coordination efforts with MPOs, TxDOT districts, and internal staff to collect and verify project information. Generates standard reports, summaries, and data outputs to support program tracking and analysis. Provides support for STIP review and approval processes, including documentation tracking and data compilation. Works under established guidelines and procedures for Statewide Transportation Improvement Program(STIP) data management activities. Responsibilities for Data Analyst IV Independently analyzes, validates, and maintains Statewide Transportation Improvement Program(STIP) project data, ensuring compliance with state and federal requirements. Coordinates with MPOs, TxDOT districts, and internal divisions to review and reconcile project data across Transportation Improvement Program (TIP), Statewide Transportation Improvement Program(STIP), and long-range planning documents. Performs detailed data quality reviews, including fiscal constraint checks, project grouping validation, and consistency analyses. Develops and maintains reports, dashboards, and analytical tools to support program monitoring and decision-making. Supports Statewide Transportation Improvement Program(STIP) development and revision processes, including preliminary review, comment resolution, and stakeholder coordination. Provides technical assistance and guidance to Metropolitan Planning Organizations (MPOs) and staff on data requirements, tools, and processes. Identifies and implements process improvements and contributes to enhancements of Statewide Transportation Improvement Program(STIP) data systems and workflows. Responsibilities for Data Analyst V Leads advanced analysis, validation, and oversight of Statewide Transportation Improvement Program(STIP) project data to ensure statewide consistency, accuracy, and regulatory compliance. Oversees and coordinates Statewide Transportation Improvement Program(STIP) data review processes across MPOs, districts, and divisions, resolving complex data and programming issues. Directs the development of complex analytical products, dashboards, and decision-support tools to support statewide planning and programming activities. Provides expert‑level guidance on Statewide Transportation Improvement Program (STIP) policies, data standards, and federal requirements to ensure program compliance. Leads process improvements, data governance initiatives, and system enhancements (e.g., e-STIP and related tools). Represents the Statewide Transportation Improvement Program (STIP) program in internal and external meetings, stakeholder coordination efforts, and interagency collaboration activities. Leads, train, and mentor staff; reviews work products and provides leadership on complex or high-priority assignments. Minimum Qualifications Data Analyst III Education Bachelor's Degree in a related discipline. 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. Data Analyst III Licenses and Certifications Valid driver’s license. This position requires driving a state vehicle. Data Analyst IV Education Bachelor's Degree in a related discipline. 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. Data Analyst IV Licenses and Certifications Valid driver’s license. This position requires driving a state vehicle. Data Analyst V Education Bachelor's Degree in a related discipline. 4 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. Data Analyst V Licenses and Certifications Valid driver’s license. This position requires driving a state vehicle. Preferred Qualifications Advanced Microsoft Excel skills, including data analysis, pivot tables, complex formulas, dashboards, reporting, and process automation. Data Analyst III Additional Qualifications Data Analysis: Ability to collect, clean, validate, and analyze structured datasets to identify trends, inconsistencies, and actionable insights. Data Management: Knowledge of data quality control practices, data governance principles, and methods for maintaining accurate, reliable datasets. Visualization & Reporting: Skill in developing clear, effective dashboards and reports using tools such as Tableau, Power BI, and Excel. Data Visualization Standards: Ability to design visualizations that are consistent, accessible, and aligned with organizational guidelines and best practices. Technical Tools: Some skill using advanced Excel functions, data modeling, and database or analytical tools used for data processing and reporting. Communication: Ability to translate technical data into clear, concise reports and visual insights for technical and non-technical stakeholders. Initiative & Adaptability: Ability to manage multiple priorities, adapt to evolving tools and processes, and contribute to continuous improvement efforts. AI Tools: Knowledge of AI tools such as Microsoft Copilot and Google Gemini, and the ability to use them to support data analysis, report drafting, and routine productivity tasks. Data Analyst IV Additional Qualifications Data Analysis: Strong ability to independently design and conduct complex analyses across multiple datasets, resolve data inconsistencies, and develop actionable recommendations. Data Management: Considerable knowledge of data quality and governance practices, with the ability to develop validation procedures, monitor data integrity, and recommend process improvements. Visualization & Reporting: Advanced skill in designing interactive dashboards and recurring reports that communicate complex data to diverse audiences and support ongoing program monitoring. Data Visualization Standards: Ability to apply and promote visualization standards, review work products for consistency and accessibility, and recommend improvements to guidelines. Technical Tools: Proficient skill using advanced Excel, data modeling, and database or analytical tools, including the ability to automate processes, build complex data models, and troubleshoot technical issues. Communication: Ability to present complex analytical findings to management and external stakeholders, tailor messaging to varied audiences, and prepare written recommendations. Initiative & Adaptability: Ability to independently manage complex, competing priorities, adapt workflows to changing requirements, and identify and implement process improvements. AI Tools: Working knowledge of AI tools such as Microsoft Copilot and Google Gemini, with the ability to apply them to streamline analytical workflows, automate repetitive tasks, and validate AI-generated outputs for accuracy. Data Analyst V Additional Qualifications Data Analysis: Advanced ability to lead complex, cross-program analytical efforts, define analytical approaches and methodologies, and deliver strategic insights that inform executive decision-making. Data Management: Extensive knowledge of data governance frameworks, with the ability to establish data quality standards, policies, and procedures, and oversee data integrity across programs or systems. Visualization & Reporting: Expert skill in directing the design and development of enterprise‑level dashboards and reporting solutions, and in guiding reporting strategy to meet organizational performance and decision‑making needs. Data Visualization Standards: Ability to develop, establish, and maintain organizational visualization standards and accessibility guidelines, and ensure consistent adoption across teams. Technical Tools: Expert skill using analytical and database tools, with the ability to evaluate and recommend tools and technologies, design scalable data solutions, and provide technical guidance to staff. Communication: Ability to communicate strategic data insights to executive leadership, partner agencies, and external stakeholders, and to represent the organization in discussions on data‑related initiatives and policy. Initiative & Adaptability: Ability to lead continuous improvement initiatives, anticipate organizational data needs, drive adoption of new tools and processes, and mentor and train staff. AI Tools: Advanced knowledge of AI tools such as Microsoft Copilot and Google Gemini, with the ability to identify opportunities for AI integration, establish guidelines for responsible and accurate use, and guide staff in applying AI to data analysis and reporting. Physical Requirements and Working Conditions Primarily sedentary work performed in an office environment; may involve prolonged sitting, standing, and computer use. Frequent use of a computer, keyboard, and standard office equipment. Occasional bending, lifting, or carrying items up to 10–15 pounds (e.g., files, laptops, or materials). May require occasional travel for meetings, training, or coordination with MPOs, districts, or partner agencies. Work is performed in a standard office setting with minimal exposure to adverse environmental conditions. 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 Act of 1990. #J-18808-Ljbffr Taleo