ROW Data Analyst V

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

Job summary

Texas Department of Transportation in Austin seeks a data analyst to perform highly complex data analysis and research for the Right of Way Division's Contracts & Finance Section. You translate data into actionable insights, develop solutions to support business needs, and monitor data quality.

Collaboration with business areas is essential to identify opportunities for automation and reporting using Tableau, Power BI, SQL, and Snowflake.

Qualifications

• Bachelor’s Degree in a related discipline; experience may substitute for degree on a year-for-year basis.
• 4 years of experience in data analysis, research, compilation, and/or report writing.
• Valid driver's license; driving a state vehicle may be required.

Responsibilities

• Drives data management tool selection and develops standards and procedures.
• Develops and implements databases, data collection systems, and analytics.
• Identifies data gaps, errors, anomalies, and redundancies.
• Develops reports, dashboards and visualizations using Tableau/Power BI.
• Responds to requests to design, build, maintain or repair reports.

Skills

Data analysis

Data interpretation

Communication of technical information

Education

Bachelor's Degree in a related discipline

Tools

Tableau

Power BI

Excel

Access

SQL

Qlik

Job description

Performs highly complex data analysis and data research work for the Right of Way Division's Contracts & Finance Section. Work involves conducting detailed analysis and research, translating data into actionable insights, and developing solutions to support business needs. Identifies, monitors, and implements measures to improve data quality, integrity, and reliability.

Consults with business areas to understand customer needs and business processes and identify opportunities for data analysis, reporting, automation, and other technology solutions. Uses tools such as SQL, Tableau, Microsoft Power Automate, Microsoft Power Apps, Snowflake, and other approved technologies to analyze data, develop visualizations, improve data quality, and support practical business solutions.

Supports system modernization, process improvement, and emerging technology initiatives, including artificial intelligence and machine-learning tools, through data analysis, requirements development, validation, automation, prototyping, and technical testing.

May provide technical guidance and assist other analysts in developing skills in data quality, automation, emerging technologies, and tool maintenance. Works under limited supervision, with moderate latitude for the use of initiative and independent judgment.

This position operates within a values-driven environment where collaboration, integrity, and empathy are essential. Our team culture emphasizes transparency, mutual respect, and shared accountability.

Essential Duties

• Drives the selection of data management tools, and the development of standards, usage guidelines, and procedures for those tools.
• Defines, develops and implements data standards
• Develops and implements databases, data collection systems, data analytics, and other strategies that optimize statistical efficiency and quality.
• Identifies data gaps, errors, anomalies, inconsistencies, and redundancies by analyzing the content, structure, and relationships within data.
• Identifies and interprets data patterns and trends and assesses data quality.
• Develops data quality measures, analyzes data quality results, and implements necessary changes to ensure data quality improvement.
• Performs quality assurance and serves as a subject matter expert on data integrity, extraction, and compilation.
• Develops reports, dashboards and interactive visualizations using different components of Tableau software including Tableau desktop, Tableau Prep, and Tableau server.
• Responds to incoming requests from business areas to design, build, maintain or repair reports and applications.
• Coordinates with users to identify system requirements, develop functional design specifications to meet requirements, and solve complex operational problems.
• Analyzes new or existing procedures, information systems, or utility programs for effeciency and effectiveness.
• 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: 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.
  • Licenses and Certifications: Valid driver's license. This position requires driving a state vehicle.

Preferred Qualifications

• Project Management Professional (PMP) Certification

Competencies

• Extensive 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
  • Business technology support and consulting services

Expert skill in

• 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 Tableau, Microsoft Power BI, or Qlik
• Using computers, applicable programs, applications, and systems
• Use of applicable data visualization/ configuration tools such as Tableau Microsoft Power BI

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