Data Analyst 1/Trainee 1/Trainee 2

About the Role

Under the direction of Data Analyst 2, Data Analyst 1 will devise methods for identifying data patterns and trends in data sources. This role supports and collaborates with other NYSDOT program areas to service the Data needs of the Department. Responsibilities may include serving a role within the Incident Command System to support the department’s response to regional and statewide emergency situations.

Key Responsibilities

• Perform data extraction, aggregation, and quality checks from multiple sources and tables in support of trend identification and root cause analysis.
• Develop charts, graphs, tables, and graphics to interpret and present data in a meaningful way.
• Communicate insights and recommendations effectively.
• Contribute to data dictionary use, standards, training, and ongoing updates.
• Contribute to improving business performance and driving data-driven decision-making.
• Collaborate with other Data Analysts and management across the Department to develop and build analytic models in support of policy development and budgetary proposals.
• Take ownership of individual projects to move collaborations forward.
• Utilize advanced analytical techniques to predict future infrastructure conditions and needs.
• Leverage programming expertise to build unique datasets and analytical programs.
• Filter and clean data by reviewing computer reports, printouts, and performance indicators to locate and correct code and data problems.
• Verify data quality to ensure accurate analysis and reporting.
• Develop and implement databases, data collection systems and data analysis activities.
• Acquire data from primary or secondary data sources.

Requirements & Tech Stack

• Data extraction
• Data aggregation
• Data quality checks
• Data visualization (charts, graphs, tables, graphics)
• Data interpretation
• Data presentation
• Data dictionary
• Business performance improvement
• Data-driven decision-making
• Analytic models
• Advanced analytical techniques
• Programming expertise
• Data cleaning
• Code and data problem correction
• Database development
• Data collection systems
• Data analysis activities
• Primary and secondary data sources
• Potentially a role within the Incident Command System

Qualifications

Data Analyst Trainee 1

• Bachelor’s degree in data or computer science, informatics, economics, statistics, mathematics, or a related field.

Data Analyst Trainee 2

• Bachelor’s degree in data or computer science, informatics, economics, statistics, mathematics, or a related field.
• One year of experience* in advanced excel analysis.

Data Analyst 1

• Bachelor’s degree.
• Either:
• Satisfactory completion of a two-year traineeship.
• Two years of experience* in data visualization, statistical models, and data mining tools.

Substitution

• A Master’s degree in data or computer science, informatics, economics, statistics, mathematics, or a related field, may substitute for one year of specialized experience.
• A Ph.D. in the above fields may substitute for two years of specialized experience.