Easter Seals Jobs

Software & Database Developer II

Overview

Date Posted:

7/24/2024

Location:

Erie

Address:

1858 West Grandview Boulevard

City:

Erie

State:

PA

Country:

United States of America

Category:

Information Technology

Employment Status:

Full-time

Description

JOB SUMMARY: Monitors and verifies the flow of information from various external sources, to the final data repository. Fields data-related questions and issues. Collates, investigates and answers or resolves questions. Coordinates Ad Hoc and standard reports using the Jenzabar SQL database. Designs, develops and maintains LECOM internal portal pages. Implements and maintains LECOM web-based applications used by the faculty, staff and students.

CHARACTERISTIC JOB TASKS AND RESPONSIBILITIES :

• Promotes and preserves the mission of LECOM;

• Maintain confidentiality, professional appearance and pleasant demeanor;

• Reviews data input, updates and usage for existing and new database tables;

• Maintain a log of issues encountered and their resolution;

• Develops and maintains relevant reporting and reconciliation processes used to monitor key data processes;

• Evaluate and develops edit checks and ensures consistent data in the system(s);

• Utilizes SQL queries, custom applications, reporting tools, constraints, and other applications, as necessary, to continuously ensure data integrity;

• Update, maintain and revise LECOM portal pages;

• Maintain integrity and security on LECOM portal applications;

• Develops and deploys new portal applications;

• Creating new programs or scripts capable of reading and validating data from a variety of sources and formats for importing to a database

• Creating new applications that act as self-serving interactive interfaces for applicants, students, faculty, staff, and other parties for a multitude of tasks involving data handling, validation, and reporting

• Maintain applications, including the conversion of applications built on older technologies to new ones and troubleshooting of problems via analytical and problem solving skills

• Training interns or other department members on internal practices and standards, principles of programming, and new applications or technologies

• Write requirements and design documents for all new portal applications;

• Contribute and be responsible for overall student success;

• Contribute directly to the Mission of LECOM embodying the essence of Osteopathic Principles and Practices by assisting with Institutional fundraising and participating in the LECOM Scholarship Auction;

• Participate in scholarly activity so to enrich and broaden the student learning experience;

• Commit to being a representative of LECOM by being actively involved in the community, including, but not limited to, serving on Boards, participating in community fundraisers and overall outreach; and

• Other duties as required / needed to maintain an efficient and effective Department.

  EEO/AA/M/F/Vets/Disabled

Minimum Requirements

KNOWLEDGE, SKILLS, ABILITIES AND PERSONAL CHARACTERISTICS : Must possess required knowledge and be able to explain and demonstrate, with or without reasonable accommodations, that the essential functions of the job can be performed:

• Must have excellent writing, organizational, interpersonal, and communication skills;

• Good analytical and problemsolving skills;

• Ability to communicate effectively;

• Ability to follow oral and written instructions;

• Familiar with design, development and maintenance of the SQL database supporting the LECOM Jenzabar Student Information System (SIS);

• Must have the ability to maintain existing applications written in at least two of the following languages: PHP, ASP (C#), HTML/CSS, Javascript and SQL;

• Must have the ability to develop new web-based applications that maintain the SIS data or report on the SIS data, as needed;

• Ability to gather business requirements from faculty, staff, and other parties for the conversion of manual processes to automated processes

• Ability to troubleshoot through the usage of self-created test cases, along with train and troubleshoot custom applications for faculty and staff

• Good understanding of computer science fundamentals including algorithms and data structures, object-oriented principles, and relational databases

• Knowledge of the ASP.NET client-server architecture

• Must have the ability to program within the .NET Framework, including an understanding of C#, SQL, and one of the following languages: JavaScript, Visual Basic, Visual Basic for Applications

• Must have the ability to work across multiple IDEs, including but not limited to: Microsoft Access, SQL Server Management Studio, Visual Studio 2013

• Strong attention to detail

• Willingness to learn and adapt to changes in technologies, including new application programming interfaces, languages, and other such systems

• Strong communications skills are essential, as well as, computer literacy for the MS Office Suite (Word, PowerPoint, Excel…etc.), as well as, accurate data entry skills;

• Excellent organizational skills;

• Maintaining an established work schedule;

• Effectively using interpersonal and communications skills including tact and diplomacy;

• Effectively using organizational and planning skills, including, but not limited to, attention to detail and follow-through;

• Assessing and prioritizing multiple tasks, projects, and demands;

• Maintaining confidentiality of work related information and materials;

• Establishing and maintaining effective working relationships;

• The ability to accept work requests from other managers and supervisors in a respectful and cooperative manner and to independently answer such requests;

• The ability to work cooperatively and collegially with others, consistent with a workplace of dignity and respect and EEO rules and regulations;

• The ability to devote full attention and energy to the important work of LECOM in a timely fashion; and

• Be able to be flexible to accept other duties needed/assigned for the Institution’s needs.

  MINIMUM QUALIFICATIONS : Education and experience equivalent to a Minimum Associates Degree in Computer Science, Information Systems and/or another related field with two to four (2-4) years’ of workplace experience. Experience interacting with development teams is a plus.