Overview We are an integral part of Annalect Global and Omnicom Group one of the largest media and advertising agency holding companies in the world Omnicom s branded networks and numerous specialty firms provide advertising strategic media planning and buying digital and interactive marketing direct and promotional marketing public relations and other specialty communications services Our agency brands are consistently recognized as being among the world s creative best Annalect India plays a key role for our group companies and global agencies by providing stellar products and services in areas of Creative Services Technology Marketing Science data analytics Market Research Business Support Services Media Services Consulting Advisory Services We currently have 2500 awesome colleagues in Annalect India who are committed to solve our clients pressing business issues We are growing rapidly and looking for talented professionals like you to be part of this journey Responsibilities Gather and evaluate data requirements by understanding client and project needs to implement scalable and effective data engineering solutions Design build and manage robust ETL Extract Transform Load pipelines using Python to support business data workflows and reporting needs Serve as the primary point of contact for all data engineering-related tasks within the project Own the data QA process create and maintain validation checks to ensure data integrity monitor pipeline health and resolve data quality issues proactively Prioritize and manage engineering tasks to ensure timely delivery of clean reliable and production-ready data Contribute to project planning by providing input on data pipeline design database performance and infrastructure needs Create and maintain technical documentation including pipeline logic data flow diagrams and troubleshooting guides Should be able to drive conversation with team client and business stake holders Qualifications 3-5 years of hands-on experience in data engineering or data management preferably within data-driven domains with a strong focus on problem-solving and automation Design develop and maintain scalable Python SQL based ETL pipelines to process transform and integrate large volumes of structured and semi-structured data Proven experience working with cloud data warehouses especially Google BigQuery and SQL managing datasets optimizing queries and ensuring data accuracy and availability Ability to collaborate with analysts and business teams to identify key performance indicators and ensure they are accurately captured and transformed Excellent written and verbal communication skills to document processes and engage with stakeholders Comfortable working with large datasets and translating raw data into clean analysis-ready outputs Ability to manage multiple data workflows and projects simultaneously ensuring timely and reliable delivery Strong written and verbal communication skills Able to work successfully with teams handling multiple projects and meeting timelines Maintaining positive client and vendor relationships