SeniorDataEngineer

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 re