Enterprise Data Integration Specialist

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

Position Summary

The Enterprise Data Integration Specialist is a highly technicalrole responsible for building and maintaining the backend datainfrastructure that powers the college’s reporting and analyticssystems. This role focuses on data extraction, ETL pipelineautomation, complex SQL scripting, and orchestrating automated jobschedules in support of college research and reporting.

This position reports to the Assistant Director of Data andAnalytics.

Work Schedule

The standard work week is Monday throughFriday, 8:00 AM to 5:00 PM on campus. Exempt professionals, areexpected to maintain a flexible schedule to ensure allresponsibilities and collegiate needs are met, including occasionalwork outside of core business hours. Occasional evening and weekendwork may be required for production system maintenance.

Duties and Responsibilities

• Specialist provides Tier 2/Tier 3 support for functional usersexperiencing data access issues, broken reports, or failedscheduled jobs.
• Writes, debugs, and optimizes complex SQL/PLSQL queries, storedprocedures, views, and user-defined functions across large-scalerelational databases (Oracle, Ellucian Banner).
• Builds, schedules, and maintains automated ETL/ELT pipelinesfrom the enterprise SIS (eg., Ellucian Banner) and secondarysystems.
• Designs, monitors, and maintains automated job streams usingenterprise workload schedulers (e.g., ISE EnterpriseScheduler).
• Supports technical data models and backend semantic layers tosupport enterprise reporting tools (e.g., Evisions Argos,OBIEE).
• Design and construct enterprise-level reports and interactivedashboards using modern BI tools (e.g., Evisions Argos, OBIEE)
• Provides backend technical support and query optimizationassistance to functional reporting staff.
• Comply with institutional data security frameworks, includingfine-grained Role-Based Access Control (RBAC), data masking, andFERPA compliant privacy rules, to guarantee strict data integrity,confidentiality, and legal compliance, based on adherence from datastewards and data governance rules.
• Assist with creation and updates to data dictionaries, systemintegration documentation, and technical specs.
• Manages the application of system updates and routinemaintenance for backend data architectures, ETL pipelines, and BIsoftware to ensure continuous system performance, data security,and platform stability.
• Follows and implements data security best practices andprocedures.
• Creates and maintains Oracle Stored Objects (procedures,packages, functions).
• Contributes to the college’s accreditation efforts, includingthe overall Middle States accreditation and any program specificaccreditation standards.
• Complete special projects as assigned.

Education

• High School Diploma and minimum 3 years of demonstratedexperience responsible for building and maintaining backend datainfrastructure that powers reporting and analytics systems.

Certifications

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

Work Experience

• Minimum of one year of demonstrated experience in enterprisedata management and analytics support, including hands-onproficiency in writing complex SQL queries, automating ETLpipelines, and maintaining relational databases to driveinstitutional reporting.

Knowledge, Skills, and Abilities

• Hands-on technical knowledge of enterprise relational databases(e.g., Oracle) and proficiency in writing, debugging, andoptimizing complex SQL/PLSQL scripts.
• Strong capability in applied SQL techniques (including windowfunctions, recursive queries, and query performance tuning) toextract and transform data for institutional reporting.
• Practical proficiency in supporting data models (dimensionaland relational), building ETL pipelines, and structuring backenddata for modern BI platforms (e.g., Evisions Argos, OBIEE).
• Hands-on experience operating and monitoring automated jobscheduling systems (e.g., ISE Enterprise Scheduler) to manage dailydata workflows, handle dependencies, and troubleshoot pipelineerrors.
• Strong problem-solving skills with the ability to translatetechnical specifications and data requirements into functionaldatabase queries and reliable backend structures.
• Working knowledge of data security protocols, with the abilityto accurately apply Role-Based Access Control (RBAC) scripts, datamasking, and FERPA compliance measures at the database level.
• Ability to manage individual task deadlines, troubleshoottechnical requests, and collaborate effectively with functionalusers and the broader IT department.
• Must be well organized, detail-oriented, and dedicated toproviding outstanding customer service and reliable technicalsupport to the institution's user community.

Preferred

• Associate’s or Bachelor’s degree in Computer Science, DataAnalytics, Information Systems, or a related quantitativefield.
• Practical experience with scripting languages (e.g., Python,Bash, or PowerShell) to support automated data extraction, filehandling, and pipeline maintenance.
• Foundational or associate-level certifications in databaseadministration, SQL, data engineering, or BI tools (e.g., OracleCertified Associate, Microsoft Certified: Data Analyst, or CompTIAData+).
• Prior technical experience in a higher education environment,specifically querying and extracting data from Ellucian Bannerrelational tables.
• Demonstrated experience designing, formatting, and validatingoperational reports and dashboards for functional end users usingenterprise BI tools.
• Strong interpersonal and written communication skills, withproven ability to translate user requirements into technical querylogic and explain data issues to non-technical staff.
• Experience following formal IT change management protocols,adhering to database deployment standards, and utilizing versioncontrol tools (e.g., Git) for SQL scripts and databaseobjects.

Physical Demands

• Ability to effectively communicate, perceive, and exchangeinformation with colleagues and stakeholders.
• Operate, handle, or feel objects, tools, or controls usinghands, arms, or adaptive equipment.
• Ability to safely lift, transport, or move objects up to 15 lbsregularly and up to 25 lbs occasionally.
• Vision capabilities sufficient to view screens, read printedmaterials, and observe work environments (with or without assistivedevices).
• Occasional evening and weekend work may be required forproduction system maintenance.

Work Environment

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

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

LCCC is an equal opportunity employer.

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

Position open until filled.