Sign upLog in

Data Integration Lead (with PowerSchool) (Ref: 5746)

Estrada Consulting Incorporated

Sacramento, California(remote)

Apply
JOB DETAILS
SKILLS
Access Control, Application Programming Interface (API), Business Analysis, Business Intelligence, Cloud Computing, Communication Skills, Consulting, Data Management, Data Mapping, Data Processing, Data Quality, Data Sets, Data Warehousing, Data Warehousing Applications, Database Administration, Database Extract Transform and Load (ETL), File Encryption, Government, Identify Issues, Information Technology & Information Systems, Information/Data Security (InfoSec), Interoperability, Operations Processes, Oracle, Oracle Applications, Oracle Database, Privacy Controls, Procedure Development, Project/Program Management, Reconciliation, Regulations, Regulatory Reports, Regulatory Submissions, Reporting Dashboards, SQL (Structured Query Language), Schedule Development, Secure/SSH File Transfer Protocol (SFTP), Security Compliance, Software Development, System Integration (SI), Technical Delivery, Technical Writing
LOCATION
Sacramento, California(remote)
POSTED
1 day ago
Data Integration Lead (Ref: 5746)

Location: Remote within the US preferred East Coast
Term: 9-12 months
 
Position Summary
The Data Integration Lead will design, develop, and support secure data integrations between PowerSchool, Oracle, and other education data systems. This role will be responsible for creating reliable data pipelines, mapping and transforming source data, validating data quality, and preparing datasets for public reporting.

The ideal candidate has hands-on experience integrating PowerSchool and Oracle data using secure APIs, SFTP transfers, and automated or scheduled data-processing workflows.

Key Responsibilities:
  • Lead the technical integration of data feeds from PowerSchool and Oracle.
  • Design and maintain secure API- and SFTP-based integrations.
  • Develop automated and scheduled data pipelines for recurring data exchanges.
  • Perform source-to-target data mapping, transformation, cleansing, and validation.
  • Monitor data pipelines and troubleshoot integration, processing, and data-quality issues.
  • Establish validation procedures to ensure data is complete, accurate, and consistent.
  • Support education data standards such as Ed-Fi, OneRoster, or similar interoperability frameworks.
  • Prepare and validate datasets used for public reporting, regulatory submissions, dashboards, and analytics.
  • Document integration requirements, data mappings, business rules, technical specifications, and operating procedures.
  • Coordinate with business analysts, database administrators, application teams, reporting teams, and client stakeholders.
  • Ensure integrations comply with applicable security, privacy, and student-data protection requirements.

Required Qualifications:
  • Experience integrating data from PowerSchool and Oracle systems.
  • Experience developing secure API and SFTP integrations.
  • Experience designing automated or scheduled data pipelines.
  • Strong experience with data mapping, transformation, validation, and reconciliation.
  • Knowledge of Ed-Fi, OneRoster, or comparable education data standards.
  • Experience preparing datasets for public, regulatory, or operational reporting.
  • Ability to identify and resolve data-quality and integration issues.
  • Strong technical documentation and stakeholder communication skills.

Additional Qualifications:
  • Experience working with K–12 school districts or public education agencies.
  • Experience with student information systems, data warehouses, reporting platforms, or education analytics environments.
  • Knowledge of student-data privacy, access controls, encryption, and secure file-transfer practices.
  • Experience supporting Oracle databases, SQL, ETL/ELT tools, and cloud-based integration services.


About Estrada Consulting Incorporated:

Estrada Consulting, Inc. (ECI) delivers technology-enabled services and solutions to clients all over the USA and British Columbia. We provide system integration, custom application development, data warehouse and business intelligence, project management, custom reporting solutions and consulting services to mid-size and large enterprises in all major industries. The Company headquarters is in Sacramento, California, and was established in year 2000. Visit http://www.estradaci.com/ to learn about our projects, managed services, awards and certifications delivering value for a range of businesses and government agencies.

About the Company

E

Estrada Consulting Incorporated

Estrada Consulting, Inc. is a delivering technology-enabled services and solutions to clients throughout the USA. We provide system integration, custom application development, project management, custom reporting solutions and consulting services to mid-size and large enterprises in all major industries. The Company headquarters in Sacramento, California, was established in year 2000. ECI also holds an active  CMAS and MSA for State of CA. ECI is continually searching for highly skilled consultants with public sector project experiences in Project Management / PMP, Solutions and Enterprise Architecture, IT Systems Analysts, Business Analysts and Agile Scrum. Please reach out to jacquelinep@estradaci.com

COMPANY SIZE
20 to 49 employees
INDUSTRY
Computer/IT Services
FOUNDED
2000
WEBSITE
http://www.estradaci.com

Resume Resources

Free Resume TemplatesFree Resume Builder