Senior Software Engineer 1 and Data Engineering Specialist

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

Our Research & Development (R&D) team is the technical talent at the heart of our product suite, overseeing the product development lifecycle from concept to delivery. From engineering to quality assurance to data science, the R&D team ensures our customers seamlessly use our products and can depend on their consistency.

This position, under the general direction of Engineering leadership, will be responsible for technical and development support for our award-winning K-12 software. This role will use their knowledge to implement, code, build, and test new features, maintain existing features, and develop reports that will include components, data models, customization, and reporting features for our products. This position will gather and refine requirements, develop designs, implement, test and document solutions to produce the highest quality product and customer satisfaction.

Responsibilities

Description

• Essential duties and responsibilities include the following. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions:
• Implement data replication and data ingestion software features and products following best practices such as authoring of unit tests, writing maintainable code, applying established patterns and algorithms.
• Specialize in data engineering as a member of a project team.
• Design and development of software engineering strategies.
• Design and implement ETL processes to extract, transform, and load data from diverse sources.
• Develop and optimize SQL queries for data extraction and transformation.
• Perform data profiling, cleansing, and validation to ensure data accuracy and integrity.
• Troubleshoot and resolve issues related to data integration processes.
• Create and maintain documentation for ETL processes, data mappings, and transformations.
• Stay abreast of industry best practices and emerging technologies in ETL and data integration.
• Investigate and resolve issues following best practices such as authoring or updating unit tests, writing maintainable code, applying established patterns and algorithms.
• Analyze performance and develop improvements to performance.
• Assist and analyze security best practices.
• Develop software to support internal initiatives, tools, update framework and application functionality.
• Work as part of an Agile SCRUM team in the planning, scoping, estimation, and execution of technical solutions.
• Other duties as assigned.

Qualifications

Minimum Qualifications

• Bachelor's degree in Computer Science or Information Technologies required, or equivalent experience:
• 5+ years' experience in software engineer role.
• Strong experience with Snowflake and various database (MySQL, MSSQL, etc.) platforms.
• Strong experience in TSQL and writing SQL transformations.
• Strong experience in building data engineering pipelines using Python.
• Experience with any replication technologies like SQL Replication, Fivetran, Qlik Replicate.
• Understanding of data governance.
• Experience in building CI/CD pipelines.
• Excellent written and verbal communication skills.
• Excellent ability to work with current software design principles and concepts such as patterns, algorithms.
• Ability to handle a heavy workload while working on multiple projects and frequent interruptions.
• Ability to work in a changing, dynamic environment.
• Ability to provide an accurate and reliable estimate.
• Willingness to work in a fast-paced environment.

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.