Data Engineer

3 days ago

Wichita, KS, United States Wichita Public Schools Full time
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.
    • Assist with defining and enforcing data standards, naming conventions, and documentation to enhance consistency and transparency.
  • DataOps & Automation
    • Implement DataOps practices (continuous integration, version control, automated testing) to streamline data development and reduce errors.
    • Manage environments and releases for data pipelines, including dev, test, and production, coordinating with IT and other stakeholders.
    • Introduce best practices around DevOps in Azure, leveraging scripts, templates, and modern deployment strategies.
  • Collaboration & Stakeholder Engagement
    • Work closely with Data Analysts, providing properly structured datasets and ensuring minimal friction in analytics and reporting.
    • Partner with district IT teams and other departments to align architectural decisions with broader technology initiatives.
    • Communicate technical concepts and project updates to non-technical audiences, ensuring clarity and alignment of expectations.


Additional Duties: Performs other duties as assigned by the Chief Information Officer or other district leadership in support of Wichita Public Schools' strategic goals and mission.

Equipment: This position may require the use of standard office technology such as computers, copiers, and scanners, as well as Microsoft Azure-based tools (e.g., Azure Data Factory, Azure SQL Database). Must always comply with Wichita Public Schools' guidelines for equipment use and data security.

Travel: Limited travel between schools and central offices may be required to consult with school-based teams, attend training, or assist with on-site data needs.

Physical and Mental Demands:
  • Work in standard office environments
  • Ability to focus on computer-based tasks for extended periods
  • Occasional requirements for lifting or moving technology equipment (generally under 30 pounds)
  • Must be prepared to respond rapidly to system or data-related issues outside of standard work hours
  • Additional demands upon request of supervisor


Knowledge, Skills, and Abilities:
  • Technical Expertise:
    • Advanced knowledge of Microsoft data engineering technologies (Azure Data Factory, Azure Synapse, SQL Server, Power BI, SSIS)
    • Proficiency in scripting languages (e.g., Python, PowerShell) for automation and data manipulation
    • Understanding of DataOps, CI/CD, and version control (Git)
  • Data Modeling:
    • Strong background in relational and dimensional modeling, including the design of star/snowflake schemas
    • Experience optimizing data storage and retrieval in cloud-based or hybrid environments
  • Collaboration & Communication:
    • Ability to work effectively with cross-functional teams, including Data Analysts, Data Governance leads, and IT staff
    • Strong written and verbal communication skills to convey complex ideas in accessible language
  • Analytical & Problem-Solving Skills:
    • Capable of diagnosing and resolving issues quickly in a large-scale, diverse data environment
    • Familiarity with advanced analytics techniques or interest in supporting statistical modeling is a plus
  • Compliance & Security:
    • Knowledge of FERPA/HIPAA and best practices for data privacy and security
    • Able to integrate security and governance requirements into data pipeline design


Interrelations:
  • Works under the supervision of the Chief Information Officer in collaboration with the district's IT teams
  • Regular contact with Data Analysts, school administrators, and other staff to gather requirements, provide data solutions, and ensure alignment with district objectives
  • Must handle all situations with professionalism, tact, and confidentiality


Employee Punctuality and Appearance:
  • Expected to perform assigned duties and work all scheduled hours unless approved leave is granted
  • Any deviation from assigned hours requires prior approval from the immediate supervisor or administrator
  • Required to dress in a manner that reflects a positive image of Wichita Public Schools and is appropriate for a data engineering/architecture leadership role


Qualification Profile:
  • Bachelor's degree in Computer Science, Data Engineering, Information Systems, or a related field required; advanced degree preferred
  • Minimum of 3-5 years of experience in data engineering, data architecture, or comparable roles, preferably in a large organization (public education environment a plus)
  • Hands-on experience with Microsoft Azure data services, SQL Server, and BI solutions
  • Microsoft Certified: Azure Data Engineer Associate, or similar Azure/SQL certifications preferred


FLSA Status: Exempt

  • Data Engineer

    1 day ago

    Wichita, KS, United States Spirit AeroSystems Full time

    Overview This role is at Spirit AeroSystems, Inc. a wholly owned subsidiary of The Boeing Company, supporting Spirit’s Commercial Business Units (“Spirit Commercial”). Spirit Commercial designs and builds commercial aerostructures, including for Boeing Commercial Airplanes, one of Boeing’s three business units and the premier manufacturer of...

  • Senior Software Engineer

    2 weeks ago

    Wichita, KS, United States Tyler Technologies Full time

    We are looking for a remarkable Senior Software Engineer to join us! We've built a team of not just the best engineers, but some really awesome humans as well. This team builds cloud software (platform + apps + ecosystem) to accelerate the flow of government data into the hands of citizens, developers, businesses and researchers. With our Data & Insights...

  • Senior Software Engineer

    1 week ago

    Wichita, KS, United States Credit Acceptance Full time

    Join Credit Acceptance, an award-winning company recognized both locally and nationally for our outstanding workplace culture! We pride ourselves on our dedicated Team Members who drive success as professionals and as a unified organization. Our combination of innovative products, exceptional people, and solid financial history has made us one of the largest...

  • Senior Software Engineer

    2 weeks ago

    Wichita, KS, United States Credit Acceptance Full time

    Join Credit Acceptance, an award-winning company recognized both locally and nationally for our outstanding workplace culture! We pride ourselves on our dedicated Team Members who drive success as professionals and as a unified organization. Our combination of innovative products, exceptional people, and solid financial history has made us one of the largest...

  • Intern, Software Engineering and Data Operator

    3 days ago

    Wichita, KS, United States Bombardier Full time

    When applicable, Bombardier promotes flexible and hybrid work policies. Why join us? At Bombardier, we design, build and maintain the world's peak-performing aircraft for the world's most discerning people and businesses, governments and militaries. We have been successful in setting the highest standards by putting our people at the heart of it all, and...

  • Intern, Software Engineering and Data Operator

    1 week ago

    Wichita, KS, United States Bombardier Full time

    When applicable, Bombardier promotes flexible and hybrid work policies. Why join us? At Bombardier, we design, build and maintain the world's peak-performing aircraft for the world's most discerning people and businesses, governments and militaries. We have been successful in setting the highest standards by putting our people at the heart of it all, and...

  • Intern, Software Engineering and Data Operator

    5 days ago

    Wichita, KS, United States Bombardier Full time

    When applicable, Bombardier promotes flexible and hybrid work policies. Why join us? At Bombardier, we design, build and maintain the world's peak-performing aircraft for the world's most discerning people and businesses, governments and militaries. We have been successful in setting the highest standards by putting our people at the heart of it all, and...

  • Intern, Software Engineering and Data Operator

    2 weeks ago

    Wichita, KS, United States Bombardier Full time

    When applicable, Bombardier promotes flexible and hybrid work policies. Why join us? At Bombardier, we design, build and maintain the world's peak-performing aircraft for the world's most discerning people and businesses, governments and militaries. We have been successful in setting the highest standards by putting our people at the heart of it all, and...

  • Databricks Data Engineer

    6 days ago

    Wichita, KS, United States Kansas Staffing Full time

    Senior Consultant Data Engineer At EY, we're all in to shape your future with confidence. We'll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go. Join EY and help to build a better working world. We are seeking a highly skilled Senior Consultant Data Engineer with expertise in cloud data...

  • Databricks Data Engineer

    6 days ago

    Wichita, KS, United States Kansas Staffing Full time

    Senior Consultant Data Engineer At EY, we're all in to shape your future with confidence. We'll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go. Join EY and help to build a better working world. We are seeking a highly skilled Senior Consultant Data Engineer with expertise in cloud data...