Jump to main content.

The Official Careers Website of the City of New York

Search

Junior SQL Developer Apprentice

  1. TEACHERS RETIREMENT SYSTEM
Posted on: 11/29/2023
  1. Full-time

Location

MANHATTAN

  1. Exam may be required

Department

IT Devops

$54,281.00 – $60,000.00

Job Description

This vacancy has now expired.

The Teachers’ Retirement System of the City of New York (TRS) is a public pension fund that provides New York City educators with retirement, disability, and death benefits. TRS was established on August 1, 1917 and is one of the largest pension plan sponsors in the United States, with more than $106 billion in assets and over 215,000 active and inactive members, retirees and beneficiaries.

We are seeking a bright and motivated Junior SQL Developer to join our team. Develop and test data correction scripts, as well as enhance SQL Server SSIS data processing packages and SSRS reports in support of agency strategies and system enhancement initiatives pertaining to Pension processing.

Roles and Responsibilities:
- Develop and test data correction scripts
- Enhance SQL Server SSIS data processing packages
- Develop SSRS reports
- Analyze database models
- Identify data integrity issues
- Develop T-SQL queries
- Apply optimized indexes
- Develop knowledge of Data Modeling
- Develop knowledge of ETL protocols
- Conduct unit testing
- Develop reports using MS SQL Server Reporting Services
- Ensure the accuracy and integrity of data and applications

***This position is only for Multiverse Apprentice Candidates***

We offer a comprehensive benefits package.
- Flexible work hours, work/life balance
- Paid holidays, sick and annual leave
- Health benefits, dental and vision coverage, prescription drug plans
- Flexible Spending Programs (FSA)
- Commuter benefits plan
- Retirement savings plan (The New York Employees' Retirement System)
- U.S. Savings Bonds
- Employee Assistance Programs (EAP)


Minimum Qualifications

1. A baccalaureate degree, from an accredited college including or supplemented by twenty-four (24) semester credits in cyber security, network security, computer science, computer programming, computer engineering, information technology, information science, information systems management, network administration, or a pertinent scientific, technical or related area; or

2. A four-year high school diploma or its equivalent approved by a State’s department of education or a recognized accrediting organization and three years of satisfactory experience in any of the areas described in “1” above; or

3. Education and/or experience equivalent to “1” or “2”, above. College education may be substituted for up to two years of the required experience in “2” above on the basis that sixty (60) semester credits from an accredited college is equated to one year of experience. In addition, twenty-four (24) credits from an accredited college or graduate school in cyber security, network security, computer science, computer programming, computer engineering, information technology, information science, information systems management, network administration, or a pertinent scientific, technical or related area; or a certificate of at least 625 hours in computer programming from an accredited technical school (post high school), may be substituted for one year of experience.


Preferred Skills

- Multiverse Candidate - Prior interest in MS SQL Server, SSIS and SSRS tools - Able to work independently and take initiative, as well as work collaboratively and contribute to an agile team environment. - Drive and eagerness to learn willingness to build technical pro ciency in the following: o MS SQL Server o SSIS and SSRS Tools o Data Modeling o ETL protocols o Application Code Debugging - Teamwork - Problem Solving - Communication - Attention to detail, curiosity, and willingness to learn
55a Program

This position is also open to qualified persons with a disability who are eligible for the 55-a Program. Please indicate at the top of your resume and cover letter that you would like to be considered for the position through the 55-a Program.
Public Service Loan Forgiveness

As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education’s website at https://studentaid.gov/pslf/.
Residency Requirement

New York City residency is generally required within 90 days of appointment. However, City Employees in certain titles who have worked for the City for 2 continuous years may also be eligible to reside in Nassau, Suffolk, Putnam, Westchester, Rockland, or Orange County. To determine if the residency requirement applies to you, please discuss with the agency representative at the time of interview.
Additional Information

The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.

Job ID

617502

Title code

13633

Civil service title

CYBER SECURITY ANALYST

Title classification

Competitive-1

Business title

Junior SQL Developer Apprentice

Posted until

2023-11-30

  1. Entry-Level

Job level

01

Number of positions

1

Work location

55 Water St Ny Ny

  1. Technology, Data & Innovation

Junior SQL Developer Apprentice

Search