Senior Data Engineer

About Us
At Assembly, we help brands find the change to fuel business growth. We are an award-winning global brand performance agency, home to 1,600 talented people across 25 offices globally. We create unique data, technology and media solutions that enable faster and smarter problem solving and an inspired, collaborative workplace culture.

At Assembly we embody three core values: Show Up - actively contribute to a space of personal and collective growth; Make Change - embrace obstacles as opportunities, taking intentional steps to drive positive change; and Win Well - approach success with integrity, responsibility, and a commitment to collaboration, understanding that the journey is as important as the destination. Together, we create an environment that fosters continuous learning, adaptability, and a shared passion for making a meaningful impact.

We stay ahead of what's next, providing fresh insights to spark new ideas. We're a trusted partner to our clients, working behind the scenes to bring imagination, depth, and clarity to their biggest challenges—in entertainment, technology, lifestyle, sports, and gaming. Together, we create with confidence

Overview
As a Senior Data Engineer, you will be working on problems that require both creativity and analytic rigor. You will be responsible for helping drive the product adoption and partnering closely with cross-functional teams including Consulting, Product, and Media teams.

Responsibilities

• Develop and manage ETL processes to support data integration and transformation.
• Optimize data storage solutions for enhanced performance and scalability.
• Ensure high data quality and integrity across all data projects.
• Collaborate with cross-functional teams to define data requirements and support analytics initiatives.
• Implement cloud services to streamline data management and accessibility.
• Enhance existing data pipelines to improve efficiency and reliability.
• Document processes and maintain comprehensive data architecture records
• Implement data visualization solutions as required by stakeholders.
• Perform data modeling and schema design to support reporting needs.
• Monitor data quality and ensure data integrity across platforms.
• Optimize SQL queries for performance improvements.
• Develop ETL processes to integrate data from various sources into BigQuery .
• Maintain and troubleshoot existing data infrastructure.
• Evaluate new GCP services and tools for data engineering solutions.

Required Skills

• Proficient in MySQL and SQL for database management.
• Strong experience in Python programming & PySpark for data processing.
• Data Engineering experience using GCP ( BigQuery , DataProc , Cloud Composer)
• Expertise in developing and optimizing ETL processes.
• Comprehensive understanding of data warehousing concepts.
• Strong written and verbal communication skills, with attention to detail.
• Experience with data pipeline construction and management.
• Familiarity with cloud services for data storage and processing.
• Experience with Data Visualization tools like Tableau, Power Bi, Looker.

Benefits

• Annual Leave in number of 20 allotted to all employees beginning of every calendar year.
• Sick Leave in number of 12 is allotted effective DOJ and beginning of ever calendar year.
• Other Leaves-Maternity Leave & Paternity Leaves, Birthday Leave Entitlement
• Dedicated L&D Budget for all Teams to upskill & get certified
• All employees are entitled for Group Personal Accident Cover & Life Cover Insurance.
• Insurance coverage for the entire family (Employee + up to 7 dependents - Self, Spouse, up to 4 children, and Parents)
• Monthly Cross Team Lunch
• Rewards and Recognition program-Employee of the month, Star Performer, Tenure Celebration & many more

Equal Opportunities
Assembly is an advocate for equal opportunity in the workplace. We are committed to ensuring equal opportunities regardless of race, colour, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability and gender identity. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements. If you have a disability or special need that requires accommodation, please let us know.

Social and Environmental Responsibility
At Assembly, we have a responsibility to bring impact into our every day. This means we must always look for ways in which to be conscious citizens in our roles to support society and environmental sustainability. We encourage employees to; be a conscious citizen by actively participating in our organisation's sustainability efforts, help us promote environmentally friendly practices within the workplace, collaborate with community organisations and stakeholders to support initiatives aligned with our company's values, participate in volunteer activities that benefit the community. Employees are also encouraged to make suggestions and evaluate our business practices to identify areas for improvement in social and environmental performance. Employees at Assembly demonstrate commitment to sustainability and inclusivity in their actions and behaviors.