Job details

Senior Solution Architect

Get a free resume review

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

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

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

Average salary estimate

$162900 / YEARLY (est.)

min

max

$138100K

$187700K

If an employer mentions a salary or salary range on their job, we display it as an "Employer Estimate". If a job has no salary data, Rise displays an estimate if available.

What You Should Know About Senior Solution Architect, PowerSchool Group

At PowerSchool, we’re on the lookout for a talented Senior Solution Architect to join our innovative team remotely! In this pivotal role, you'll lead the design and implementation of data solutions tailored for K-12 education systems, a space where your contributions can truly make a difference. We take data integrity seriously, and as a Senior Solution Architect, you'll not only shape our technical frameworks but also mentor and empower fellow staff members on PowerSchool technologies. Imagine a day where you are architecting robust ETL processes, executing precision data modeling, and collaborating with diverse stakeholders to translate analytics goals into actionable data requirements. You're the kind of person who thrives on data quality checks and governs systems effectively while ensuring compliance with data policies. Communication is key for you, and your ability to explain complex concepts in a clear way makes you a natural leader. If you have a strong grasp of SQL, extensive experience in ETL processes, and a passion for enhancing education through technology, we want to hear from you! At PowerSchool, we are committed to personal growth, and our team is dedicated to ensuring that you not only succeed in your role but feel appreciated for your contributions. Join us, and let’s change the educational landscape together.

Frequently Asked Questions (FAQs) for Senior Solution Architect Role at PowerSchool Group

What are the primary responsibilities of a Senior Solution Architect at PowerSchool?

As a Senior Solution Architect at PowerSchool, your key responsibilities include leading the architecture and implementation of ETL processes, designing data models for effective data management, and ensuring data quality throughout projects. You will also mentor team members and facilitate cross-functional collaboration to align data solutions with the educational needs of K-12 clients.