Information Technology Specialist

Job TitleContaminated Site Remediation & Redevelopment Enforcement and Financial Operations Information SystemsProgram/Location: Department of Environmental ProtectionScope of Eligibility: Open to applicants who meet the requirements below.Description: Under direct supervision in a state department, agency, data center, institution, or state college, assists in at least one of the following areas: the design and preparation of least complex operation routines and computer programs for electronic data processing equipment utilizing required and current software, operating systems, and multiprogramming technology; the control and/or implementation/maintenance of highly technical operating systems associated with new generations of computers to function toward optimum utilization of available hardware/software using comprehensive knowledge of the operating system function; the development, implementation, and maintenance of multi-network, multi-user Local Area Networks (LAN), Metropolitan Area Networks (MAN), and/or Wide Area Networks (WAN), maintenance of centralized, decentralized and remote network services, network security, data integrity, network performance monitoring, network problems resolution, and user support; does other related duties as required.Specific to the Position: Create, design and maintain Analytic Reports in SAP Business Intelligence using both pre-defined data universes and free hand SQL. Reports are presented across multiple platforms, to both internal (DEP) and external (Non-DEP) users. Create, test and maintain PL/SQL functions and reference data in an Oracle based environment to support online services and create complex merge documents such as permits, reports, letters, etc. that auto-generate through the Department's internal databases. Create and test applications to assist in the review and processing of environmental data and reports. Create, design and maintain online services including but not limited to the alteration of directional text, page and migration supporting code i.e. PL/SQL, HTML, JavaScript.Preferred Skill Set:SQL/PLSQLPythonMicrosoft Azure AIExcel VBASAP Business Intelligence (Web Intelligence 4.3)SQL Developer, DBeaver or MongoDBOracle database environmentRequirements:EDUCATION: Graduation from an accredited college or university with an Associate's degree in Computer Science or Computer/Information Technology.EXPERIENCE: One (1) year of experience in at least one of the following areas: the design and preparation of programs for electronic data processing utilizing current operating systems, modification of systems software and multiprogramming technology; or the development, maintenance, or installation of application programs; or in performing technical support functions within a direct access device environment, or the development, implementation, and maintenance of multi-network, multi-user Local Area Networks (LAN), Metropolitan Area Networks (MAN), and/or Wide Area Networks (WAN) environment. Note: Technical support functions include experience in resolution of online production and/or communications network problems, and/or code modification, testing, and debugging of program modules in an online environment, and/or space allocation and control of direct access storage devices (DASD management). Note: A Bachelor's or Master's degree in Computer Science may be substituted for one (1) year of indicated experience. NOTE: A general Bachelor's degree from an accredited college or university may be substituted for the Associate's degree. SPECIAL NOTE ON SUBSTITUTING EXPERIENCE FOR EDUCATION Experience in the study of work methods/processes, analysis of varied types of data, design and preparation of systems/programs, operation of multiprogramming computer systems and work in the data processing support areas of input/output control or reliability support may be substituted for the required education on a year-for-year basis with thirty (30) semester hour credits being equal to one (1) year of experience. NOTE: Evidence of formal training in Computer Science/Information Technology received at an accredited institution may be submitted with your application for evaluation by the Department of Personnel for possible credit. These training courses will be examined to see how they compare, both in hours/content, to college courses to which they equate, sixteen (16) training hours being equal to one (1) college credit. In-house training courses will not be accepted as meeting this criterion; thus, they will not be evaluated.License: Appointees will be required to possess a driver's license valid in New Jersey only if the operation of a vehicle, rather than employee mobility, is necessary to perform the essential duties of the position.Benefits: As a New Jersey State Department, NJDEP offers a comprehensive benefits package that includes:Paid Benefit LeaveHoliday PayAlternative Workweek Program*Telework*PensionDeferred CompensationHealth Benefits (medical, prescription drug, dental & vision care) and Life InsuranceFlexible and Health Spending Accounts (FSA/HSA)Commuter Tax Savings ProgramPublic Service Loan Forgiveness (PSLF)Tuition Reimbursement**Pursuant to the State/Department's policy, procedures, and/or guidelines.SAME Applicants: If you are applying under the NJ SAME program, your supporting documents (Schedule A or B letter) must be submitted along with your resume by the closing date indicated above. For more information on the SAME program, please email View email address on click.appcast.io, or call CSC at View phone number on click.appcast.io and select Option #3.Veteran's Preference: To qualify for New Jersey Veteran's Preference/status, you must establish Veteran's Preference through the Department of Military and Veteran's Affairs. Please submit proof of your Veteran's Preference along with your resume as indicated. For more information, please visit All persons newly hired on or after September 1, 2011, have one year from the date of employment to establish, and then maintain principal residence in the State of New Jersey subject to the provisions of N.J.S.A. 52:14-7 (L.2011, Chapter 70), also known as the "New Jersey First Act".Authorization to Work: Selected candidates must be authorized to work in the United States per the Department of Homeland Security, United States Citizenship, and Immigration Services regulations. NOTE: The State of New Jersey does not provide sponsorship for citizenship to the United States.Equal Opportunity Employment: The State of New Jersey seeks to increase the richness and diversity of its workforce, and in doing so, become the employer of choice for all people seeking to work in State Government. To evaluate the effectiveness of our efforts to attract and employ a diverse workforce, applicants are asked to voluntarily answer a few brief questions on the NJ Affirmative Action Information Form. All information is considered confidential and will be filed separately with the agency's affirmative action officer. This information will not be part of your application for employment and will not be considered in any hiring decision.DEP Notices of Vacancy have a 4:00 p.m. deadline on the closing date. When filing for these opportunities, please be sure to have your letter of interest and credentials sent electronically before 4 p.m. on the closing date.The New Jersey Department of Environmental Protection is an Equal Opportunity Employer and is committed to inclusive hiring and a diverse workforce. We strongly encourage people from all backgrounds to apply. Accommodations under ADA will be provided upon request.