Enterprise Data Systems and Data 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

Enterprise Data Systems & Data Warehouse Administrator
Salary: $103,413-$144,778

Qualifications:

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

Summary

The Enterprise Data Systems and Data Warehouse Administrator plays a critical role in supporting the district's enterprise data systems and integrated data environments that enable reporting, analytics, and strategic decision-making.

This position supports the management of the district's Student Information System (SIS), the development and maintenance of the district's data warehouse and reporting infrastructure, and the integration of data from multiple district systems. The role collaborates with academic, operational, and technology teams to ensure district data systems support state reporting, strategic planning, and continuous improvement initiatives.

Essential Duties and Responsibilities

SIS Management and Data Systems Support

• System Support: Support the maintenance, configuration, and optimization of the PowerSchool Student Information System to ensure alignment with district operational and reporting needs.
• System Integration: Collaborate with district departments and vendors to ensure SIS configurations, integrations, and customizations support district data and reporting requirements.
• Data Stewardship: Support the transfer, organization, and stewardship of historical records and legacy data from prior systems into current enterprise data environments.
• User Support: Assist in developing sustainable processes and documentation to support district staff using enterprise data systems and reporting tools.

Data Warehouse and Data Integration

• Data Warehouse Development: Support the design, maintenance, and optimization of the district's data warehouse and centralized reporting environments.
• Data Integration: Develop and maintain processes to integrate data from district systems including SIS, assessment platforms, HR systems, and other operational systems.
• Data Pipelines: Support development and automation of data pipelines and data transformation processes that prepare data for reporting and analytics.

Data Engineering and Reporting Support

• Data Modeling and Query Development: Develop and optimize SQL queries and data models used for reporting, dashboards, and district analytics.
• Automation and Data Processing: Utilize scripting and programming languages such as Python, SQL, or Java to support data transformation, validation, and automation processes.
• Analytics Support: Collaborate with district staff to prepare datasets used for dashboards, research, program evaluation, and strategic decision-making.

Data Governance and Data Quality

• Data Quality Assurance: Support processes that validate the accuracy and completeness of district data used for reporting and decision-making.
• Documentation: Maintain documentation of database structures, data definitions, and reporting processes.
• Data Privacy Compliance: Ensure compliance with district policies related to student data privacy and security including Policy 830 (Security of Computerized Personal Information) and Policy 830.1 (Data Governance).