Strategic Data Architect: Self-Service Analytics

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

Job summary

Lehigh Carbon Community College is seeking a Data Architect to design, automate, and maintain enterprise data infrastructure and reporting environments. You will lead data projects, enforce governance, and enable self-serve reporting through advanced SQL, data modeling, and automated workflows.

You will report to the Assistant Director of Enterprise Applications. Responsibilities include building data warehouses, ETL pipelines, and secure data access while collaborating with IT and campus

Qualifications

• Advanced SQL techniques and performance tuning.
• Experience with enterprise data warehouse design and governance.
• Experience writing and optimizing complex queries, stored procedures, and views.

Responsibilities

• Design and optimize central data warehouse structures for campus reports.
• Architect, schedule, and automate ETL/ELT pipelines from SIS and other systems.
• Write and optimize SQL queries across large relational databases.
• Maintain automated job streams and data pipelines with schedulers.
• Define and enforce data security frameworks (RBAC, data masking, FERPA).
• Collaborate with departments to translate analytics needs into technical architecture.
• Lead migration of legacy reporting to modern data platforms and establish API/data exchange standards.
• Maintain data models, mappings, and governance protocols.

Skills

SQL/PLSQL

Data modeling

ETL/ELT pipelines

Data governance

BI/self-service BI

Oracle DB

RBAC & data security

stakeholder collaboration

Education

Bachelor’s degree in Computer Science or related field

Tools

Ellucian Banner

Oracle

OBIEE

Evisions Argos

ISE Enterprise Scheduler

Job description

Lehigh Carbon Community College is seeking a Data Architect to design, automate, and maintain enterprise data infrastructure and reporting environments. You will lead data projects, enforce governance, and enable self-serve reporting through advanced SQL, data modeling, and automated workflows.

You will report to the Assistant Director of Enterprise Applications. Responsibilities include building data warehouses, ETL pipelines, and secure data access while collaborating with IT and campus