Sr. Application Engineer, Database ETL Programmer

PowerSchool; Dallas (TX); On-site; USD 75,000 - 121,000; Full time

Benefits offered by this job

Medical, dental, vision

401(k) plan

Parental leave

DTO - Discretionary Time Off

Wellness program

Tuition reimbursement

Pet Insurance

Job summary

PowerSchool is seeking a senior data integration specialist for the Talent/Professional Learning Services Team. You will implement, customize, and optimize HR-related data flows across PowerSchool Talent and third-party systems.

Strong SQL, ETL, and scripting skills are essential to translate customer requirements into scalable solutions. You will gather requirements, design data integrations, build ETL processes, and support payroll/workforce data moves while collaborating with Product,

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.

Responsibilities

• 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

Skills

SQL

ETL

Data integration

Python

PowerShell

Java

Education

Bachelor's degree or equivalent

Tools

Pentaho ETL

Salesforce

Job description

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.

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:

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:

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 [e-mail].