Apply on Employer Site

NYS Office of Information Technology Services · 2 hours ago

Project Assistant - 10019

Albany, NY

Full-time

Onsite

Mid, Senior Level

$87K/yr - $110K/yr

5+ years exp

NYS Office of Information Technology Services is responsible for providing operational support to state agencies. The Project Assistant will specialize in business intelligence, data warehousing, and operational reporting, supervising staff and performing hands-on analysis and development.

Cyber SecurityGovernmentInformation TechnologyIT Infrastructure

No H1B

U.S. Citizen Only

Responsibilities

Support the OnBoard Expansion – CIS/eCase Modernization and OnBoard Access Administration projects

Demonstrate proficiency with data warehouse, BI analytics, and reporting concepts

Demonstrate hands-on experience with the ETL (Extract, Transform, Load) tools related to the movement of data such as Pentaho Data Integrator or SQL Server Integration Services (SSIS)

The candidate must have knowledge of BI analytics schema and cube development using Pentaho, as well as dimensional (star schema) data modeling

Show proficiency with relational database management concepts in various database platforms such as Sybase ASE or SQL Server

Mentor new developers in all phases of the system development life cycle

Develop data integration solutions using SQL, ETL, and SQL stored procedures

Perform and participate in code review for peers and SG-18 technologists as needed

Produce business intelligence reports (parameterized, one-shot/ad hoc & periodic), summarized data extracts, and analytical report schemas

Migrate legacy reports and code to the business intelligence platform

Respond to incidents and requests from internal and external users

Perform the full range of supervisory duties as applicable

Qualification

Data integration solutionsETL toolsBusiness intelligenceRelational database managementSQLPentaho Data IntegratorSQL Server Integration ServicesBI analytics schemaCode reviewMentoring

Required

Five + years of experience developing data integration solutions using SQL, ETL, and SQL stored procedures

Associate's degree and four years of experience

Associate's degree including 15 semester credit hours in computer science and three years of experience

Bachelor's degree and three years of experience

Bachelor's degree including 15 semester credit hours in computer science and two years of experience

Master's degree in computer science or related field substitutes for an additional year of experience

Doctorate in computer science or related field substitutes for an additional year of experience