Fast Facts

PowerSchool is seeking a Senior Solution Architect to lead the design and implementation of data solutions for K-12 education systems, ensuring data integrity and providing technical mentorship.

Responsibilities: Lead the architecture and implementation of ETL processes, design data models, translate analytics goals into data requirements, ensure data quality, and mentor staff on PowerSchool technologies.

Skills: Strong SQL skills, experience in ETL processes, data modeling, dimensional design, and the ability to communicate effectively with diverse stakeholders.

Qualifications: Bachelor's degree or equivalent experience, 12+ years in related work, and understanding of data warehouse concepts; preferred experience with the education sector.

Location: This position is based in the USA with remote flexibility.

Compensation: $138100 - $187700 / Annually

Overview

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

The Services team works closely together to set PowerSchool customers up for ongoing success through post-implementation support, troubleshooting, consultation on system setup options, and training on features and functionality. The team offers cross-portfolio support, all while meeting organizational objectives for revenue, utilization, and customer satisfaction.

Responsibilities

Description

This role is responsible for leading the design, development, and implementation of data solutions while providing technical mentorship and ensuring data integrity.

Your day-to-day job will consist of:

• Data Engineering & ETL Development: Architect and implement robust and scalable ETL processes to populate data warehouses and data marts. This involves designing and guiding the development of SQL Server stored procedures, functions, views, and triggers. Proficiency in data extraction, cleansing, transformation, loading, and data quality assurance is essential.
• Data Modeling & Dimensional Design: Lead the design and implementation of dimensional models that support business intelligence and reporting needs. This includes understanding business processes, identifying key dimensions and measures, and optimizing the data model for query performance.
• Solution Architecture & Design: Define and document the architecture of systems within specific solutions, conducting thorough requirements analysis and creating detailed designs that align with the overall product architecture and business needs. This includes considering scalability, maintainability, and security.
• Data Analysis & Requirements Gathering: Translate complex analytics goals into actionable data requirements, working closely with stakeholders to understand their needs and identify key metrics. Lead requirements gathering sessions and document findings clearly and concisely.
• Data Quality & Governance: Direct data profiling and source-to-target mappings to ensure data quality and consistency. Implement data quality checks and monitoring processes to identify and resolve data issues. Ensure compliance with data governance policies and regulations.
• Data Architecture & Lifecycle Management: Demonstrate deep expertise in the end-to-end data lifecycle within cloud-based backend environments. This includes designing data models, implementing governance policies, and ensuring data quality and security.
• Collaborative Solution Development & Business Partnership: Develop solutions collaboratively with business and application leads, translating business needs into technical specifications. This requires strong communication skills and building consensus among diverse stakeholders.
• Technical Enablement & Support: Mentor, train, and coach implementation staff on PowerSchool technologies and products, empowering them to effectively deploy and support solutions. This includes creating training materials, conducting workshops, and providing ongoing support to ensure consistent and efficient operations, including troubleshooting issues, documenting best practices, and contributing to team knowledge sharing.
• Product & Sales Support & Collaboration: Provide technical input and support to the product development team, contributing to the evolution of the product roadmap. To drive successful sales outcomes, offer technical expertise to the sales team, and assist with demos, proposals, and client interactions.

Qualifications

Minimum Qualifications

• Bachelor’s degree or equivalent and relevant business experience
• Minimum of 12+ years of related work experience
• 8-10 years of experience in ETL and implementations
• Strong SQL skills and proficiency in writing complex SQL
• Understanding of data warehouse concepts, data modeling, and dimensional design
• Communicates a sincere desire to provide high-quality implementation services placing customer value first

Preferred Qualifications

• Additional relevant experience may be substitute for an advanced degree
• Understanding of educational terminology, data standards and customer expectations in the education sector
• Possess a talent for troubleshooting complex situations
• Excellent verbal, written, and interpersonal communication skills

Compensation & Benefits

Compensation & Benefits

PowerSchool offers the following benefits:

• Comprehensive Insurance Coverage (including Medical, Dental, Vision, Pharmacy benefits, Life Insurance and AD&D)
• Flexible Spending Accounts and Health Savings Accounts
• Short-Term Disability and Long-Term Disability
• Comprehensive 401(k) plan
• Generous Parental Leave
• Unrestricted paid time off (known as Discretionary Time Off - DTO)
• Wellness Program, including ClassPass & Employee Assistance Program
• Tuition Reimbursement
• Optional Benefits: Pet Insurance, Identity Theft Protection, Student Debt Repayment Program and Prepaid Legal coverage

A reasonable estimate of the base compensation range for this position is $138,100 - $187,700 USD. This compensation range is specific to the United States and it incorporates many factors including but not limited to an applicant's skills and prior relevant experience and training; licensures, degrees, and certifications; specific geographic location; internal equity; internal pay ranges; and market data/range parameters.

EEO Commitment

EEO Commitment

PowerSchool celebrates 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-SM1 #LI-REMOTE