Responsibilities- Role Overview
We are launching a major modernization effort to transform our legacy single-tenant reporting framework into a multi-tenant, cloud-native, AI-augmented reporting and analytics platform. This role will serve as the technical lead for the initiative, responsible for architecture, design leadership, and hands-on development. The Lead Engineer will drive technical direction, guide the engineering team, and help define how AI is leveraged to migrate business logic and report metadata from the current system to the new platform.
Key Responsibilities
- Lead architecture and design for a new multi-tenant reporting platform built on AWS serverless technologies.
- Provide hands-on development using Python, TypeScript, SQL, and AWS services including Lambda, Step Functions, API Gateway and others.
- Develop AI-driven pipelines that extract, translate, and validate business logic and report parameter screens from the legacy platform.
- Define coding standards, best practices, and development patterns across the engineering team.
- Mentor senior and mid-level engineers; conduct design and code reviews.
- Partner with Product, Data, QA, and Architecture teams to align technical and business requirements.
- Evaluate and recommend emerging AI technologies and frameworks to optimize automation capabilities.
- Ensure platform scalability, security, tenant isolation, and operational excellence.
QualificationsRequired Skills & Experience- Extensive experience with AWS serverless architectures.
- Expert-level proficiency in Python and TypeScript.
- Prior experience with AI for code generation, metadata extraction, or workflow automation
- Strong SQL background; Snowflake experience is a plus.
- Demonstrated experience building or integrating AI-driven systems (LLMs, embeddings, AI agents, transformation pipelines).
- Solid experience with distributed systems, data pipelines, or modernizing legacy platforms.
- Proven leadership in technical strategy and mentoring.
Preferred Qualifications- Experience designing or operating multi-tenant platforms.
- Strong knowledge of ETL/ELT architecture patterns.
- Strong documentation, communication, and stakeholder-management skills.
Compensation & BenefitsCompensation & BenefitsPowerSchool 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 $92,800 - $170,300 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; internal equity; internal pay ranges; and market data/range parameters.
