Junior SQL Developer Apprentice
- TEACHERS RETIREMENT SYSTEM
- Full-time
Location
MANHATTAN
- Exam may be required
Department
IT Devops
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)
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.
- 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
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.
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/.
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.
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
- Entry-Level
Job level
01
Number of positions
1
Work location
55 Water St Ny Ny
- Technology, Data & Innovation