Financial/Data Analyst III

Position Information

Home to SXSW, Austin City Limits (ACL), and glorious natural springs and parks, Austin, Texas, is one of the fastest-growing areas in the United States, as well as the Live Music Capital of the World. Austin is the historic state capital of Texas and is the location of the Texas Department of Transportation Headquarters. TxDOT's Financial Management Division is seeking a Letting Data Analyst III. Come join our team at our beautiful, new Stassney campus in Austin, where you will enjoy a hybrid work schedule (with minimal in-person days), covered employee parking, walking trails, on-site fitness center, coffee bar, and on-site cafeteria. We have a diverse workforce of over 13,000 employees statewide. If you want to build an exciting career, let's talk!

At TxDOT we value employee work-life-balance. In keeping with our commitment to this value our employees benefit from a wide array of programs and activities that include telework, flexed and compressed work schedules, wellness leave incentive, in-house fitness center, career development programs, tuition assistance, and various other benefits. For a complete list of our total compensation package please visit our website at: https://ftp.dot.state.tx.us/pub/txdot-info/hrd/careers/hidden_benefits.pdf

Stassney Campus: https://youtu.be/u42vEZacDgA

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

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

Position Description

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. Performs advanced transportation programming, letting project scheduling, and federal funding preparation and analysis work. Oversees projects/grants/programs/lettings to include application, approval, monitoring, audits, investigations, and authorizing funding. 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:

• Create new and/or improves existing financial models and reports for federal and state-funded project obligations, track funding levels & utilization and streamline processes & procedures.
• Develops and modifies reports, dashboards and interactive visualizations using different components of Tableau software including Tableau desktop, Tableau Prep, and Tableau server.
• Oversees project data integrity and quality control processes; ensure accuracy/consistency of internal and external reports.
• Serves as a project leader; coordinates project activities to support the implementation of agency & finance division initiatives, new and/or revised state & federal legislation and streamline processes.
• Prepares, reviews, and distributes letting, project funding, federal/state funds management reports and/or presentations for Commission & quarterly review meetings, senior leadership, and statewide initiatives.
• Coordinates project scheduling, programming, and funding review/approval for assigned division(s) and/or districts within TXDOTCONNECT, the Department's Category Analysis, Federal Aid Funding Obligation System (FAFOS) and Financial Management Information System (FIMS).
• Monitors financial constraint of assigned division and/or districts' construction funding allocations, as established annually by the Chief Financial Officer in accordance with the agency's Cash Forecast.
• Develops and implements procedures to ensures compliance with federal and state laws, regulations, policies and procedures, and standards pertaining to programs.
• Serves as liaison and contact in area(s) of expertise. Trains branch and team members on development of reports using Tableau, Excel, and other software solutions.
• Performs other job responsibilities as assigned.

Minimum Qualifications:

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

Preferred Qualifications:

• Bachelors degree in Management of Information Systems, Computer Science, Statistics, Mathematics, highly preferred.
• Experience in developing and analyzing complex reports is highly preferred.

Competencies:

Extensive knowledge of -

• Financial management and accounting systems
• Working with streaming data and unstructured data from multiple data sources
• The use of technical tools such as Excel, Access, SQL and other heavy data analysis
• Developing and presenting reports in multiple formats

Considerable knowledge of -

• Budgeting methods and procedures
• Reporting standards and data management using Tableau and Excel
• Applicable laws, rules, and regulations
• Modifies existing reports and/or develops new reports by analyzing databases, data sources, and structures for the benefit of users
• Assists in identifying and interpreting data patterns and trends and assessing data quality.
• Financial management and accounting systems

Expert skill in -

• Interpreting applicable information
• Responding to incoming requests from business areas on reports and applications.
• Monitoring the status and progress of projects
• Evaluate and make recommendations regarding data integrity

Proficient skill in -

• Exercises logic and reasoning to define problems, establish facts and draw valid conclusions; makes decisions that support business objectives and goals
• Public relations for maintaining effective working relationships with individuals and groups, both internal and external
• Analyzing and organizing business, financial, and technical data
• Working with streaming data and unstructured data from multiple data sources
• Ability to communicate effectively

Physical Requirements and Working Conditions:

• Sedentary work: Lift up to 10 lbs at a time and occasionally carry files/small tools
• Standing-prolonged periods of time
• Repetitive Motion-substantial movements of the wrists, hands, and/or fingers
• 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)