Texas Department of Transportation
Data Analyst II - Maintenance Division
Texas Department of Transportation, Austin, Texas, us, 78716
Overview
Performs routine data analysis and data research work. Work involves conducting detailed analysis and extensive research on data and providing results in various formats. Responsible for using standard statistical tools, methods and techniques to translate data into actionable insights using data visualization software. Works under moderate supervision, with limited latitude for the use of initiative and independent judgment. Essential Duties
Creates and maintains standard reports and dashboards; collaborates with end users to gather report requirements and ensure proper testing and validation. Compiles and queries maintenance data and presents findings and observations to other TxDOT employees. Analyzes bid and payment data using standard statistical tools, methods, and techniques to identify opportunities for improvement. Creates regular schedule of data reviews and updates based on evolving business needs. Reviews programmatic data and identifies problems with data quality; works with end business unit to correct data. Supports offices statewide in areas of data entry and software troubleshooting in the MMS. 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:
1 year 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 drivers license. This position requires driving a state vehicle. Preferred Qualifications
Experience with highway operations and/or maintenance data preferred. Experience with Tableau or similar analytics platform also preferred. Experience with Python, R, or similar programming language desired. Competencies
Proficient skill in Using Tableau, Microsoft Power BI, or Qlik Communicating technical information effectively The use of technical tools such as Excel, Access, SQL and other heavy data analysis Ability Analyze data and derive informative conclusions Translate complex data into user-friendly information Build, establish, and maintain effective working relationships and coalitions Physical Requirements and Working Conditions
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 for all positions: Standard Conditions of Employment (TxDOT) #J-18808-Ljbffr
Performs routine data analysis and data research work. Work involves conducting detailed analysis and extensive research on data and providing results in various formats. Responsible for using standard statistical tools, methods and techniques to translate data into actionable insights using data visualization software. Works under moderate supervision, with limited latitude for the use of initiative and independent judgment. Essential Duties
Creates and maintains standard reports and dashboards; collaborates with end users to gather report requirements and ensure proper testing and validation. Compiles and queries maintenance data and presents findings and observations to other TxDOT employees. Analyzes bid and payment data using standard statistical tools, methods, and techniques to identify opportunities for improvement. Creates regular schedule of data reviews and updates based on evolving business needs. Reviews programmatic data and identifies problems with data quality; works with end business unit to correct data. Supports offices statewide in areas of data entry and software troubleshooting in the MMS. 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:
1 year 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 drivers license. This position requires driving a state vehicle. Preferred Qualifications
Experience with highway operations and/or maintenance data preferred. Experience with Tableau or similar analytics platform also preferred. Experience with Python, R, or similar programming language desired. Competencies
Proficient skill in Using Tableau, Microsoft Power BI, or Qlik Communicating technical information effectively The use of technical tools such as Excel, Access, SQL and other heavy data analysis Ability Analyze data and derive informative conclusions Translate complex data into user-friendly information Build, establish, and maintain effective working relationships and coalitions Physical Requirements and Working Conditions
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 for all positions: Standard Conditions of Employment (TxDOT) #J-18808-Ljbffr