Data Analyst IV

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 Data Analyst IV. Come join our team at our beautiful, new Stassney campus in Austin, where you will have access to 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!

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

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 Data Analyst IV. Come join our team at our beautiful, new Stassney campus in Austin, where you will have access to 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!

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

Stassney Hq - Main (SHQMAIN)
6230 East Stassney Lane
Austin, 78744

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)

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)

The Data Analyst IV performs advanced analytical, reporting, systems, and business intelligence work supporting the Financial Management Division's operational, financial, and strategic objectives. The position develops and maintains dashboards, reports, data integrations, automation solutions, and reporting environments while serving as a liaison between business stakeholders and technical resources. The role is responsible for transforming complex data into meaningful insights, supporting enterprise systems, streamlining business processes, and recommending technology-based solutions that improve efficiency and decision-making.

Essential Duties:

• Serve as a functional resource for division business systems, reporting platforms, and enterprise data repositories.
• Design, develop, and maintain automated reporting, dashboards, workflows, and business solutions that improve operational efficiency and data accessibility.
• Utilize Power Platform, SQL, scripting, data integrations, and other technologies to automate processes and reduce manual effort.
• Utilize AI tools such as Microsoft Copilot and Google Gemini, and apply them to streamline analytical workflows, automate repetitive tasks, and validate AI-generated outputs for accuracy.
• Lead or support technology, reporting, and business process improvement initiatives, including requirements gathering, solution design, testing, implementation, and deployment.
• Identifies data gaps, errors, anomalies, inconsistencies, and redundancies by analyzing the content, structure, and relationships within data.
• Develop and maintain data connections across multiple enterprise systems and support data extraction, transformation, and loading (ETL) processes.
• Create and maintain system documentation, including business requirements, business rules, data definitions, procedures, and reporting structures.
• Coordinate with IT staff, vendors, and business partners to resolve technical issues and support system enhancements.
• Analyze data to identify gaps, errors, anomalies, inconsistencies, and redundancies while ensuring compliance with agency security, governance, and data quality standards.
• Present complex analytical findings to management and external stakeholders, tailor messaging to varied audiences, and prepare written recommendations
• Other duties as assigned

The Data Analyst IV performs advanced analytical, reporting, systems, and business intelligence work supporting the Financial Management Division's operational, financial, and strategic objectives. The position develops and maintains dashboards, reports, data integrations, automation solutions, and reporting environments while serving as a liaison between business stakeholders and technical resources. The role is responsible for transforming complex data into meaningful insights, supporting enterprise systems, streamlining business processes, and recommending technology-based solutions that improve efficiency and decision-making.

Essential Duties:

• Serve as a functional resource for division business systems, reporting platforms, and enterprise data repositories.
• Design, develop, and maintain automated reporting, dashboards, workflows, and business solutions that improve operational efficiency and data accessibility.
• Utilize Power Platform, SQL, scripting, data integrations, and other technologies to automate processes and reduce manual effort.
• Utilize AI tools such as Microsoft Copilot and Google Gemini, and apply them to streamline analytical workflows, automate repetitive tasks, and validate AI-generated outputs for accuracy.
• Lead or support technology, reporting, and business process improvement initiatives, including requirements gathering, solution design, testing, implementation, and deployment.
• Identifies data gaps, errors, anomalies, inconsistencies, and redundancies by analyzing the content, structure, and relationships within data.
• Develop and maintain data connections across multiple enterprise systems and support data extraction, transformation, and loading (ETL) processes.
• Create and maintain system documentation, including business requirements, business rules, data definitions, procedures, and reporting structures.
• Coordinate with IT staff, vendors, and business partners to resolve technical issues and support system enhancements.
• Analyze data to identify gaps, errors, anomalies, inconsistencies, and redundancies while ensuring compliance with agency security, governance, and data quality standards.
• Present complex analytical findings to management and external stakeholders, tailor messaging to varied audiences, and prepare written recommendations
• Other duties 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:

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.

Preferred Qualifications:

• Bachelor's degree in Data Analytics, Information Systems, Computer Science, Business Administration, Finance, Public Administration, Statistics, Mathematics is highly preferred

Competencies:

• Serve as a functional resource for division business systems, reporting platforms, and enterprise data repositories.
• Design, develop, and maintain automated reporting, dashboards, workflows, and business solutions that improve operational efficiency and data accessibility.
• Utilize Power Platform, SQL, scripting, data integrations, and other technologies to automate processes and reduce manual effort.
• Utilize AI tools such as Microsoft Copilot and Google Gemini to streamline analytical workflows, automate repetitive tasks, and validate AI-generated outputs for accuracy.
• Lead or support technology, reporting, and business process improvement initiatives, including requirements gathering, solution design, testing, implementation, and deployment.
• Develop and maintain data connections across multiple enterprise systems and support data extraction, transformation, and loading (ETL) processes.
• Create and maintain system documentation, including business requirements, business rules, data definitions, procedures, and reporting structures.
• Coordinate with IT staff, vendors, and business partners to resolve technical issues and support system enhancements.
• Analyze data to identify gaps, errors, anomalies, inconsistencies, and redundancies while ensuring compliance with agency security, governance, and data quality standards.
• Present complex analytical findings, recommendations, and reports to management and stakeholders, tailoring communications to diverse audiences.

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

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:

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.

Preferred Qualifications:

• Bachelor's degree in Data Analytics, Information Systems, Computer Science, Business Administration, Finance, Public Administration, Statistics, Mathematics is highly preferred

Competencies:

• Serve as a functional resource for division business systems, reporting platforms, and enterprise data repositories.
• Design, develop, and maintain automated reporting, dashboards, workflows, and business solutions that improve operational efficiency and data accessibility.
• Utilize Power Platform, SQL, scripting, data integrations, and other technologies to automate processes and reduce manual effort.
• Utilize AI tools such as Microsoft Copilot and Google Gemini to streamline analytical workflows, automate repetitive tasks, and validate AI-generated outputs for accuracy.
• Lead or support technology, reporting, and business process improvement initiatives, including requirements gathering, solution design, testing, implementation, and deployment.