CREATIVITY IS OUR SUPERPOWER. It’s our heritage and it’s also our future. Because we don’t just make toys. We create innovative products and experiences that inspire, entertain and develop children through play. Mattel is at its best when every member of our team feels respected, included, and heard—when everyone can show up as themselves and do their best work every day. We value and share an infinite range of ideas and voices that evolve and broaden our perspectives with a reach that extends into all our brands, partners, and suppliers.
Job DescriptionWe are seeking a Data Engineer with strong Anaplan and enterprise data integration experience to design, build, and maintain scalable data solutions supporting connected planning, analytics, and business decision-making.
This role will be responsible for integrating data from multiple enterprise systems into Anaplan, improving data quality and automation, and partnering with business and technical teams to deliver reliable planning solutions. The ideal candidate combines hands-on data engineering expertise with a strong understanding of Anaplan architecture, model data flows, and planning processes.
Key Responsibilities
- Design, build, and maintain automated data pipelines between Anaplan and enterprise source systems.
- Develop integrations using Anaplan CloudWorks, Anaplan Connect, REST APIs, ETL or ELT platforms, and cloud data services.
- Extract, transform, validate, and load data from systems such as ERP, CRM, HRIS, data warehouses, data lakes, and flat-file sources.
- Partner with Anaplan model builders and solution architects to define efficient data structures, import processes, mappings, and integration patterns.
- Create and maintain data transformation logic, staging layers, reconciliation processes, and exception-handling workflows.
- Monitor data pipelines and resolve integration failures, data-quality issues, and performance bottlenecks.
- Develop reusable integration components, technical standards, and automation frameworks.
- Support Anaplan model lifecycle activities, including data refreshes, production deployments, model copies, and environment management.
- Ensure data integrations comply with security, access-control, audit, and governance requirements.
- Document data flows, source-to-target mappings, technical designs, operating procedures, and support processes.
- Collaborate with finance, supply chain, sales, workforce planning, and other business teams to understand data requirements.
- Perform root-cause analysis and implement long-term solutions for recurring data and integration issues.
- Support testing activities, including unit testing, integration testing, reconciliation, and user acceptance testing.
- Identify opportunities to simplify processes, reduce manual effort, and improve the reliability of planning data.
- Provide operational support for business-critical Anaplan integrations and scheduled data processes.
- Bachelor’s degree in Computer Science, Information Systems, Engineering, Data Analytics, or a related field.
- Three or more years of experience in data engineering, data integration, business intelligence, or enterprise application integration.
- Hands-on experience working with Anaplan data integrations and model data processes.
- Experience with Anaplan CloudWorks, Anaplan Connect, APIs, or similar integration technologies.
- Strong SQL skills and experience working with relational databases, data warehouses, or cloud data platforms.
- Experience building ETL or ELT pipelines using tools such as Informatica, Boomi, MuleSoft, SnapLogic, Azure Data Factory, AWS Glue, Matillion, Talend, dbt, or similar platforms.
- Experience working with structured data formats such as CSV, JSON, XML, and API payloads.
- Strong understanding of data mapping, transformation, validation, reconciliation, and error handling.
- Ability to troubleshoot data discrepancies and integration failures across multiple systems.
- Experience with version control, deployment processes, and development lifecycle practices.
- Strong analytical, problem-solving, documentation, and communication skills.
- Ability to work effectively with both technical teams and business stakeholders.
Preferred Qualifications
- Anaplan Level 1, Level 2, Model Builder, Solution Architect, or related certification.
- Experience with Anaplan Data Orchestrator.
- Experience developing or supporting Anaplan models.
- Familiarity with Anaplan Application Lifecycle Management and production deployment practices.
- Experience with cloud platforms such as Microsoft Azure, Amazon Web Services, Google Cloud Platform, or Snowflake.
- Programming or scripting experience with Python, PowerShell, Shell scripting, Java, or similar languages.
- Experience with enterprise planning processes such as financial planning, sales planning, workforce planning, demand planning, or supply chain planning.
- Knowledge of data governance, metadata management, master data management, and data-security practices.
- Experience working in Agile or Scrum delivery environments.
- Familiarity with monitoring, logging, alerting, and workload-scheduling tools.
Technical Skills
- Anaplan CloudWorks
- Anaplan Connect
- Anaplan REST APIs
- Anaplan Data Orchestrator
- SQL
- ETL and ELT development
- Data warehouses and data lakes
- Cloud integration platforms
- Python or scripting
- API integration
- Data mapping and transformation
- Data-quality controls
- Job scheduling and monitoring
- Source control and deployment automation
Core Competencies
- Data engineering and integration design
- Anaplan architecture awareness
- Technical troubleshooting
- Data-quality management
- Process automation
- Stakeholder collaboration
- Solution documentation
- Attention to detail
- Ownership and accountability
- Continuous improvement
Success Measures
Success in this role will be measured by:
- Reliability and timeliness of Anaplan data integrations.
- Reduction in manual data preparation and upload activities.
- Accuracy and completeness of planning data.
- Speed of issue resolution and reduction in recurring failures.
- Performance and scalability of data pipelines.
- Adoption of reusable integration standards and automation.
- Stakeholder satisfaction with data availability and quality.
Reporting Relationship
This role will typically report to the Data Engineering Manager, Enterprise Applications Manager, Anaplan Product Owner, or Director of Business Systems and will work closely with Anaplan architects, model builders, data platform teams, and business process owners.
Skills Required
- Bachelor's degree in Computer Science, Information Systems, Engineering, Data Analytics, or a related field
- Three or more years of experience in data engineering, data integration, business intelligence, or enterprise application integration
- Hands-on experience with Anaplan data integrations and model data processes
- Experience with Anaplan CloudWorks, Anaplan Connect, APIs, or similar integration technologies
- Strong SQL skills and experience with relational databases, data warehouses, or cloud data platforms
- Experience building ETL or ELT pipelines
- Experience with structured data formats including CSV, JSON, XML, and API payloads
- Understanding of data mapping, transformation, validation, reconciliation, and error handling
- Ability to troubleshoot data discrepancies and integration failures across multiple systems
- Experience with version control, deployment processes, and development lifecycle practices
- Strong analytical, problem-solving, documentation, and communication skills
- Ability to work effectively with technical teams and business stakeholders
- Anaplan certification such as Level 1, Level 2, Model Builder, or Solution Architect
- Experience with Anaplan Data Orchestrator
- Experience developing or supporting Anaplan models
- Familiarity with Anaplan Application Lifecycle Management and production deployment practices
- Experience with cloud platforms such as Microsoft Azure, Amazon Web Services, Google Cloud Platform, or Snowflake
- Programming or scripting experience with Python, PowerShell, Shell scripting, Java, or similar languages
- Experience with financial, sales, workforce, demand, or supply chain planning processes
- Knowledge of data governance, metadata management, master data management, and data-security practices
- Experience working in Agile or Scrum delivery environments
- Familiarity with monitoring, logging, alerting, and workload-scheduling tools
Mattel Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Mattel and has not been reviewed or approved by Mattel.
-
Leave & Time Off Breadth — Leave & Time Off Breadth: Unlimited paid time off for many salaried roles, generous holiday schedules, and flexibility programs are highlighted across company materials. Practices like half‑day Fridays or end‑of‑year breaks appear in some areas, though specifics vary by team and location.
-
Healthcare Strength — Healthcare Strength: Comprehensive medical, dental, vision, and disability coverage is paired with an Employee Assistance Program, mindfulness tools, and on‑site fitness centers at key locations. Recent updates add a company‑paid at‑home cancer‑screening program for those enrolled in medical plans.
-
Parental & Family Support — Parental & Family Support: Paid leave for new parents, phase‑back‑to‑work options, and global fertility and family‑building resources are emphasized. Select campuses offer on‑site childcare, and adoption assistance and caregiver support are included.
Mattel Insights
What We Do
We are a purpose driven company with a mission to create innovative products and experiences that inspire, entertain, and develop children through play. We treat play as if the future depends on it — because it does. Play is our language, and we speak to our consumers authentically by representing the world as they see and imagine it. Mattel is a leading global toy company and owner of one of the strongest catalogs of children’s and family entertainment franchises in the world. We engage consumers through our portfolio of iconic brands, including Barbie, Hot Wheels, Fisher-Price, American Girl, Thomas & Friends, UNO, Masters of the Universe, Monster High and MEGA, as well as other popular intellectual properties that we own or license in partnership with global entertainment companies. Our offerings include film and television content, gaming and digital experiences, music, and live events. We operate in more than 35 locations and our products are sold in more than 150 countries in collaboration with the world’s leading retail and ecommerce companies. Mattel is recognized for the second year in a row as a Great Place to Work™ and as one of Fast Company’s Best Workplaces for Innovators in 2022.
.jpeg)
