Mattel is a leading global toy and family entertainment company and owner of one of the most iconic brand portfolios in the world. We engage consumers and fans through our franchise brands, including Barbie, Hot Wheels, Fisher-Price, American Girl, Thomas & Friends, UNO, Masters of the Universe, Matchbox, Monster High, MEGA and Polly Pocket, as well as other popular properties that we own or license in partnership with global entertainment companies. Our offerings include toys, content, consumer products, digital and live experiences. Our products are sold 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 generations to explore the wonder of childhood and reach their full potential.
Mattel’s award-winning workplace culture has been recognized by Forbes, Fast Company, Newsweek, Great Place to Work, TIME, and more.
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.
- Bachelor’s or Master’s degree in Computer Science, Data Engineering, Information Systems, or related technical field.
- Minimum 3+ 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.
Skills Required
- Bachelor's or Master's degree in Computer Science, Data Engineering, Information Systems, or a related technical field
- Minimum 3+ years of hands-on data engineering experience
- Strong expertise in data warehousing, pipeline development, and cloud analytics
- Expert-level experience with Google BigQuery
- Expert-level experience with Python
- Expert-level experience with SQL
- Expert-level experience with DBT
- Expert-level experience with Airflow or Cloud Composer
- Experience building enterprise-grade ETL/ELT pipelines and scalable data architectures
- Understanding of data quality frameworks, validation techniques, and governance processes
- Proficiency in Agile methodologies including Scrum or Kanban and IT backlog management
- Experience with Ascend.io, Databricks, Fivetran, or Dataflow
- Experience with data cataloging or governance tools such as Collibra
- Experience with CI/CD tools, Git workflows, and infrastructure automation
- Experience with real-time or event-driven data processing using Pub/Sub, Kafka, or similar platforms
- Strategic problem-solving and solution architecture skills
- Ability to adapt to new technologies and lead adoption across teams
- Excellent communication and cross-functional influencing skills
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.
-
Retirement Support — Retirement benefits include automatic company contributions in addition to matching, with auto-enrollment and automatic increases that support long-term savings. Features like age-based company contributions and loan availability reinforce the program’s strength.
-
Parental & Family Support — Family support is emphasized through paid parental leave and access to fertility and family-building resources, complemented by on-site childcare at select campuses. Recent program additions broaden support for parents and caregivers across locations.
-
Leave & Time Off Breadth — Many salaried roles receive flexible or unlimited PTO alongside holiday programs and hybrid/flexible scheduling. This breadth of time-off options provides greater flexibility compared with traditional accrual systems.
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.
