Data Analyst​/Trainee

Position: Data Analyst 1/Trainee
Duties Description The Data Analyst 1 will be responsible for drafting technical requirements and data definitions to aid in transparency of the data models and data stored in ITS systems. The position will propose new data processes and improvements to existing processes. It will improve data extraction and aggregation from various source systems to ensure the proper flow of data and aid in improved consistency of data among the systems across New York State.

Duties include, but are not limited to:

* Monitor data imports from the source systems into the ITS systems.

* Analyze data to identify trends, patterns, anomalies or areas of opportunity to utilize data more effectively.

* Develop, maintain, and update dashboards, ad hoc reports, and visualizations to support ITS and partner agency reporting needs.

* Collaborate with cross-functional teams to define data needs, meet project objectives, and streamline data collection processes.

* Document methodologies, data definitions, and processes clearly for future reference and team awareness.

* Coordinate data migration, data integration, and quality assurance initiatives as needed.

* Implement data reliability checks, including validations, anomaly detection, and alerting for identified issues.

* Collaborate with developers to retrieve data via secure APIs, design caching and refresh strategies, and optimize performance.

Minimum Qualifications

Minimum Qualifications

Data Analyst 1 (Salary Grade 18)
-Non-competitive: six years of experience
* in data visualization, and statistical models and data mining tools.

Data Analyst Trainee 1 (equated to salary grade 14)
-Non-competitive: two years of experience
* in data visualization, and statistical models and data mining tools.

Data Analyst Trainee 2 (equated to salary grade 16)

• Non-competitive: four years of experience
* in data visualization, and statistical models and data mining tools.

* Substitution:
An associate's degree may substitute for two years of general experience or a bachelor's degree may substitute for four years of general experience. A master's degree in data or computer science, informatics, economics, statistics, mathematics, or a related field, may substitute for one year of general experience; or a Ph.D. in these fields may substitute for two years of general experience.

Preferred qualifications:

Preference for candidates holding relevant technology analyst certification, including but not limited to:

At least a bachelor's degree in computer science, analytics, or data science.

Strong SQL skills.

Experience integrating with diverse data sources, relational databases such as Postgres or SQL Server, flat files, APIs, and cloud object storage

Excellent verbal and written communication skills to effectively document and relay issues to cross-functional teams for resolution.

Demonstrated proficiency using data analysis and visualization tools (e.g., Excel, Tableau, Power BI, SAS, R, or Python).

Additional Comments

Please note:

• Appointment to this position and continued employment with the agency is contingent upon obtaining and/or maintaining New York State residency within six months of hiring.

• Appointment to this position is not final until all agency approvals have been granted

ITS will not offer permanent employment to any candidate unless the candidate provides documentation that they are authorized to accept work in the United States on a permanent basis. It is the policy of ITS not to hire F1 or H1 visa holders for permanent employment or to sponsor non-immigrant aliens for temporary work authorization visas or for permanent residence.

Some positions may require fingerprinting.

Some positions may require up to 25% travel and/or lifting up to 50 lbs. Some positions are pending Civil Service approval. Details of position(s) will be described further if you are selected for an interview.

If eligible, positions located in New York City will receive an additional $3,400 downstate adjustment location pay with regular annual salary. Positions located in the Mid-Hudson will receive an additional $1,650 adjustment location pay. to permanent non- competitive and the official probationary period will begin.

Benefi…