GCP Data Engineer

Mattel; Telangana; On-site; INR 1,400,000 - 2,100,000; Full time

Job summary

Mattel is seeking a GCP Data Engineer to join our Technology & Innovation Center in Hyderabad, India. You will lead the design and development of scalable cloud-based data pipelines using BigQuery, Python, SQL, DBT and Airflow.

You will drive 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

Qualifications

• Experience designing scalable cloud-based data pipelines.
• Proficiency with BigQuery, DBT, Python and SQL.
• Mentor junior engineers and lead code reviews.

Responsibilities

• Lead design and development of scalable data pipelines in Google Cloud.
• Ingest data from ERP/CRM/E-commerce into centralized data warehouse (BigQuery).
• Build analytics-ready pipelines for reporting and dashboards.
• Implement transformation logic and reusable data models with DBT.
• Apply BigQuery partitioning, clustering and query optimization.
• Automate and monitor data workflows with Airflow/Cloud Composer.
• Develop Python and SQL code for ingestion, transformation and validation.
• Establish data quality checks and testing aligned with business logic.
• Collaborate with architects and tech leads to establish best practices.
• Partner with data analysts, BI developers and product owners to deliver data solutions.
• Utilize Ascend.io, Databricks, Dataflow or Fivetran to accelerate development.
• Contribute to CI/CD docs and monitoring processes.
• Mentor junior engineers and conduct peer reviews.

Skills

BigQuery

Python

SQL

DBT

Airflow

Data pipelines

Data modeling

ETL pipelines

Collaboration

Education

Bachelor's or Master's in CS / Data Engineering / IS

Tools

Ascend.io

Databricks

Dataflow

Fivetran

Job 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 fans, entertain audiences 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.

Mattel is seeking a GCP Data Engineer, 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.