Senior Data & ETL Engineer - SQL & Integrations

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

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,