Data Analyst 2

Description

Duties Description

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.
  
  

Qualifications

Minimum Qualifications

Non-competitive: seven years of experience* in data visualization, and statistical models and data mining

• 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.
• 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.
  
  

Please Note

Additional Comments

• 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 to50 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.

Benefits of Working for NYS Generous benefits package, worth65% of salary, including:

Holiday & Paid Time Off

• 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
  
  

Health Care Benefits

• Eligible employees and dependents can pick from a variety of affordable health insurance programs
• Family dental and vision benefits at no additional cost
  
  

Additional Benefits

• 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)
• And many more.
  
  

The Office of Information Technology Services is an equal opportunity employer, and we recognize that diversity in our workforce is critical to fulfilling our mission. We encourage all individuals with disabilities to apply.