Data and Reporting Risk Analyst I (Letting Data Analyst I) - Design Division - Austin, TX

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

Job summary

The Texas Department of Transportation is seeking a Data Analyst to perform complex data analysis to support level letting activities. The role involves using statistical tools and data visualization software to identify high-risk projects and make actionable recommendations. Candidates should possess a Bachelor's degree and have at least 2 years of relevant experience. Strong knowledge of data analysis, business processes, and tools like Tableau and Excel is essential.

Qualifications

• 2 years data analysis, statistics, and report writing experience.
• Experience can be satisfied by full-time or part-time equivalent.

Responsibilities

• Designs and develops visualizations and reports using data visualization tools.
• Analyzes reports to identify high risk projects and mitigate risk.
• Coordinates activities associated with complex business analyses.

Skills

Data analysis

Communication

Problem Solving

Education

Bachelor's degree in a related discipline

Tools

Tableau

Excel

SQL

Microsoft Power BI

Job description

Performs moderately complex data analysis in support of the level letting activities & risk analysis process in the Design division. Work involves conducting detailed analysis, and interpretation to identify high risk projects, potential replacement projects, and make recommendations to meet level letting criteria. Responsible for using standard statistical tools, methods and techniques to translate data into actionable insights using data visualization software. Serves as primary coordinator with districts for level letting initiatives & changes. Work requires extensive contact with department staff, management, and external governmental agencies and organizations. Works under general supervision, with limited latitude for the use of initiative and independent judgment.

Essential Duties:

• Designs, develops, and maintains visualizations and reports utilizing data visualization tools and best practices.
• Interprets results to identify significant differences in data.
• Develops reports, dashboards and interactive visualizations using different components of Tableau software including Tableau desktop, Tableau Prep, and Tableau server.
• Prepares and makes presentations.
• Analyzes reports and dashboards to identify high risk projects and mitigate risk.
• Monitor dashboards and project information for trends and identify business needs.
• Develops tools, dashboards, and processes to facilitate the risk mitigation process and competing interests.
• Coordinates with divisions to confirm proposed replacement projects meet level letting criteria.
• Plans and coordinates activities associated with the delivery of highly complex business and information analyses, information repositories, and reporting/dashboard applications.
• 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:

• 2 years data analysis, statistics, compilation, and/or report writing experience; transportation project development.
• 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, OR 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.

Competencies:

Extensive knowledge of:

• Data analysis and interpretation
• Business processes and methodologies, data import and export protocols
• Knowledgeable of methods, processes, applications used in the analysis and creation of reports and dashboards.

Expert skill in:

• The use of technical tools such as Excel, Access, SQL and other heavy data analysis
• Developing and presenting reports in multiple formats, including Tableau
• Using Tableau, Microsoft Power BI, or Qlik

Proficient skill in:

• Maintaining effective working relationships with others
• Analyzing business, technical, and managerial problems and developing, recommending, and implementing effective solutions

Ability to:

• Communicate effectively
• Analyze data and derive informative conclusions.

Physical Requirements and Working Conditions:

• Sedentary work: Lift up to 10 lbs at a time and occasionally carry files/small tools
• 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)