Data Analyst IV

Position Description

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.