Enterprise Data Integration 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

The standard work week is Monday through Friday, 8:00 AM to 5:00 PM. Exempt professionals, are expected to maintain a flexible schedule to ensure all responsibilities and collegiate needs are met, including occasional work outside of core business hours. Occasional evening and weekend work may be required for production system maintenance.

Salary Ranges

$54,880 to $73,642

FLSA Status

Exempt

Position Summary

The Enterprise Data Integration Specialist is a highly technical role responsible for building and maintaining the backend data infrastructure that powers the college’s reporting and analytics systems. This role focuses on data extraction, ETL pipeline automation, complex SQL scripting, and orchestrating automated job schedules in support of college research and reporting.

This position reports to the Assistant Director of Data and Analytics.

Work Schedule:

The standard work week is Monday through Friday, 8:00 AM to 5:00 PM on campus.

Exempt professionals, are expected to maintain a flexible schedule to ensure all responsibilities and collegiate needs are met, including occasional work outside of core business hours. Occasional evening and weekend work may be required for production system maintenance.

Duties and Responsibilities:

• 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.

Required Qualifications:

Education

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

Certifications

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

Work Experience

• 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.

Knowledge, Skills, and Abilities

• 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.

Preferred

• 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.

Physical Demands

• 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.

LCCC Internal candidates must apply within 15 days of posting.

• 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.

Lehigh Carbon Community College
4525 Education Park Drive
Schnecksville, PA. 18078