Data Architect — Self-Service Analytics & Governance

Lehigh Carbon Community College; Northern (KY); Hybrid; USD 54,000 - 74,000; Full time

Job summary

Lehigh Carbon Community College in Schnecksville, PA, seeks a Data Architect to design, automate, and maintain the college’s enterprise data infrastructure and reporting environments. You will lead data projects, enforce governance, and partner with IT and campus departments to ensure data security and self-service reporting through advanced SQL, data modeling, and automated workflows.

This exempt, full-time role reports to the Assistant Director of Enterprise Applications and requires strong

Qualifications

• High School Diploma or GED (mandatory).
• 5+ years of experience in data analytics, enterprise data systems, or related.
• OR 3+ years with 60+ credits in a relevant field.

Responsibilities

• Design and optimize central data warehouse structures for campus reporting.
• Architect and automate ETL/ELT pipelines from enterprise systems.
• Write and optimize complex SQL queries and procedures.
• Maintain automated job streams to coordinate data extraction and reporting.
• Define and enforce data security, RBAC, and FERPA compliance.

Skills

SQL

Data modeling

ETL/ELT orchestration

BI reporting

Data governance

Analytical thinking

Problem solving

Communication skills

Teamwork

Automation

Education

High School Diploma or GED

60+ earned college credits

Bachelor’s degree in CS or related

Tools

Oracle

Ellucian Banner

ISE Enterprise Scheduler

Argos

OBIEE

Job description

Lehigh Carbon Community College in Schnecksville, PA, seeks a Data Architect to design, automate, and maintain the college’s enterprise data infrastructure and reporting environments. You will lead data projects, enforce governance, and partner with IT and campus departments to ensure data security and self-service reporting through advanced SQL, data modeling, and automated workflows.

This exempt, full-time role reports to the Assistant Director of Enterprise Applications and requires strong