Software and Database Developer Intern

Company: The Lake Erie College of Osteopathic Medicine
Location: Erie
Posted on: January 26, 2023

Job Description:

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 and desktop 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;Evaluates 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;Create and maintain user accounts within Jenzabar software and custom applications;Update, maintain, and revise LECOM portal pages, portlets, and desktop applications;Maintain integrity and security on LECOM portal applications;Develops and deploys new portal and desktop applications;Write requirements and design documents for all new 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; andOther duties as required / needed to maintain an efficient and effective Department.EEO/AA/M/F/Vets/DisabledMinimum 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 SQL databases 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;Strong communications skills are essential, as well as computer literacy for the MS Office Suite (Word, PowerPoint, Excel...etc.), and 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; andBe able to be flexible to accept other duties needed/assigned for the Institution's needs.MINIMUM QUALIFICATIONS: Education and experience equivalent to: College student with strong communication skills majoring in an accredited Information Technology or Computer Science program.

Keywords: The Lake Erie College of Osteopathic Medicine, Erie , Software and Database Developer Intern, Other , Erie, Pennsylvania