Enterprise Data Integration Engineer - ETL & BI Automation

Lehigh Carbon Community College; North Whitehall Township (PA); On-site; USD 70,000 - 110,000; Full time

Job summary

Lehigh Carbon Community College seeks an Enterprise Data Integration Specialist to build and maintain the backend data infrastructure powering reporting and analytics. This role emphasizes data extraction, ETL automation, complex SQL, and scheduling automated jobs on campus.

You will report to the Assistant Director of Data and Analytics and collaborate with IT and campus stakeholders to ensure data quality, security (FERPA/RBAC), and reliable BI feeds using Oracle, Ellucian Banner, Argos, and

Qualifications

• 3+ years building and maintaining backend data infrastructure for reporting and analytics.
• Experience writing complex SQL/PLSQL queries across large relational databases.
• Hands-on with ETL/ELT pipelines and automated job scheduling.

Responsibilities

• Provide Tier 2/3 support for data access issues and failed schedules.
• Design, monitor, and optimize ETL/ELT pipelines.
• Build and maintain automated job streams with enterprise schedulers.
• Support data models and backend semantic layers for reporting tools.
• Develop enterprise reports and interactive dashboards.
• Ensure data security per RBAC, FERPA and data governance.
• Assist with data dictionaries and technical specs.

Skills

SQL/PLSQL

ETL pipelines

Oracle databases

BI tools (Argos, OBIEE)

ISE Enterprise Scheduler

Data security (RBAC, FERPA)

Data modeling

Scripting (Python/Bash/PowerShell)

Communication skills

Education

Associate/Bachelor in CS/Data Analytics/IS

High School Diploma

Tools

Ellucian Banner

Oracle

ISE Enterprise Scheduler

Evisions Argos

OBIEE

Job description

Lehigh Carbon Community College seeks an Enterprise Data Integration Specialist to build and maintain the backend data infrastructure powering reporting and analytics. This role emphasizes data extraction, ETL automation, complex SQL, and scheduling automated jobs on campus.

You will report to the Assistant Director of Data and Analytics and collaborate with IT and campus stakeholders to ensure data quality, security (FERPA/RBAC), and reliable BI feeds using Oracle, Ellucian Banner, Argos, and