Enterprise Data Systems and Data Warehouse Administrator

Allentown, PA, US • Posted 2 days ago • Updated 53 minutes ago
Full Time
On-site
USD $103,413.00 - 144,778.00 per year
Fitment

Dice Job Match Score™

👾 Reticulating splines...

Job Details

Skills

  • Computer Science
  • Data Science
  • Data Analysis
  • Relational Databases
  • RDBMS
  • Information Systems
  • Data Visualization
  • Microsoft Power BI
  • Tableau
  • Strategic Planning
  • Continuous Improvement
  • Management
  • System Integration
  • Data Stewardship
  • Technical Support
  • Optimization
  • Data Warehouse
  • Data Integration
  • Data Engineering
  • Data Modeling
  • Data Processing
  • Scripting
  • Programming Languages
  • Python
  • SQL
  • Java
  • Analytics
  • Collaboration
  • Dashboard
  • Research
  • Program Evaluation
  • Data Quality
  • Decision-making
  • Documentation
  • Reporting
  • Regulatory Compliance
  • Privacy
  • Data Governance
  • Database
  • Warehouse
  • PDF

Summary

Position Type:
Administration/Administrator

Date Posted:
3/27/2026

Location:
Administration Center - Allentown, PA

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).

Attachment(s):
  • Enterprise Data Systems & Database Warehouse Administrator - 3.26.26.pdf
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91152686
  • Position Id: 91e046ce09f5a0b7ef378ad2aa1dceac
  • Posted 2 days ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Allentown, Pennsylvania

Today

Full-time

Allentown, Pennsylvania

Today

Full-time

USD 76,600.00 - 86,600.00 per year

Remote or Easton, Pennsylvania

Today

Easy Apply

Full-time

USD 100,000.00 - 120,000.00 per year

Allentown, Pennsylvania

Today

Easy Apply

Contract

$80 - $100

Search all similar jobs