Sr. Application Engineer, Database ETL Programmer
Overview:
About PowerSchool
At PowerSchool, we power education for students around the world. As the global leader in cloud-based K-12 software, we support the full education ecosystem—from the central office to the classroom to the home. Joining PowerSchool means being part of a mission-driven team that is transforming K-12 education by helping schools operate more effectively and deliver better outcomes for educators, students, and families.
Team Overview
The Services team works closely together to set PowerSchool customers up for ongoing success through post-implementation support, troubleshooting, consultation on system setup options, and training on features and functionality. The team offers cross-portfolio support, all while meeting organizational objectives for revenue, utilization, and customer satisfaction.
Responsibilities:
Description
The Talent/Professional Learning Services Team partners with K-12 school districts to implement, customize, integrate, and optimize Human Resource applications within the PowerSchool Talent portfolio. This role combines technical consulting, database development, SQL programming, and data integration to help customers solve complex business challenges. The ideal candidate will work directly with clients to gather requirements, develop custom solutions, build data integrations, and support the movement of workforce and payroll data between PowerSchool applications and third-party systems. The role requires strong database, SQL, ETL, and scripting experience, along with the ability to translate customer requirements into scalable technical solutions.
Your day-to-day responsibilities will include:
Meet with customers to define and document business requirements
Create custom data integration solutions between Talent HR applications and third-party payroll, HRIS, and ERP systems
Design, develop, and support ETL processes for customer payroll and workforce data integrations
Develop custom SQL and scripting solutions to support customer requirements and integrations
Work collaboratively with clients, team members, Product Development, Engineering, Sales, Technical Support, and the Project Management Organization
Serve as a technical advisor for database, integration, and data migration solutions
Troubleshoot and support customer database solutions, integrations, and data migrations
Qualifications:
Minimum Qualifications
Minimum of 8+ years of relevant and related work experience
Bachelor’s degree or equivalent, or equivalent years of relevant work experience
Database experience supporting customer solutions
Programming experience developing custom scripts and integrations
ETL experience supporting payroll data integrations
SQL programming experience supporting customer database integrations
Preferred Qualifications
SQL/MySQL scripting experience
Ability to lead requirements-gathering sessions and present solutions
Ability to program/analyze scripts (Python, Java, Batch, and PowerShell)
Pentaho ETL experience
Customer-facing / consulting experience
Experience supporting HRIS, ERP, or payroll system integrations
Strong organizational skills
Effective written communication skills
Salesforce knowledge
Compensation & Benefits:
Compensation & Benefits
PowerSchool 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 $75,100 - $120,600 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.
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.