ETL & Oracle SQL Data Specialist

Lehigh Carbon Community College; Pennsylvania; On-site; USD 55,000 - 74,000; Full time

Job summary

Lehigh Carbon Community College seeks an Enterprise Data Integration Specialist to build and maintain backend data infrastructure powering reporting and analytics. You will focus on data extraction, ETL automation, complex SQL scripting, and scheduling automated jobs for institutional research and reporting.

This role reports to the Assistant Director of Data and Analytics and requires a flexible schedule including occasional evenings or weekends for production maintenance.

Qualifications

• Must have 3+ years building backend data infrastructure.
• Experience with Oracle databases and SQL/PLSQL.
• Experience creating and maintaining ETL/ELT pipelines.
• Familiarity with FERPA and RBAC security controls.

Responsibilities

• Provide Tier 2/3 support for data access issues and failed jobs.
• Write, debug, and optimize SQL/PLSQL queries and procedures.
• Build and maintain automated ETL/ELT pipelines from Ellucian Banner and other systems.
• Design and monitor automated job streams with enterprise schedulers.
• Support data models and backend semantic layers for reporting tools.
• Develop enterprise reports and dashboards using BI tools.
• Provide backend support and query optimization for staff.
• Ensure data security, masking, and governance compliance.
• Assist with data dictionaries and technical documentation.
• Manage system updates and routine maintenance for data architectures.

Skills

SQL

PL/SQL

Oracle

ETL pipelines

BI tools

Job scheduling

Data security

Data modeling

Education

High School Diploma + 3 years backend data experience

Act 153 Clearances

1+ year enterprise data management experience

Associate’s or Bachelor’s degree preferred

Tools

ISE Enterprise Scheduler

Ellucian Banner

OBIEE

Evisions Argos

Job description

Lehigh Carbon Community College seeks an Enterprise Data Integration Specialist to build and maintain backend data infrastructure powering reporting and analytics. You will focus on data extraction, ETL automation, complex SQL scripting, and scheduling automated jobs for institutional research and reporting.

This role reports to the Assistant Director of Data and Analytics and requires a flexible schedule including occasional evenings or weekends for production maintenance.