Software Engineer 1 (SQL & PL/SQL Developer) Full Time NEW

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.

About The Team

The Compliance Cloud team builds and maintains PSCC, a K–12 compliance platform on AWS that enables school districts to meet state and federal reporting requirements, exchange transcripts, and generate secondary reports across multiple U.S. states.

Responsibilities

Role Summary

• Design, develop, and maintain cloud-based services supporting compliance reporting, transcript exchange, and secondary reporting.

Key Responsibilities

• State & Federal Reporting: Build survey submission workflows, validation rule engines, Step Function orchestrations, and SQS-based async processing.
• Student Transcript Exchange: Develop transcript request/response systems, SFTP integrations (e.g., Florida FASTER), Section 508-compliant PDF generation, format validation, and lifecycle tracking.
• Secondary Reporting: Create scheduled report pipelines, configuration, execution logging, and file outputs.
• Data Engineering: Maintain DBT models in Snowflake, optimize queries, and manage DynamoDB metadata and status tracking.
• Infrastructure & DevOps: Use AWS CDK (TypeScript) to manage Lambda, API Gateway, S3, DynamoDB, SQS, Step Functions, EventBridge, and CloudFront; support Yarn/Nx monorepo builds, GitLab CI/CD, and LaunchDarkly feature flags.
• Frontend: Build accessible React/TypeScript UIs with SCSS and Webpack for dashboards, surveys, transcripts, and reporting

Qualifications

Minimum Qualifications

• 3+ years of experience in SQL and PL/SQL.
• Use of AI code editor like Cursor, Github Copilot
• Experience working with Database like Oracle preferably or other RDBMS.
• Experience using tools as SQL Developer, Jira and Git.
• Problem solving and debugging skills
• Understanding of the Software Development Life Cycle(SDLC)
• Experience working in Agile/Scrum Teams.
• Ability to guide and mentor junior team members.
• Good written and verbal communication skills
• Desire to learn, grow, and improve
• A passion and natural curiosity for technology

Preferred Qualifications

• Good Experience in client-side JavaScript or Typescript and related framework and libraries such as Angular and Jquery.
• Good to have experience in Object oriented programming in Java or Typescript.
• Good to have knowledge of Spring MVC, Hibernate, Webservices

EEO Commitment

EEO Commitment

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.