Senior Data Engineer

Mattel; Hyderabad; On-site; INR 2,600,000 - 4,200,000; Full time

Job summary

Mattel's Technology & Innovation Center in Hyderabad invites a Senior Data Engineer to architect and implement cloud data pipelines. You will collaborate across analytics, product, and IT to deliver trusted datasets and analytics-ready assets using BigQuery, Python, SQL, DBT, and Airflow.

You will mentor junior engineers, enforce data quality, and define best practices for enterprise data strategy while aligning with cross-functional goals and delivery timelines.

Qualifications

• Bachelor’s or Master’s degree in Computer Science, Information Systems, or a related field.
• Minimum 3+ years in data engineering with cloud data warehousing experience.
• Expert in Google BigQuery, Python, SQL, DBT, and Airflow/Cloud Composer.
• Proficient in designing scalable ETL/ELT pipelines and data quality checks.

Responsibilities

• Lead scalable, secure data pipelines ingesting structured data into BigQuery.
• Define modular data models and transformations with DBT for analytics.
• Automate workflows with Airflow and monitor job orchestration.
• Mentor engineers and promote best practices across data teams.

Skills

BigQuery

Python

SQL

DBT

Airflow

Data warehousing

Education

Bachelor’s or Master’s degree in CS/IS

Tools

Ascend.io

Databricks

Fivetran

Dataflow

Job description

Overview

Mattel is a leading global toy and family entertainment company with iconic brands such as Barbie, Hot Wheels, Fisher-Price, American Girl, Thomas & Friends, UNO, Masters of the Universe, Matchbox, Monster High, MEGA, and Polly Pocket. Our offerings include toys, content, consumer products, digital and live experiences sold in collaboration with leading retailers and ecommerce partners. Since 1945, Mattel has partnered to empower generations to explore childhood and reach their full potential.

Mattel’s workplace culture has been recognized by Forbes, Fast Company, Newsweek, Great Place to Work, TIME, and others. Visit us at: https://jobs.mattel.com and www.instagram.com/MattelCareers.

The Opportunity

Mattel is seeking a Senior Data Engineer or Senior ETL Developer, based at 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 design 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.

What We’re Looking For

• 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.
• Experience with Agile methodologies such as Scrum and Kanban, and managing IT backlogs.
• Be a “go-to” expert for data technologies and solutions.