EAI Software Engineer

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.

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 Data Engineer or ETL Developer, based out of our Technology & Innovation Center in Hyderabad, India, reporting to the IT Director for Enterprise Data and Analytics. The person in this role will be responsible for designing, developing, and maintaining scalable data integration and analytics pipelines to support enterprise reporting and data-driven decision-making. This role requires close collaboration with cross-functional teams to integrate data from various source systems into a centralized, cloud-based data warehouse—primarily leveraging tools such as Google Big Query, Python, SQL, DBT, and Cloud Composer (Airflow). The Data Engineer will also be responsible for implementing data quality checks, managing orchestration workflows, and delivering business-ready datasets aligned with Mattel’s enterprise data strategy.

What Your Impact Will Be:

• 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 data workflows using Cloud Composer (Airflow), ensuring reliable execution, task dependency management, and timely data delivery.
• 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.
• 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.

What We’re Looking For: 

• Bachelor's or master's degree in computer science, Data Engineering, Information Systems, or related technical field.
• 4+ years of hands-on experience in data engineering with a focus on data integrations, warehousing, and analytics pipelines.
• Hands-on experience with:
  • Google Big Query as a centralized data warehousing and analytics platform.
  • Python for scripting, data processing, and integration logic.
  • SQL for data transformation, complex querying, and performance tuning.
  • DBT for building modular, maintainable, and reusable transformation models.
  • Airflow / Cloud Composer for orchestration, dependency management, and job scheduling.
• Solid understanding of ETL/ELT pipeline development and cloud-based data architecture.
• Strong knowledge of data quality frameworks, validation methods, and governance best practices.
• Preferred Skills (Optional):
  • Experience with Ascend.io or comparable ETL platforms such as Databricks, Dataflow, or Fivetran.
  • Familiarity with data cataloging and governance tools like Collibra.
  • Knowledge of CI/CD practices, Git-based workflows, and infrastructure automation tools.
  • Exposure to event-driven or real-time streaming pipelines using tools like Pub/Sub or Kafka.
• Strong problem-solving and analytical mindset with the ability to think broadly and identify innovative solutions and able to quick to learn new technologies, programming languages, and frameworks.
• Excellent communication skills, both written and verbal.
• Ability to work in a fast-paced and collaborative environment.
• Ability to provide on ground troubleshooting and diagnosis to architecture and design challenges
• Good experience in Agile Methodologies like Scrum, Kanban, and managing IT backlogs.
• Be a “go-to” expert for data technologies and solutions

Don’t meet every single requirement? At Mattel, we are dedicated to an inclusive workplace and a culture of belonging. If you’re excited about this role but your past experience doesn’t align perfectly with every qualification in the job description, we still encourage you to apply. You may be just the right candidate for this or other roles.

How We Work:
We are a purpose driven company aiming to empower generations 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.

Our Approach to Flexible Work:
We embrace a flexible work model designed to empower a culture of growth, optimism, and wellbeing, where every employee can reach their full potential. Combining purposeful in-person collaboration with flexibility, our focus is to optimize performance and drive connection for moments that matter.

Who We Are:
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.

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, and all applicants will receive consideration for employment.

Videos to watch:
The Culture at Mattel
Corporate Philanthropy