Senior Enterprise Data Systems & Warehouse Administrator

Allentown City School District; Allentown (Lehigh County); On-site; USD 103,000 - 145,000; Full time

Job summary

Allentown City School District is seeking an Enterprise Data Systems & Data Warehouse Administrator to manage the district's data platforms, SIS (PowerSchool), data warehouse, and reporting infrastructure to support state reporting and strategic decision-making.

You will develop data pipelines, optimize SQL queries, and collaborate with academic, operations, and technology teams to ensure data quality, privacy, and timely analytics for district dashboards and reporting initiatives.

Qualifications

• Bachelor's degree in Computer Science, Data Science, Information Systems, Data Analytics, or a related field.
• Minimum of 5-7 years of experience with enterprise data systems, relational databases, or data integration environments.
• Strong proficiency in SQL and relational database querying.
• Experience using programming or scripting languages such as Python, Java, or similar languages to support data integration and automation.
• Experience with enterprise data systems or Student Information Systems.
• Experience supporting or administering PowerSchool SIS or similar enterprise student information systems.
• Experience with K-12 education data systems and state reporting requirements.
• Experience supporting data warehouse environments or centralized reporting databases.
• Experience supporting data visualization platforms such as Power BI or Tableau.

Responsibilities

• SIS Management and Data Systems Support: Maintain PowerSchool SIS to align with district reporting needs.
• System Integration: Collaborate with departments and vendors on SIS configurations and integrations.
• Data Stewardship: Manage historical and legacy data migration into current environments.
• User Support: Create processes and documentation for district staff using data systems.
• Data Warehouse and Data Integration: Design, maintain, and optimize data warehouse and reporting environments.
• Data Integration: Develop processes to integrate data across SIS, assessments, HR, and other systems.
• Data Pipelines: Develop and automate data pipelines and transformations for reporting.
• Data Modeling and Query Development: Develop SQL queries and data models for dashboards and analytics.
• Automation and Data Processing: Use Python/SQL/Java for data transformation and automation.
• Analytics Support: Prepare datasets for dashboards, research, and program evaluation.
• Data Governance and Data Quality: Validate data accuracy and completeness; maintain documentation; ensure privacy compliance.

Skills

SQL

Python/Java scripting

Data modeling

Data analysis

Education

Bachelor's degree in Computer Science/Data Science/Information Systems

Tools

PowerSchool SIS

Power BI/Tableau

SQL Databases

Job description

Allentown City School District is seeking an Enterprise Data Systems & Data Warehouse Administrator to manage the district's data platforms, SIS (PowerSchool), data warehouse, and reporting infrastructure to support state reporting and strategic decision-making.

You will develop data pipelines, optimize SQL queries, and collaborate with academic, operations, and technology teams to ensure data quality, privacy, and timely analytics for district dashboards and reporting initiatives.