Senior Data Engineer

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

The Team

As part of the Global Technology Organization, the Enterprise Data and Analytics (ED&A) Delivery Team is focused on enabling Mattel to become a data-driven organization, supported by a shared services platform that serves all business units:

• Integration data from diverse enterprise systems such as ERP, ECOM, Order Management systems, CRM and operational platform into a centralized cloud-based data warehouse.
• Building robust ETL/ELT pipelines that automate data ingestion, transformation, and delivery using modern tools and frameworks.
• Delivering curated, business-ready datasets that support self-service analytics and strategic decision-making.
• Enforcing data quality, testing, and governance standards across the enterprise.
• Leveraging orchestration tools such as Airflow/Cloud Composer to ensure reliable and efficient pipeline scheduling and execution.
• Partnering with cross-functional teams including data analysts, product owners, and BI developers to align data solutions with business needs.

The Opportunity

Mattel is seeking a Senior Data Engineer or Senior ETL Developer, based out of our Technology & Innovation Center in Hyderabad, India, reporting to the IT Director for Enterprise Data and Analytics.

This role will lead the design and development of scalable cloud-based data pipelines using tools like BigQuery, Python, SQL, DBT, and Airflow. You will drive detailed designs decisions, ensure data quality, and collaborate with cross-functional teams to deliver trusted, analytics-ready datasets. This role also includes mentoring junior engineers and setting engineering best practices to support Mattel’s enterprise data strategy.

What Your Impact Will Be:

• Lead the development of scalable, secure, and high-performing data integration pipelines for structured and semi-structured data using Google BigQuery.
• Design and develop scalable data integration pipelines to ingest structured and semi-structured data from enterprise systems (e.g., ERP, CRM, E-commerce, Order Management) into a centralized cloud data warehouse using Google BigQuery.
• Build analytics-ready pipelines that transform raw data into trusted, curated datasets for reporting, dashboards, and advanced analytics.
• Implement transformation logic using DBT to create modular, maintainable, and reusable data models that evolve with business needs.
• Apply BigQuery best practices—including partitioning, clustering, and query optimization—to ensure high performance and scalability.
• Automate and monitor complex data workflows using Airflow/Cloud Composer, ensuring dependable pipeline orchestration and job execution.
• Develop efficient, reusable Python and SQL code for data ingestion, transformation, validation, and performance tuning across the pipeline lifecycle.
• Establish robust data quality checks and testing strategies to validate both technical accuracy and alignment with business logic.
• Partner with architects and Technical leads to establish best practices, scalable frameworks, and reference implementations across projects.
• Collaborate with cross-functional teams—including data analysts, BI developers, and product owners—to understand integration needs and deliver impactful, business-aligned data solutions.
• Leverage modern ETL platforms such as Ascend.io, Databricks, Dataflow, or Fivetran to accelerate development and improve observability and orchestration.
• Contribute to technical documentation, CI/CD workflows, and monitoring processes to drive transparency, reliability, and continuous improvement across the data engineering ecosystem.
• Mentor junior engineers, conduct peer code reviews, and lead technical discussions.

Qualifications

What We’re Looking For:

• Bachelor’s or Master’s degree in Computer Science, Data Engineering, Information Systems, or related technical field.
• Minimum 6+ years of hands-on experience in data engineering with strong expertise in data warehousing, pipeline development, and analytics on cloud platforms.
• Expert-level experience in:
  • Google BigQuery for large-scale data warehousing and analytics.
  • Python for data processing, orchestration, and scripting.
  • SQL for data wrangling, transformation, and query optimization.
  • DBT for developing modular and maintainable data transformation layers.
  • Airflow / Cloud Composer for workflow orchestration and scheduling.
• Proven experience building enterprise-grade ETL/ELT pipelines and scalable data architectures.
• Strong understanding of data quality frameworks, validation techniques, and governance processes.
• Proficiency in Agile methodologies (Scrum/Kanban) and managing IT backlogs in a collaborative, iterative environment.
• Preferred experience with:
  • Tools like Ascend.io, Databricks, Fivetran, or Dataflow.
  • Data cataloging/governance tools (e.g., Collibra).
  • CI/CD tools, Git workflows, and infrastructure automation.
  • Real-time/event-driven data processing using Pub/Sub, Kafka, or similar platforms.
• Strategic problem-solving skills and ability to architect innovative solutions.
• Ability to adapt quickly to new technologies and lead adoption across teams.
• Excellent communication skills and ability to influence cross-functional teams.
• Good experience on Agile Methodologies like Scrum, Kanban, and managing IT backlog.
• Be a “go-to” expert for data technologies and solutions

Additional Information

What It’s Like to Work Here

We are a purpose driven company aiming to empower the next generation to explore the wonder of childhood and reach their full potential. We live up to our purpose employing the following behaviors:

• We collaborate: Being a part of Mattel means being part of one team with shared values and common goals. Every person counts and working closely together always brings better results. Partnership is our process and our collective capabilities is our superpower.
• We innovate: At Mattel we always aim to find new and better ways to create innovative products and experiences. No matter where you work in the organization, you can always make a difference and have real impact. We welcome new ideas and value new initiatives that challenge conventional thinking.
• We execute: We are a performance driven company. We strive for excellence and are focused on pursuing best in class outcomes. We believe in accountability and ownership and know that our people are at their best when they are empowered to create and deliver results.
   

Who We Are

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 create innovative products and experiences that inspire, entertain and develop children through play. We engage consumers through our portfolio of iconic brands, including Barbie, Hot Wheels, Fisher-Price, American Girl, Thomas & Friends, UNO 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, music and live events. We operate in 35 locations and our products are available in more than 150 countries in collaboration with the world’s leading retail and ecommerce companies. Since its founding in 1945, Mattel is proud to be a trusted partner in empowering children to explore the wonder of childhood and reach their full potential.

Visit us at https://jobs.mattel.com/ and www.instagram.com/MattelCareers.

Mattel is an Equal Opportunity Employer where we want you to bring your authentic self to work every day. We welcome all job seekers including minorities, females, individuals with disabilities, and those of all sexual orientations and gender identities.