Job Information
Lake Erie College of Osteopathic Medicine Software & Database Developer II in Erie, Pennsylvania
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.