Information Technology Specialist 2-Data Warehouse

6 days ago


New York, United States New York State Civil Service Full time

NY HELP Yes Agency Insurance Fund, State Title Information Technology Specialist 2-Data Warehouse (NY HELPS) Occupational Category I.T. Engineering, Sciences Salary Grade 18 Bargaining Unit PS&T - Professional, Scientific, and Technical (PEF) Salary Range From $77329 to $86056 Annually Employment Type Full-Time Appointment Type Permanent Jurisdictional Class Competitive Class Travel Percentage 5% Workweek Mon-Fri Hours Per Week 37.5 Workday From 9 AM To 5 PM Flextime allowed? No Mandatory overtime? No Compressed workweek allowed? No Telecommuting allowed? Yes County New York Street Address 199 Church St City New York State NY Zip Code 10007 Duties Description As a member of NYSIF’s Data Warehouse Team, duties include but are not limited to:• Analyze and gather requirements for software systems.• Design, develop and modify relational and multidimensional database structures and data flows.• Design, develop and modify database procedures/packages to perform data extraction, transformation and loading into Data Warehouse.• Identify and implement improvements to SQL queries for increased performance.• Design, develop and modify data visualization dashboards.• Develop and maintain automated deployment scripts and jobs (CI/CD).• Develop and maintain documentation for existing and new systems.• Investigate and resolve service tickets by analyzing data and process to identify root cause of the issue.• Work Schedule includes production support after hours and weekends. Minimum Qualifications • Reachable on current Civil Service eligible list for this title; OR• One year of permanent, competitive class service as an Information TechnologySpecialist 1; OR• One year of permanent, competitive class service as an Information Technology Specialist 2 (Programming); OR• One year of permanent, competitive class service in a title eligible for transfer Section 52.6 of the Civil Service Law; OR• Bachelor's or higher-level degree including or supplemented by 15 semester credit hours in computer science; OR• Bachelor's or higher-level degree in any field AND one year of experience in information technology; OR• 60 semester credit hours including or supplemented by 15 semester credit hours in computer science AND one year of experience in information technology; OR• Two years of experience in information technology.Note: Certain math and business courses although taken as part of a computer science curriculum, are not counted towards the 15 semester credit hours.Preferred Qualifications:• Advanced knowledge and experience in relational databases, SQL.• Experience in database design and modeling.• Experience with ETL tools such as IBI Data Migrator, Informatica PowerCenter• Experience with Data visualization tools such as Spotfire, Tableau, Power BI.• Development experience in Python• Development experience in R is a plus. Additional Comments For new State employees appointed to graded positions, the annual salary is the hiring rate (beginning of the Salary Range) of the position. Promotion salaries are calculated by the NYS Office of the State Comptroller in accordance with NYS Civil Service Law, OSC Payroll rules and regulations and negotiated union contracts.Fringe Benefits: • Competitive Compensation.• Future Career Growth Potential. • Open and Supportive Team-Based Environment.• Plentiful Vacation, Personal, and Sick Leave Accruals. • Paid State and Federal Holidays.• Full Medical, Vision, and Dental. • Retirement Options. • Public Student Loan Forgiveness (PSLF).• Possibility of Telecommuting, Flextime, and Alternative Work Schedules.NY HELPS Program:This title is part of the New York Hiring for Emergency Limited Placement Statewide Program (NY HELPS). For the duration of the NY HELPS Program, this title may be filled via a non-competitive appointment, which means no examination is required but all candidates must meet the minimum qualifications of the title for which they apply. At a future date, it is expected employees hired under NY HELPS will have their non-competitive employment status converted to competitive status, without having to compete in an examination. Employees will then be afforded with all the same rights and privileges of competitive class employees of New York State. While serving permanently in a NY HELPS title, employees may take part in any promotion examination for which they are qualified.NYSIF Commitment to Diversity, Equity, and InclusionThe New York State Insurance Fund (NYSIF) prioritizes and champions diversity, equity, and inclusion (DEI) throughout our agency. NYSIF provides equal opportunities to all employees and applicants for employment without regard to race, religion, color, age, sex, national origin, sexual orientation, gender identity, disability, veteran status, or any other protected category under federal, state, and local law. We believe that embracing our differences brings richness, new ideas and experiences to NYSIF, which energizes a creative and innovative work environment. We strive to foster a workplace where diverse individuals are able to participate fully in the decision-making process and have ample opportunity for advancement. We are committed to investing the necessary resources and attention to improving the engagement, retention, and promotion of the extraordinary talent we have.Executive Order 31 commits New York State government to becoming a model employer for people with disabilities, increasing the participation of people with disabilities in state service and ensuring equal access to opportunities. NYSIF is proud to utilize best practices to recruit, hire, retain, and promote career advancement of individuals with disabilities. This includes special focus on current and prospective employees with the most significant disabilities, such as the use of supported employment, individual placement with support services, customized employment, the civil service sections 55/b and 55/c programs, internships, and job shadowing. If you are a person with a disability and wish to request that a reasonable accommodation be provided for you to participate in a job interview, please send an email to NYSIF’s Reasonable Accommodations mailbox at ra@nysif.com. Some positions may require additional credentials or a background check to verify your identity. Name Khalan Cassala Telephone Fax Email Address hr@nysif.com Address Street PO Box 66699 City Albany State NY Zip Code 12206 Notes on Applying Please send a resume and cover letter to HR@NYSIF.COM. Please be sure to include the Vacancy ID number in the subject of your email.



  • New York, New York, United States New York State Civil Service Full time

    **Job Overview**We are seeking a highly skilled Data Warehouse Specialist to join our team at the New York State Insurance Fund. As a key member of our Data Warehouse Team, you will be responsible for analyzing and gathering requirements for software systems, designing and developing relational and multidimensional database structures and data flows, and...


  • New York, New York, United States ShiftCode Analytics Full time

    Job Title: Data Technology SpecialistShiftCode Analytics is seeking a Data Technology Specialist for a 12+ month contract. This hybrid role requires a Bachelor's Degree in IT, Computer Science, Math, or a business-related discipline, and 3 years of relevant experience. Key skills include strong experience in data technology, business and IT applications,...


  • new york city, United States PRI Technology Full time

    Director, Data and AnalyticsNew York, NYFull TimeHybrid (3 days onsite)PRIMARY FUNCTION:This role is for someone who can implement Databricks and Tableau from scratchThe Director IT, Data and Analytics is responsible for leading implementation of the organization's data strategy, business intelligence (BI) and reporting capabilities leveraging our "4R”...


  • New York, New York, United States PRI Technology Full time

    We are seeking a highly experienced Snowflake Database Team Lead to lead our cloud data warehouse team at PRI Technology.This is a VP level opportunity with a very generous base salary of $250,000 per year and employee benefits package.The successful candidate will have experience in building scalable cloud data platforms using best practices and data...


  • New York, New York, United States Bluecore Full time

    About the RoleWe're looking for a Cloud Data Warehouse Specialist to lead the development of our cloud data warehouse, ensuring seamless integration with client-facing and internal-facing business use cases. If you have experience in architecting and developing cloud-based data warehouses, this could be the perfect opportunity for you.Main...


  • New York, United States MetroPlusHealth Full time

    Empower. Unite. Care. MetroPlusHealth is committed to empowering New Yorkers by uniting communities through care. We believe that Health care is a right, not a privilege. If you have compassion and a collaborative spirit, work with us. You can come to work being proud of what you do every day. About NYC Health + Hospitals MetroPlusHealth provides the highest...


  • New York, New York, United States Actus Consulting Group Full time

    Actus Consulting Group is seeking a highly skilled Data Warehouse Developer Specialist to lead our ETL project lifecycle. As an integral member of our team, you will be responsible for independently driving the entire project from requirements gathering to development and testing.We offer a competitive salary range of $100,000 - $140,000 per annum based on...


  • New York, New York, United States Data Intellect Full time

    Job OverviewWe are seeking a skilled kdb+ data analyst specialist to join our team at Data Intellect.This role involves working with business users to define requirements for new application functionality, developing and testing code for client applications, and supporting project delivery as part of a collaborative team.About the RoleDevelop and implement...

  • Data Analyst

    3 weeks ago


    New York, New York, United States TechnoGen Full time

    Job Summary:The Production Support Data Analyst plays a crucial role in ensuring the accuracy and completeness of the enterprise data warehouse. This hands-on position works closely with IT teams and business stakeholders to analyze and resolve data issues, creating source-to-target mapping documents and collaborating with ETL teams to ensure seamless data...


  • new york city, United States PRI Technology Full time

    Director IT, Data and AnalyticsNew York, NYFull TimeHybrid (3 days onsite)PRIMARY FUNCTION:The Director IT, Data and Analytics is responsible for leading implementation of the organization's data strategy, business intelligence (BI) and reporting capabilities leveraging our "4R” model: Right Information, to the Right People, at the Right Time, to make...


  • New York, New York, United States PRI Technology Full time

    OverviewPRI Technology is a leading technology firm providing innovative solutions to the financial services industry.Salary Range$140,000 - $200,000 per year.About the RoleWe are seeking an experienced Senior Cloud Data Engineer to join our team. The successful candidate will work closely with the Global Data Manager to design and build high-performing...


  • New York, United States Createch - Creative + Tech Staffing Full time

    Client: Tech Company Role: IT Infrastructure Specialist Location: NYC (fully onsite) Start: ASAP Duration: 2 weeks w/potential for extension and conversion Our client, a Tech Company, is seeking an Information Technology Infrastructure Specialist to start ASAP in their NYC studio. The ideal candidate will have 5+ years experience as an IT Technician,...


  • New York, United States Createch - Creative + Tech Staffing Full time

    Client: Tech Company Role: IT Infrastructure Specialist Location: NYC (fully onsite) Start: ASAP Duration: 2 weeks w/potential for extension and conversion Our client, a Tech Company, is seeking an Information Technology Infrastructure Specialist to start ASAP in their NYC studio. The ideal candidate will have 5+ years experience as an IT Technician,...


  • New York, United States Createch - Creative + Tech Staffing Full time

    Client: Tech CompanyRole: IT Infrastructure SpecialistLocation: NYC (fully onsite)Start: ASAPDuration: 2 weeks w/potential for extension and conversionOur client, a Tech Company, is seeking an Information Technology Infrastructure Specialist to start ASAP in their NYC studio.The ideal candidate will have 5+ years experience as an IT Technician, specifically...


  • New York, New York, United States BlackHawk Data Full time

    Job Overview: Enterprise IT Architecture SpecialistWe are seeking an experienced Enterprise IT Architecture Specialist to join our team at BlackHawk Data. This pivotal role involves designing and delivering advanced, comprehensive technology solutions for large enterprises.About the RoleTechnical Leadership & Design: We require someone to lead the design and...

  • Director IT, Data

    2 weeks ago


    New York, United States PRI Technology Full time

    Director IT, Data and AnalyticsNew York, NYFull TimeHybrid (3 days onsite)PRIMARY FUNCTION:The Director IT, Data and Analytics is responsible for leading implementation of the organization's data strategy, business intelligence (BI) and reporting capabilities leveraging our "4R” model: Right Information, to the Right People, at the Right Time, to make...


  • New York, New York, United States Rensselaer Polytechnic Institute Full time

    Rensselaer Polytechnic Institute is seeking a highly skilled and detail-oriented individual to fill the role of Information Technology Support Specialist. As a member of our team, you will be responsible for providing exceptional customer service at the Libraries' Service Desks, utilizing information systems for circulation, class reserves, and Interlibrary...

  • Senior Data Engineer

    2 months ago


    New York, United States PRI Technology Full time

    Job DescriptionJob DescriptionI have a full time opportunity for a Senior Data Engineer proficient in Snowflake development. This role is 3 days onsite, 2 days remote with one of our leading investment management firms in Midtown Manhattan.In this role you will work with the Global Data Manager to build high-performing cloud data platforms to meet our...


  • New York, New York, United States RemoteOnline Full time

    About the jobCompany OverviewWe are a leading online retailer seeking an experienced Data Control Specialist to join our warehouse operations team. At RemoteOnline, we pride ourselves on providing exceptional customer experiences through efficient and reliable logistics.Key ResponsibilitiesAs a Data Control Specialist, you will be responsible for scheduling...


  • New York, United States AMOREPACIFIC Full time

    Job Summary As the IT Manager at Amorepacific US Inc., you will play a pivotal role in overseeing the company’s technology infrastructure, with a particular focus on supporting and optimizing critical systems such as SAP, Extended Warehouse Management (EWM), Electronic Data Interchange (EDI), and Shopify. You will lead a dedicated team in ensuring the...