NY HELPNo

AgencyInformation Technology Services, Office of

TitleInformation Technology Specialist 3 Database (Db)

Occupational CategoryI.T. Engineering, Sciences

Salary Grade23

Bargaining UnitPS&T - Professional, Scientific, and Technical (PEF)

Salary RangeFrom $90582 to $114585 Annually

Employment Type Full-Time

Appointment Type Permanent

Jurisdictional Class Competitive Class

Travel Percentage 0%

Workweek Mon-Fri

Hours Per Week 37.5

Workday

From 8 AM

To 4 PM

Flextime allowed? No

Mandatory overtime? No

Compressed workweek allowed? No

Telecommuting allowed? Yes

County Albany

Street Address Empire State Plaza

Swan Street Building, Core 3, Floor 1

City Albany

StateNY

Zip Code12229

Duties Description Under the direction of the Information Technology Specialist 4, SG-25, within the Digital Transformation Office, Service Management – MeasureIT team, the Information Technology Specialist 3 Database (ITS3 Db), SG-23, will support and maintain over 300 ETL and Data warehouse processes daily, programmed in Python and Microsoft SQL SQL Server (T-SQL) and utilizing Server Integration Services (SSIS) which supports the MeasureIT Business Intelligence application. In addition, the ITS3 Db is responsible for managing SSIS version control history utilizing Gitlab through push and merging control processes.

Specific duties shall include, but are not limited to:

-Perform technical activities associated with the database end related to writing T-SQL query writing, report development, dashboard development and technical documentation, and ETL and Dimension development using SSIS.
-System design directly related to development of MS SQL 2019/2025 OLTP and multi-dimensional database system: Server Integration Services packages (SSIS),SQL Server Reporting Services packages (SSRS), SQL Server Analysis Services Projects (SSAS)
-Oversee the design and development of PowerBI Dashboard reporting, and SSRS reporting utilizing reporting Services.
-Manage ITS2, SG-18, staff, and provide direction, training and mentoring

Preferred Experience:

•2+ years of experience in Transact-SQL with MS SQL Server writing complex queries in a transactional database schema. Familiar with cte, subqueries, all join types, Row partitioning, and row indexing.
•2+ years of experience in MS SQL Server Integration Services developing ETL processes with out of the box SSIS tasks including C# script task and configuring expression-based Database connections.
•1+ Years of experience developing Python scripts including the following modules: requests, pyodbc, pandas, ldap3, and sqlite3. Familiar with for loops and panda data frames.
•2+ years of experience developing, configuring, and deploying SQL Server Analysis Services (SSAS) models and multi-dimensional cube development, including dimensions, facts, and measures within a star schema model.
•1+ years of experience developing git lab repositories and clear understanding of branch repositories and experience with standard git commands like init, clone, commit, pull, push, merge, rebase.
•2+ years of experience with developing reports in PowerBI Desktop and deployment to a PowerBI Report Server environment. Familiar with concepts in PowerBI: All visualizations, dynamic and static RLS, configuring bookmarks, dynamic tables, and dynamic SQL. Familiar with creating database connections including SQL Server and Oracle Server. Understands key concepts in DAX language model for developing measures and complex calculations.

Minimum Qualifications Eligible for a transfer under Section 52.6 of the Civil Service Law by having one year of permanent competitive service in an appropriate title. Information regarding transfer eligibility is available on the Civil Service Career Mobility Office website at https://careermobilityoffice.cs.ny.gov/cmo/gotit/ OR reachable on the appropriate eligible list in Albany.

Note: If you are on the examination eligible list for the position title and shift in this location, you do not need to respond to this posting. Candidates must be reachable on the current eligible list for this title in order to be list appointed.

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.

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.

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 development
• Up to 50% telecommuting if all criteria are met according to ITS Policy.

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.

Some positions may require additional credentials or a background check to verify your identity.

Some positions may require additional credentials or a background check to verify your identity.

Name ITS Human Resources

Telephone 518-473-0398

Fax

Email Address PostingResponses@its.ny.gov

Address

Street 164 Columbia Turnpike

City Rensselaer

State NY

Zip Code 12144

Notes on ApplyingTo 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.