Address
Form of workCompany Description
Job Description
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)
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.
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 Description
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)
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.
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.
