ROW Data Analyst V

See the data. Understand the business. Build a better solution.

The Right of Way Division is looking for a Data Analyst who is both technically capable and customer focused. Our Data & Business Analytics team has a strong foundation in dashboards and reporting, and we’re looking to expand that capability into data quality, advanced analysis, automation, and emerging technologies. In this role, you’ll work with customers and subject-matter experts to understand their needs and business processes, analyze the data behind those processes, and help determine the best solution, whether that is a dashboard or report, a data-quality improvement, an automated workflow, or another technology solution. We’re looking for someone who is curious, comfortable asking questions and working through ambiguity, and able to turn both data and business needs into practical solutions. 

The ideal candidate will bring strong analytical and problem-solving skills, experience working with data and visualization tools, and an interest in expanding their capabilities in areas such as SQL, data quality, automation, Power Platform, and emerging AI technologies. Just as important, they should be able to communicate technical information clearly and collaborate effectively with both technical and nontechnical partners, and lead large, complex data and technology projects by coordinating stakeholders, defining solutions, and driving work through implementation.

In ROW, we foster a culture grounded in Respect, Honesty, Transparency, Trust, Kindness, Accountability, and Unity. We seek candidates who embody these values and contribute positively to our mission and community. 

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 Total Compensation Package website

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

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

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 read the Standard Conditions of Employment (TxDOT) for all positions.

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 Action of 1990.

Additional Applicant Information