NY HELP No Agency Information Technology Services, Office of Title Manager Information Technology Services 1 - 9241 Occupational Category I.T. Engineering, Sciences Salary Grade 27 Bargaining Unit PS&T - Professional, Scientific, and Technical (PEF) Salary Range From $106898 to $131665 Annually Employment Type Full-Time Appointment Type Contingent Permanent Jurisdictional Class Competitive Class Travel Percentage 0% Workweek Mon-Fri Hours Per Week 37.5 Workday From 8 AM To 5 PM Flextime allowed? No Mandatory overtime? No Compressed workweek allowed? Yes Telecommuting allowed? Yes County Albany Street Address State Campus, Bldg 5, Flr 2 City Albany State NY Zip Code 12226 Duties Description ITS provides operational support to state agencies on a 24x7x365 basis; some positions may be required to provide this critical service at any time.Under the direction of Manager of Information Technology Specialist 2, SG-29, within the Dedicated Support Division / Worker's Compensation Board (WCB), the Manager of Information Technology Specialist 1, SG-27, will be responsible for data migration, data warehouse, data integration, and business intelligence (BI) analytics efforts supporting WCB data warehouse and BI activities. Further, the incumbent will communicate with internal staff on various projects including data warehouse, business intelligence, and data sharing initiatives. The incumbent will be responsible for supervising, mentoring, and supporting DMS staff as well as performing hands-on business analysis, project management, design, extract, transform, and load (ETL) development, technical maintenance, data integration, report writing and data evaluation. Specific duties will include but are not limited to the following:- Utilize Pentaho suite of tools for extract, transform, load (ETL), business analytics, and reporting.- Demonstrate proficiency with data warehouse and business intelligence (BI) analytics concepts (including Pentaho).- Demonstrate knowledge of dimensional (star schema) data modeling, as well as Structured Query Language (SQL).- Utilize tools related to the movement of data such as Pentaho Data Integrator or SSIS (or similar tool).- Demonstrate knowledge of tools related to BI analytics schema and cube development such as Pentaho or Tableau (or similar tool).- Exhibit proficiency with relational database management concepts in various database platforms.- Communicate clearly both verbally and in written correspondence. - Design, develop and implement data integration solutions. - Design, develop and deploy business intelligence tools and solutions.- Provide hands on development of ad hoc inquiries and reporting.- Participate in data warehouse architecture meetings.- Facilitate and develop data sharing programs with outside partners.- Plan, schedule and manage WCB DMS project work.- Assist, backup, and support with the administration of the unit staff.- Mentor new developers in all phases of development life cycle.- Participate in meetings and discussions with both IT and agency staff to determine data requirements.- Produce performance programs to monitor the performance of direct reports.- Perform the full range of supervisory duties as applicable. Minimum Qualifications Open to NYS employees with one year of permanent competitive service as a Manager Information Technology Services 1, SG27/M2, OR in a position at the SG25 or M1 level or higher deemed administrative under Section 52.6 of Civil Service Law. The transfer cannot be a second consecutive transfer resulting in advancement of more than two salary grades or one M-grade.Note: If you are on the examination eligible list for the position title in this location, you do not need to respond to this posting unless you are also eligible for appointment by one of the qualifications listed above. Candidates must be reachable on the current eligible list for this title in order to be list appointed.Preferred Qualifications:Pentaho experience 1 to 2 years.Extract, Transform, and Load experience 5+ years.Business Intelligence reporting tools (such as SAP BO, Oracle OBIEE, Cognos, Hyperion, Tableau, Power BI, Tibco Spotfire, etc.) experience 5+ years.Data Modeling: Dimensional Modeling experience 5+ years.MS SQL Server experience 5+ years. Additional Comments 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.Benefits of Working for NYS Generous benefits package, worth 65% 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 developmentHealth Care Benefits• Eligible employees and dependents can pick from a variety of affordable health insurance programs• Family dental and vision benefits at no additional costAdditional 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. Some positions may require additional credentials or a background check to verify your identity. Name ITS Human Resources Telephone 518-473-0398 Fax 518-402-4924 Email Address PostingResponses@its.ny.gov Address Street Empire State Plaza Swan Street Building, Core 4, Floor 1 City Albany State NY Zip Code 12220 Notes on Applying To apply for this position, please submit a cover letter and resume clearly indicating how you qualify. Ensure that you include the vacancy ID in the subject of your email for prompt routing. Your Social Security number may be required to confirm eligibility.