Company Description

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 Description

We 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.

Qualifications

• 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

Additional Information

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.