Lead Data Engineer (OIC+Python)
Core
Design, build, and optimize scalable, high-performance data platforms using Oracle Integration Cloud (OIC) and Google Cloud Platform (GCP) to deliver reliable, secure, and analytics-ready data solutions.
Role type
Lead Data Engineer (OIC+Python)
Builds
Data integrations, APIs, and data pipelines for Mattel's business and technical teams.
Domain
Retail/Toys industry + Cloud Data Engineering
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Oracle Integration Cloud (OIC), Google Cloud Platform (GCP), ETL/ELT frameworks, SQL, Python, Data Modeling, Google BigQuery, Oracle 23ai, Apache Airflow, GCP Cloud Composer, OCP Scheduler, Oracle Database (SQL, PL/SQL), Oracle ERP modules
Preferred skills
Oracle certifications, DevOps practices, Git, CI/CD pipelines, DBT, OpenAI prompt engineering, Machine Learning/LLM concepts
Technologies
OIC, GCP, BigQuery, Oracle 23ai, Airflow, Cloud Composer, Git, DBT
Responsibilities
Design and build integrations using OIC's visual interface; Create, manage, and optimize APIs; Monitor integration performance and resolve technical issues; Collaborate with business analysts and architects to translate requirements into technical specifications; Maintain comprehensive documentation of integration designs and workflows; Implement data validation, cleansing, and quality controls.
Seniority
Senior, hands-on IC with leadership responsibilities