Data Architect

Job Title

The Data Architect designs, automates, and maintains the college’senterprise data infrastructure and reporting environments. The Data Architect leads technical data projects, enforces data governance,and serves as the primary technical liaison between IT staff and functional departments to ensure data system performance, security,and integrity. This is a strategic role empowering campus stakeholders to drive self-service reporting by writing advancedSQL database queries, architecting efficient data models, and automating critical data workflows.

This position reports to the Assistant Director of Enterprise Applications.

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 andcollegiate needs are met, including occasional work outside of core business hours.

• Design and optimize central data warehouse structures and semantic layers tailored for campus departments to generate,analyze, and automate their own operational and strategic reports.
  
  Translate complex data sets into clear, actionable businessinsights by designing and developing enterprise-level reports andinteractive dashboards using modern BI tools (e.g., Evisions Argos,OBIEE)
• Architect, schedule, and automate robust ETL/ELT pipelines fromthe enterprise SIS (e.g., Ellucian Banner) and secondary systems into the central data repository for real-time and scheduledanalytics.
• Write, debug, and optimize highly complex SQL queries, storedprocedures, views, and user-defined functions across large-scalerelational databases.
• Design, monitor, and maintain automated job streams usingenterprise workload schedulers (e.g., ISE Enterprise Scheduler) to coordinate data extraction from enterprise database systems (e.g.,Oracle, Ellucian Banner), manage data pipeline dependencies, and automate scheduled report generation and delivery through reportingsoftware.
• In partnership with data stewards and data governance, define,implement, and maintain institutional data security frameworks,including fine-grained Role-Based Access Control (RBAC), data masking, and FERPA compliant privacy rules, to guarantee strictdata integrity, confidentiality, and legal compliance.
• Partner directly with functional departments to analyzereporting requirements and translate functional analytics needsinto sustainable technical architecture.
• Lead the migration of legacy reporting structures into modern data platform environments, establishing standards for APIintegrations and third-party data exchanges.
• Maintain comprehensive data models, data mapping, system integration diagrams, and governance access protocols.
• Serve as a technical member of the Data Governance Committee,establishing institutional data standards, access policies, anddata security guidelines.
• Coordinate and support the implementation and maintenance ofthird-party products and interfaces interacting with enterprisedatabase systems.
• Contributes to the college’s accreditation efforts, including the overall Middle States accreditation and any program specificaccreditation standards.
• Complete special projects as assigned

• High School Diploma or GED equivalent (mandatory for all candidates).

AND

• Minimum 5 years of demonstrated experience in data analytics,enterprise data systems, systems architecture, and/or related.

OR

• Minimum 3 years of demonstrated experience in data analytics,enterprise data systems, systems architecture, and/or related at an enterprise level with 60+ earned credits of higher education in arelevant field.

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

• Three or more years of experience in enterprise data systems,and/or technical project management.

• Working technical knowledge of database systems and enterpriserelational database technologies, such as Oracle andSQL/PLSQL.
• High-level SQL techniques, including window functions,recursive queries, query execution plan analysis, indexing strategies, and performance…