Principal Data Engineer

EAB is dedicated to making education smarter and communities stronger by partnering with over 2,800 institutions. The Principal Data Engineer will design and implement data integration, warehousing, and analytics solutions while ensuring high-quality deliverables and guiding junior engineers.

Responsibilities:

• Lead project discovery for reporting and data solutions by facilitating external stakeholder calls, translating business questions into structured data needs and acceptance criteria, mapping data elements, identifying gaps and risks, and producing clear functional and technical requirements to guide design, build, and validation
• Support and advise technical leaders on system design and warehouse best practices, guiding teams and partners through complex data mapping and reconciliation challenges
• Design end-to-end integration and analytic solutions including ETL pipelines, integrations between different platforms, data quality and freshness validations, and business intelligence visualizations
• Independently break down, estimate, design, plan and deliver medium and large sized data-driven projects
• Understand and communicate base integration requirements on applications interfacing between on-premise and cloud architecture, especially on AWS
• Codify high-performing SQL for scalable data transformation to support replicable data pipelines
• Identify, investigate, and resolve performance and production issues, proactively recognizing recurring patterns and developing scalable solutions to prevent future occurrences
• Ensure high-quality deliverables by partnering with project teams to maintain accuracy, meet requirements, and drive measurable impact
• Guide junior engineers on tasks and unit projects
• Collaborate with development team and product managers to enhance existing product capabilities and develop new solutions

Requirements:

• Bachelor's degree in a related field or equivalent work experience
• 8+ years of advanced SQL programming experience, all syntaxes allowed, Postgres preferred
• 2+ years of basic Python programming experience on relational data management, including popular data management libraries
• 2+ years of cloud architecture scoping, design, and implementation work, AWS preferred
• Deep understanding of how data flows across systems
• Demonstrated problem-solving skills and ability to analyze problems and solve them creatively
• Experience writing and code-reviewing complex stored procedures
• Ability to ensure data integrity using standard rules, procedures, testing and validation
• Detail-oriented with ability to multitask and adapt to changing priorities
• Strong communication skills
• Master's degree in related field or equivalent work experience
• Experience communicating with external stakeholders and executives to strengthen integration of data systems, translate business needs into measurable impact, and advise on data enhancements and improvements
• Practical knowledge of how data warehouses are utilized and designed
• SPM certifications or demonstrated planning, organizing and time management skills
• Ability to work independently as well as collaborate with teammates to accomplish common goals in a fast-paced environment
• Commitment to embracing a continual learning environment and contributing to a dynamic and welcoming culture of fairness, authenticity, and belonging in support of EAB's mission, values, and aspiration