DataEngineer

Job Title: Data Engineer Position Function: The Data Engineer & Architect plays a critical role in designing, building, and maintaining the district's data infrastructure. As the key technical expert bridging the gap between the district's data analysts and leadership, this position ensures that all data pipelines, transformations, and integrations are optimized for reliability, security, and compliance with FERPA/HIPAA. The Data Engineer & Architect will leverage Microsoft-based solutions (e.g., Azure Data Factory, SQL Server, Power BI ecosystem) to drive scalable, automated data workflows that support Wichita Public Schools' strategic vision and shared beliefs. Essential Performance Responsibilities: Data Pipeline Development & Management Design, develop, and maintain ETL/ELT workflows using Microsoft tools (e.g., Azure Data Factory, SSIS) to ingest and transform data from diverse sources (Oracle, on-premises systems, cloud services). Implement data validation, cleansing, and transformation processes to ensure high levels of data quality, accuracy, and consistency. Monitor and troubleshoot data pipelines, proactively addressing bottlenecks or failures to maintain seamless, reliable operations. Data Architecture & Modeling Architect and optimize data structures, including relational (star, snowflake) and dimensional models, within Microsoft SQL Server, Azure Synapse, or similar platforms. Develop and maintain logical and physical data models that align with district needs for analytics, compliance, and reporting. Collaborate with Data Analysts and the Director of Assessment & Research to ensure data structures effectively support key metrics, dashboards, and advanced analytics projects. Data Governance & Compliance Collaborate with the Information Services and Technology personnel to implement best practices for data governance, security, and lifecycle management. Ensure all data engineering processes adhere to FERPA, HIPAA, and district data privacy guidelines. As