Data Analyst 2
About The Position
Under the direction of an Information Technology Architect 2, within Human Resources (HR) Department, the Data Analyst 2, SG-23, will be responsible for providing leadership on a wide range of projects, from creating dashboards and ad-hoc analyses to leading migration and identifying anomalies in the various data sources. This position will be supporting the transition to Workday. The successful candidate will play a key role in data management, data analytics/reporting, and data ingestion for the HR team. Specific duties shall include, but are not limited to: Lead and provide subject matter expertise for the data aspects of the Workday migration, from the projects to establish APIs to data modeling to reporting configuration. Establish an expert understanding of various New York State data sources and their relationship with each other. Develop, maintain, and update dashboards, ad hoc reports, and visualizations to support HR and agency reporting needs. Define data needs, meet project objectives, and streamline data collection processes in collaboration with cross-functional teams. Develop methodologies, data definitions, and processes clearly for future reference and team awareness. Lead data migration, data integration, and quality assurance initiatives as needed. Implement and continuously improve data reliability checks, including validations, anomaly detection, and alerting for identified issues. Analyze and proactively propose recommendations based on data trends, patterns, anomalies, or areas of opportunity to utilize data more effectively. Implement data pipelines (including APIs), data models, and ETL, as needed, to ensure data flows into Workday effectively in collaboration with the development team. Collaborate with the Business Systems Analyst 2 to document requirements, data models, and design solutions.
Requirements
- seven years of experience in data visualization, and statistical models and data mining
- 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.
Nice To Haves
- At least a bachelor's degree in computer science, analytics, or data science.
- 5+ years of hands-on experience with SQL and ETL processes.
- Experience integrating with diverse data sources, relational databases such as Postgres or SQL Server, flat files, APIs, and cloud object storage
- Advanced expertise in data analysis and visualization tools (e.g., Excel, Tableau, Power BI, SAS, R, or Python).
- Excellent verbal and written communication skills to effectively document and relay issues to cross-functional teams for resolution.
Responsibilities
- Lead and provide subject matter expertise for the data aspects of the Workday migration, from the projects to establish APIs to data modeling to reporting configuration.
- Establish an expert understanding of various New York State data sources and their relationship with each other.
- Develop, maintain, and update dashboards, ad hoc reports, and visualizations to support HR and agency reporting needs.
- Define data needs, meet project objectives, and streamline data collection processes in collaboration with cross-functional teams.
- Develop methodologies, data definitions, and processes clearly for future reference and team awareness.
- Lead data migration, data integration, and quality assurance initiatives as needed.
- Implement and continuously improve data reliability checks, including validations, anomaly detection, and alerting for identified issues.
- Analyze and proactively propose recommendations based on data trends, patterns, anomalies, or areas of opportunity to utilize data more effectively.
- Implement data pipelines (including APIs), data models, and ETL, as needed, to ensure data flows into Workday effectively in collaboration with the development team.
- Collaborate with the Business Systems Analyst 2 to document requirements, data models, and design solutions.
Benefits
- Thirteen (13) paid holidays annually
- Up to Thirteen (13) days of paid vacation leave annually
- Up to Five (5) days of paid personal leave annually
- Up to Thirteen (13) days of paid sick leave annually for PEF.
- Up to three (3) days of professional leave annually to participate in professional development
- Eligible employees and dependents can pick from a variety of affordable health insurance programs
- Family dental and vision benefits at no additional cost
- New York State Employees' Retirement System (ERS)Membership
- NYS Deferred Compensation
- Access to NY 529 and NY ABLE College Savings Programs, as well as U.S. Savings Bonds
- Public Service Loan Forgiveness (PSLF)
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Industry
Executive, Legislative, and Other General Government Support
Number of Employees
251-500 employees
