ResponsibilitiesRole OverviewWe are hiring a Software Engineer to help build a new multi-tenant, cloud-native reporting and data platform, replacing the legacy single-tenant reporting system. This role is hands-on and highly technical, focusing on development, automation, and the use of AI to migrate and refactor business logic and report configurations.
Key Responsibilities- Build AWS serverless components using Lambda, Step Functions, API Gateway and related services.
- Develop backend services and components using Python, TypeScript, and SQL.
- Write and optimize SQL for data access and reporting workloads; Snowflake experience is a plus.
- Implement AI-driven solutions to extract business logic from legacy code, generate new report parameter screens and metadata, and perform logic validation.
- Collaborate closely with Senior and Lead Engineers on architecture, design, and implementation plans.
- Participate in code reviews, testing, debugging, monitoring, and performance optimization.
- Maintain high engineering standards, documentation quality, and best practices.
QualificationsRequired Skills & Experience- Solid hands-on experience with AWS serverless technologies.
- Proficiency in Python and TypeScript for backend development.
- Strong understanding of SQL and relational/dimensional modeling basics.
- Demonstrated AI engineering experience, such as LLM integration, embeddings, or AI-driven code workflows.
- Experience building APIs, event-driven components, or distributed backend systems.
- Strong debugging skills and ability to follow complex logic patterns.
- Ability to collaborate in an engineering team environment and work with minimal supervision.
Preferred Qualifications- Experience with Snowflake or other cloud data warehouses.
- Exposure to ETL/ELT patterns or data pipeline tools.
- Experience with automated testing frameworks and CI/CD workflows.
- Familiarity with domain-driven design or multi-tenant system principles.
- Strong communication and collaborative engineering habits.
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 $56,100 - $111,800 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.
