Data Analyst I Or Ii

Data Analyst I:

Performs entry-level 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 close supervision, with minimal latitude for the use of initiative and independent judgment.

Data Analyst II:

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:

Data Analyst I: 

• Accesses information from business organization cross-sections to make good business decisions and provide excellent customer service.
• Compiles and queries data.
• Analyzes data using standard statistical tools, methods, and techniques
• Interprets results to identify significant differences in data.
• Assists in Identifying and interpreting data patterns and trends and assessing data quality.
• Performs other job responsibilities as assigned.

Data Analyst II:

• Creates new standard reports; collaborating with end users to gather report requirements and ensure proper testing and validation.
• Assists in preparing concise, comprehensive technical reports to present and interpret data, identify alternatives, and
  make and justify recommendations on data revisions.
• Compiles and queries data.
• Analyzes data using standard statistical tools, methods, and techniques.
• Interprets results to identify significant differences in data.
• Cleans and prunes data to discard irrelevant information.
• Writes programs and/or queries for spreadsheet or database software to create reports and import/export data.
• Performs other job responsibilities as assigned.

Minimum Qualifications:

Data Analyst I:

Education: Bachelor's Degree of any discipline with programming language skills. Relevant work experience may be substituted for degree on a year per year basis. Substitutions for Minimum Qualifications

Experience: No experience required.

Licenses and Certifications: Valid driver's license. This position requires driving a state vehicle.

Data Analyst II:

Education: Bachelor's Degree of any discipline with programming language skills. Relevant work experience may be substituted for degree on a year per year basis. Substitutions for Minimum Qualifications

Experience: 1 year data analysis, research, compilation, and/or report writing and design work experience.
(Experience can be satisfied by fulltime or prorated part time equivalent)

Licenses and Certifications: Valid driver's license. This position requires driving a state vehicle.

Competencies:

Data Analyst I:

• Data analysis and interpretation
• Using computers and applicable programs, applications, and systems
• Communicating technical information effectively
• The use of technical tools such as Excel, Access, SQL and other heavy data analysis
• Developing and presenting reports in multiple formats
• Analyze data and derive informative conclusions.
• Effectively organize and prioritize work demands in a fast-paced environment

Data Analyst II: All of the above and: 

• Evaluate and make recommendations regarding data integrity
• Protects sensitive and confidential information

Physical Requirements and Working Conditions:

• Sitting - prolonged periods of time
• 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)