Senior Software Engineer 1 and Data Engineering Specialist

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 cloudbased software for K12 education. Our employees make it all possible and a career with us means youre joining a successful team committed to engaging empowering and improving the K12 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 awardwinning K12 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.

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.

Minimum Qualifications

• Bachelors 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 fastpaced environment.

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