Database Analyst Jobs in Pennsylvania (NOW HIRING)

Description
Company Overview & Culture:
Worldgate is a certified Woman-Owned Small Business headquartered in Northern Virginia that provides IT Consulting Services to our SLED clients. We specialize in delivering high-quality enterprise technology and Enterprise Resource Planning (ERP) system optimization services across Human Capital, Payroll, and Financial Management systems. Our mission is to provide exceptional service that enables our clients to be their best for their stakeholders, create an empowering workplace for our employees, and give back to our communities in meaningful ways. Worldgate has been named to the Inc. 5000 list of fastest-growing private companies three times. In recognition of our commitment to fostering a positive work environment, Worldgate was honored with the Inc. Best Workplaces award in 2024 and The Washington Post Top Workplaces in 2022.
Job Summary:
The Database Analyst is responsible for the administration, maintenance, optimization, and support of the organization's Student Information Systems (SIS), Enterprise Resource Planning (ERP) systems, associated databases, and related enterprise applications. This role ensures the integrity, availability, security, and performance of institutional data while supporting reporting, integrations, business processes, and system enhancements.
The Database Analyst partners with technical and functional stakeholders to analyze business requirements, develop reporting solutions, improve data quality, support system upgrades, and optimize the organization's student information systems through effective database administration and continuous process improvement.
Essential Responsibilities:
• Administer and maintain the organization's Student Information Systems (SIS), Enterprise Resource Planning (ERP) systems, associated databases, and related enterprise applications.
• Monitor database performance, data quality, security, and system availability to ensure reliable operations.
• Support system configuration, user access, security roles, workflows, and business processes.
• Develop, optimize, and maintain SQL queries, stored procedures, reports, dashboards, and data extracts.
• Design, monitor, and troubleshoot data integrations between the SIS and other enterprise applications.
• Coordinate software upgrades, patches, testing, and new functionality implementations.
• Partner with business stakeholders to gather reporting requirements and develop data solutions that support operational and strategic decision-making.
• Perform database analysis, capacity planning, indexing, and performance tuning to improve system efficiency.
• Maintain database documentation, data dictionaries, system configurations, and standard operating procedures.
• Identify and resolve database, reporting, and application issues while ensuring data integrity and security.
• Coordinate with software vendors and IT teams to resolve technical issues and implement enhancements.
• Develop training materials and provide technical guidance to end users on reporting and system functionality.
• Participate in data governance initiatives, business process improvements, and enterprise technology projects.
Corporate Standards:
• Comprehend and align to established goals and objectives within the framework of the Worldgate Continuous Feedback Approach.
• Stay up to date on computer skills and best practices, such as word processing software, spreadsheet software, presentation software, Adobe software, email management, digital calendars, and video conferencing.
• Understand Worldgate's mission, values, and behaviors (The Worldgate Way) and ensure that daily interactions with Worldgate internal and external parties align to Worldgate's values and behaviors.
• Comply with criminal background check standards by maintaining a clear record throughout employment.
Key Competencies:
• Database Administration
• Data Reporting
• SQL & ETL
• Stakeholder Communication
• Data Governance & Quality Management
Qualifications & Skills:
Required
• Bachelor's degree in Information Systems, Computer Science, Data Analytics, Business Administration, or a related field.
• 3 to 7 years of progressively responsible experience supporting enterprise databases, Student Information Systems (SIS), Enterprise Resource Planning (ERP) systems, or other enterprise applications
• Experience with relational databases, SQL Server, MySQL, Oracle, or similar database platforms.
• Experience supporting Student Information Systems or other enterprise applications.
• Experience with reporting tools, SQL development, data integrations, and ETL processes.
• Strong analytical, troubleshooting, communication, and documentation skills.
Preferred
• Experience supporting Ellucian Colleague and/or Banner
• Previous experience working in a higher education environment
• Experience supporting enterprise data integrations and data migration initiatives
Equal Opportunity Statement:
Worldgate LLC provides equal employment opportunities to all employees and applicants for employment, without regard to race, color, age, creed, religion, sex, sexual orientation, ancestry, national origin, disability, pregnancy, marital status, or gender identity.