Programmer (IT Sr Associate, Level 2) - Provisional

Programmer (IT Sr Associate, Level 2) - Provisional

Job ID

27128

Location

Hostos Community College

Full/Part Time

Regular/Temporary

Regular

Add to My Favorite Jobs

GENERAL DUTIES

I.T. Senior Associates perform highly complex professional work in technology-related disciplines.

While areas of specialization vary, typically I.T. Senior Associates perform a range of work in development/programming, communications, technical support, or similar functions depending on the needs of the Information Technology area to which they report. Work tasks include diagnosing, evaluating, overseeing and resolving highly complex projects. They have wide latitude for independent initiative and judgment and may serve in lead roles on complex programs or projects, and/or serve as a direct supervisor of a unit or group.

I.T. Senior Associates should demonstrate mastery of one or more technology-related disciplines, decision-making ability in situations related to those disciplines, and be able to serve as a resource in these areas. They may contribute to decisions on I.T. policies and technical standards.

This job is in CUNY's Classified Civil Service. The full specification is available on our web site at http://www.cuny.edu/about/administration/offices/hr/classified-civil-service/ccsjobs/

CONTRACT TITLE

IT Senior Associate

FLSA

Exempt

CAMPUS SPECIFIC INFORMATION

The Programmer is a critical member of the IT staff and reports directly to the Director of Enterprise Applications. The selected candidate will be expected to work collaboratively with a cross-campus functional team. Responsibilities include, but are not limited to the following:

• Uses warehouse data to solve organizational problems through reports, scripts, and API integration.+ Assists in coding and content update efforts for the campus website. Understanding legacy application code with minimal assistance and resolving bugs/defects/performance issues therein are essential responsibilities.+ Provides enterprise wide SQL Database expertise with emphasis on data design, access, usage, security and quality of information assets.+ Develops and troubleshoots applications and integration using the Microsoft SQL server platform and providing technical/production support.+ Works with product owners and other development team members to determine new features needed in new/revised applications.+ Creates and updates documentation in support of development efforts.
  
  Documents may include detailed specifications, implementation guides, architecture diagrams or design documents.+ Performs technical troubleshooting, code debugging, and problem solving for college website and custom-built data reporting solutions.+ Identifies, communicates, and resolves data quality and data reconciliation issues.+ Communicates regularly with technical, applications and operational staff to ensure database integrity, security and optimized performance at the application and database level.+ Participates in and supports all custom application planning and problem resolution.+ Works collaboratively with end users to support reporting systems that provide accessible information for decision-making.+ Performs independent audits and reviews and validates databases to ensure data integrity.+ Maintains an accurate and comprehensive inventory of data, data systems, and data storage.+ Processes data extracts using data retrieval and management tools.+ Ensures optimum service to all internal and external partners in response to all requests for service and information.+ Develops stored procedures, functions, packages, triggers, and views using SQL. Creates scripts to build new databases.+ Assists with other duties as assigned.+ Essential duties require on-campus presence.

MINIMUM QUALIFICATIONS

1.High School Diploma, G.E.D., or equivalent

2.An equivalent of ten years of experience post-high school that can be met by one of the following: ten years of full-time work experience in a computer or technology related position; an Associate's degree plus eight years of full-time work experience in a computer or technology-related position; or a Bachelor's degree from an accredited institution plus six years of full-time work experience in a computer or technology-related position

3.Demonstrated English Language proficiency

4.A Motor Vehicle Driver's license, valid in New York State, may be required for some, but not all positions.

This title has three levels. In addition to the minimum qualifications above, To qualify for Levels 2 and 3, additional qualifications, such as education, experience, or certification relevant to the area of specialization are required.

OTHER QUALIFICATIONS

The following qualifications are preferred:

• 6+ years hands-on experience with database development using SQL.+ Writes efficient SQL queries to support data gathering requirements.+ Strong scripting abilities and understanding of complex stored procedures, views, data aggregation/manipulation. through table joins/queries, database design, normalization and de-normalization techniques.+ Experience working directly with senior leadership.+ Possesses strong analytical and troubleshooting skills.+ Demonstrated attention to detail focusing on ensuring the accuracy and efficiency of the data warehouse and the individual work units.+ Ability to prioritize competing demands and effectively manage multiple tasks and/or projects.+ Possesses strong oral and written communication skills, clearly and accurately communicating complex and/or technical information to both technical and non-technical audiences.+ Self-motivated--able to work within a project-based environment.+ Works effectively in a team environment, conceptualizing and developing new programs and web applications.+ Expertise with programs within multiple inter-related systems, using techniques and languages, such as C#, C++, .NET 6, WebAPI, JSON, Java, JavaScript.+ Strong knowledge of Visual Studio, .NET 6, Web API, JSON, SQL.+ Experience with participating in the entire application lifecycle, focusing on coding, debugging, and troubleshooting App performance issues.+ Experience with performing tests to optimize performance and building reusable code and libraries for future use.+ Demonstrated experience in data extraction and manipulation.+ Demonstrated skills in maintaining documentation related to assigned web applications, programs and other systems.+ Experience exchanging data with a variety of platforms and systems.+ Possesses an in-depth understanding of the entire web development process (design, development, and deployment).+ Familiarity with front-end languages JavaScript, CSS, HTML, Vue/React or equivalent framework a plus.+ Agile development experience a plus.+ Working knowledge of R and/or Python a plus.+ Android and/or IOS app development a plus.

COMPENSATION

$99,599

BENEFITS

CUNY offers a comprehensive benefits package to employees and eligible dependents based on job title and classification. Employees are also offered pension and Tax-Deferred Savings Plans.

Part-time employees must meet a weekly or semester work hour criteria to be eligible for health benefits. Health benefits are also extended to retirees who meet the eligibility criteria.

HOW TO APPLY

Applicants must apply online by accessing the CUNY website at www.cuny.edu and navigating to the following links: "Employment" and "Search Job Postings".

Please attach cover letter, resume and three professional references.

IMPORTANT NOTE: Applicants must meet the minimum qualification requirements.

In addition individuals who are in a permanent IT Sr. Associate title, permanent IT Associate title, permanent IT Assistant title, permanent IT Support Assistant title or have applied for the IT Support Assistant, Exam #2064 or the IT Assistant, Exams #2070/2071 are encouraged to apply and will be considered.

CLOSING DATE

Open until filled with review of applications to begin on August 15, 2023

JOB SEARCH CATEGORY

CUNY Job Posting: Information Technology/Technical

EQUAL EMPLOYMENT OPPORTUNITY

CUNY encourages people with disabilities, minorities, veterans and women to apply. At CUNY, Italian Americans are also included among our protected groups.

Applicants and employees will not be discriminated against on the basis of any legally protected category, including sexual orientation or gender identity. EEO/AA/Vet/Disability Employer.