Enterprise Data Integration Specialist

• Specialist provides Tier 2/Tier 3 support for functional users experiencing data access issues, broken reports, or failed scheduled jobs.
• Writes, debugs, and optimizes complex SQL/PLSQL queries, stored procedures, views, and user-defined functions across large-scale relational databases (Oracle, Ellucian Banner).
• Builds, schedules, and maintains automated ETL/ELT pipelines from the enterprise SIS (eg., Ellucian Banner) and secondary systems.
• Designs, monitors, and maintains automated job streams using enterprise workload schedulers (e.g., ISE Enterprise Scheduler).
• Supports technical data models and backend semantic layers to support enterprise reporting tools (e.g., Evisions Argos, OBIEE).
• Design and construct enterprise-level reports and interactive dashboards using modern BI tools (e.g., Evisions Argos, OBIEE)
• Provides backend technical support and query optimization assistance to functional reporting staff.
• Comply with institutional data security frameworks, including fine-grained Role-Based Access Control (RBAC), data masking, and FERPA compliant privacy rules, to guarantee strict data integrity, confidentiality, and legal compliance, based on adherence from data stewards and data governance rules.
• Assist with creation and updates to data dictionaries, system integration documentation, and technical specs.
• Manages the application of system updates and routine maintenance for backend data architectures, ETL pipelines, and BI software to ensure continuous system performance, data security, and platform stability.
• Follows and implements data security best practices and procedures.
• Creates and maintains Oracle Stored Objects (procedures, packages, functions).
• Contributes to the college’s accreditation efforts, including the overall Middle States accreditation and any program specific accreditation standards.
• Complete special projects as assigned.

• High School Diploma and minimum 3 years of demonstrated experience responsible for building and maintaining backend data infrastructure that powers reporting and analytics systems.

• Act 153 Clearances (Act 34 PA Criminal Background, Act 151 PA Child Abuse History, Act 114 FBI Clearance Fingerprinting)

• Minimum of one year of demonstrated experience in enterprise data management and analytics support, including hands-on proficiency in writing complex SQL queries, automating ETL pipelines, and maintaining relational databases to drive institutional reporting.

• Hands-on technical knowledge of enterprise relational databases (e.g., Oracle) and proficiency in writing, debugging, and optimizing complex SQL/PLSQL scripts.
• Strong capability in applied SQL techniques (including window functions, recursive queries, and query performance tuning) to extract and transform data for institutional reporting.
• Practical proficiency in supporting data models (dimensional and relational), building ETL pipelines, and structuring backend data for modern BI platforms (e.g., Evisions Argos, OBIEE).
• Hands-on experience operating and monitoring automated job scheduling systems (e.g., ISE Enterprise Scheduler) to manage daily data workflows, handle dependencies, and troubleshoot pipeline errors.
• Strong problem-solving skills with the ability to translate technical specifications and data requirements into functional database queries and reliable backend structures.
• Working knowledge of data security protocols, with the ability to accurately apply Role-Based Access Control (RBAC) scripts, data masking, and FERPA compliance measures at the database level.
• Ability to manage individual task deadlines, troubleshoot technical requests, and collaborate effectively with functional users and the broader IT department.
• Must be well organized, detail-oriented, and dedicated to providing outstanding customer service and reliable technical support to the institution’s user community.

• Associate’s or Bachelor’s degree in Computer Science, Data Analytics, Information Systems, or a related quantitative field.
• Practical experience with scripting languages (e.g., Python, Bash, or PowerShell) to support automated data extraction, file handling, and pipeline maintenance.
• Foundational or associate-level certifications in database administration, SQL, data engineering, or BI tools (e.g., Oracle Certified Associate, Microsoft Certified: Data Analyst, or CompTIA Data+).
• Prior technical experience in a higher education environment, specifically querying and extracting data from Ellucian Banner relational tables.
• Demonstrated experience designing, formatting, and validating operational reports and dashboards for functional end users using enterprise BI tools.
• Strong interpersonal and written communication skills, with proven ability to translate user requirements into technical query logic and explain data issues to non-technical staff.
• Experience following formal IT change management protocols, adhering to database deployment standards, and utilizing version control tools (e.g., Git) for SQL scripts and database objects.

• Ability to effectively communicate, perceive, and exchange information with colleagues and stakeholders.
• Operate, handle, or feel objects, tools, or controls using hands, arms, or adaptive equipment.
• Ability to safely lift, transport, or move objects up to 15 lbs regularly and up to 25 lbs occasionally.
• Vision capabilities sufficient to view screens, read printed materials, and observe work environments (with or without assistive devices).
• Occasional evening and weekend work may be required for production system maintenance.

• The noise level in the work environment is usually quiet to moderate.

Please note that this position is not eligible for current or future H-1B or other employment visa sponsorship.

• Salary is restricted to above range and will not exceed the maximum of the range. Salary offers are non negotiable and offers are determined and are based upon related work experience submitted on resume. 
• Foreign degrees – must provide a US equivalency report of your degree credentials with your transcript, if not, your resume will not be accepted.