Senior Data Engineer 1

At PowerSchool, we are a dedicated team of innovators guided by our shared purpose of powering personalized education for students around the world. From the central office to the classroom to the home, PowerSchool supports the entire educational ecosystem as the global leader of cloud-based software for K-12 education. Our employees make it all possible, and a career with us means you’re joining a successful team committed to engaging, empowering, and improving the K-12 education experience everywhere.

Team Overview

Our Information Technology (IT) team leads all aspects of IT systems and processes across the enterprise, including data services, security, compliance, applications, automation, and end-user services. Through innovative and streamlined technology solutions, this dynamic team enables company growth​, protects data, and serves as a critical partner to all departments of PowerSchool.

As Senior Data Engineer, you will serve as an integral member of the Enterprise Applications team, helping to build and design the data platform for the Company as well as scaling architecture and warehouse solutions. As we grow and scale, the Senior Data Engineer is responsible for taking the business through transition and setting teams up for success by interfacing and collaborating with the Marketing, Finance, Sales, Success, and Support teams. Additionally, in this position, you will help to mentor other team members and engage with stakeholders in guiding them through technical conversations.

The Data Engineering team develops, implements, and maintains scalable data architectures and databases. Your day-to-day job will consist of:

• Acts as system administrator for Data Warehouse, including maintenance of user access, user security, creation of objects, monitoring of extract file loads, maintenance and setup of report schedules, maintenance of hierarchies, validation of data integrity, and creation of custom views and queries
• Is responsible for the monitoring of day-to-day tasks and pipelines related to the Operational Data Warehouse, including breakfix and performance tuning to ensure the Data Warehouse delivers accurately and on SLA
• Designs, builds, and owns core data models and key infrastructure to manage data and usage across our Snowflake account with an emphasis on Operational data including but not limited to Sales, Finance, Support, Marketing and Success data marts
• Creates business intelligence reports for business partners as needed
• Manages architectural issues and recommend alternatives, when appropriate
• Works with vendors to troubleshoot and resolve system problems; provide on-call support, as required.
• Ensures compliance for all data warehouse administration activities
• Manages and collects business metadata and data integration points
• Coordinates with business analysts and prepares data warehouse design for systems; analyzes user requirements; prepares technical design specifications to address user needs.

• Minimum of 5+ years of relevant and related work experience.
• Bachelor’s degree or equivalent, or equivalent years of relevant work experience.
• Additional experience may be substitute for an advanced Degree.
• A strong understanding of Python scripting language
• 2+ years experience with Terraform, AWS and Snowflake in a production environment
• 6+ years of experience building data pipelines from data source and landing to analytics layer
• The ability to write program in queries using Structured Query Languages (SQL) to build, maintain, and extract and transform data from relational databases
• Capable of effectively manage multiple project and service requests.
• Excellent organizational, analytical, and problem-solving skills
• Top notch written and verbal communication skills
• Strong investigation, remediation, and reporting intuition
• The ability to collaborate effectively within and across departments

PowerSchool is committed to a diverse and inclusive workplace. PowerSchool is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. Our inclusive culture empowers PowerSchoolers to deliver the best results for our customers. We not only celebrate the diversity of our workforce, we celebrate the diverse ways we work. If you have a disability and need an accommodation regarding our recruiting process, please let us know by emailing accomodations@powerschool.com.

#LI-KH1