Senior Application Engineer, Database ETL Programmer
Posted 14hrs ago
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Technical services representative at PowerSchool, a cloud-based K-12 education software provider. Building SQL, database, and ETL integrations for Talent HR, payroll, and workforce systems.
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
Requirements:
- 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
- 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
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


















