Enterprise Data Integration Specialist

Lehigh Carbon Community College•Schnecksville, PA
•Onsite

About The Position

The Enterprise Data Integration Specialist is a highly technical role responsible for building and maintaining the backend data infrastructure that supports the college’s reporting and analytics systems. The work focuses on data extraction, ETL pipeline automation, complex SQL scripting, and automated job scheduling for college research and reporting. The position reports to the Assistant Director of Data and Analytics. The standard schedule is Monday through Friday, 8:00 AM to 5:00 PM on campus. Exempt professionals are expected to maintain a flexible schedule to meet responsibilities and collegiate needs, including occasional work outside core business hours. Occasional evening and weekend work may be required for production system maintenance. The role provides Tier 2/Tier 3 support for data access issues, broken reports, and failed scheduled jobs. It develops and maintains SQL/PLSQL database objects, ETL/ELT pipelines, automated job streams, data models, semantic layers, reports, and dashboards. The specialist also supports reporting staff, maintains backend data architectures and BI software, follows institutional data security requirements including RBAC, data masking, and FERPA privacy rules, and contributes to accreditation efforts and assigned projects. This position requires a high school diploma and relevant experience, as well as Act 153 clearances. An associate’s or bachelor’s degree in a related field and several technical capabilities are preferred. The position is not eligible for current or future H-1B or other employment visa sponsorship. Salary is restricted to the stated range and will not exceed its maximum; offers are non-negotiable and based on related work experience submitted on the resume. The position is open until filled.

Requirements

  • High school diploma and a minimum of 3 years of demonstrated experience responsible for building and maintaining backend data infrastructure for reporting and analytics systems.
  • At least 1 year of demonstrated experience in enterprise data management and analytics support, including hands-on complex SQL query writing, ETL pipeline automation, and relational database maintenance for institutional reporting.
  • Act 153 clearances: Act 34 Pennsylvania Criminal Background, Act 151 Pennsylvania Child Abuse History, and Act 114 FBI Clearance Fingerprinting.
  • Hands-on technical knowledge of enterprise relational databases such as Oracle and proficiency in writing, debugging, and optimizing complex SQL/PLSQL scripts.
  • Strong applied SQL skills, including window functions, recursive queries, and query performance tuning.
  • Capability supporting dimensional and relational data models, building ETL pipelines, and structuring backend data for modern BI platforms.
  • Hands-on experience operating and monitoring automated job scheduling systems to manage daily data workflows, dependencies, and pipeline errors.
  • Strong problem-solving skills and the ability to translate technical specifications and data requirements into functional database queries and reliable backend structures.
  • Working knowledge of data security protocols and the ability to apply 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.
  • Well organized, detail-oriented, and dedicated to providing customer service and reliable technical support to the institution's user community.

Nice To Haves

  • Associate’s or bachelor’s degree in Computer Science, Data Analytics, Information Systems, or a related quantitative field.
  • Practical experience with scripting languages such as Python, Bash, or PowerShell for automated data extraction, file handling, and pipeline maintenance.
  • Foundational or associate-level certifications in database administration, SQL, data engineering, or BI tools, such as Oracle Certified Associate, Microsoft Certified: Data Analyst, or CompTIA Data+.
  • Prior technical experience in higher education, especially 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, including the ability to translate user requirements into technical query logic and explain data issues to non-technical staff.
  • Experience with formal IT change management protocols, database deployment standards, and version control tools such as Git for SQL scripts and database objects.

Responsibilities

  • Provide Tier 2/Tier 3 support for functional users experiencing data access issues, broken reports, or failed scheduled jobs.
  • Write, debug, and optimize complex SQL/PLSQL queries, stored procedures, views, and user-defined functions across large-scale relational databases, including Oracle and Ellucian Banner.
  • Build, schedule, and maintain automated ETL/ELT pipelines from the enterprise SIS and secondary systems.
  • Design, monitor, and maintain automated job streams using enterprise workload schedulers such as ISE Enterprise Scheduler.
  • Support technical data models and backend semantic layers for enterprise reporting tools such as Evisions Argos and OBIEE.
  • Design and construct enterprise-level reports and interactive dashboards using BI tools such as Evisions Argos and OBIEE.
  • Provide backend technical support and query optimization assistance to functional reporting staff.
  • Apply institutional data security frameworks, including role-based access control, data masking, and FERPA-compliant privacy rules, in accordance with data stewardship and governance rules.
  • Assist with creating and updating data dictionaries, system integration documentation, and technical specifications.
  • Manage system updates and routine maintenance for backend data architectures, ETL pipelines, and BI software to support system performance, data security, and platform stability.
  • Follow and implement data security best practices and procedures.
  • Create and maintain Oracle stored objects, including procedures, packages, and functions.
  • Contribute to college accreditation efforts, including Middle States and program-specific accreditation standards.
  • Complete special projects as assigned.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service