WPP Logo

WPP

GCP data Engineer

Job Posted 17 Days Ago Reposted 17 Days Ago
Chennai, Tamil Nadu
Junior
Chennai, Tamil Nadu
Junior
As a GCP Data Engineer, you will manage ETL processes, optimize data storage on GCP, collaborate with stakeholders, and document data engineering practices for EMEA markets.
The summary above was generated by AI

WPP is the creative transformation company. We use the power of creativity to build better futures for our people, planet, clients, and communities.

Working at WPP means being part of a global network of more than 100,000 talented people dedicated to doing extraordinary work for our clients. We operate in over 100 countries, with corporate headquarters in New York, London and Singapore.

WPP is a world leader in marketing services, with deep AI, data and technology capabilities, global presence and unrivalled creative talent. Our clients include many of the biggest companies and advertisers in the world, including approximately 300 of the Fortune Global 500.

Our people are the key to our success. We're committed to fostering a culture of creativity, belonging and continuous learning, attracting and developing the brightest talent, and providing exciting career opportunities that help our people grow. 

Why we're hiring:

At WPP, technology is at the heart of everything we do, and it is WPP IT’s mission to enable everyone to collaborate, create and thrive. WPP IT is undergoing a significant transformation to modernise ways of working, shift to cloud and micro-service-based architectures, drive automation, digitise colleague and client experiences and deliver insight from WPP’s petabytes of data.

GroupM is the world’s leading media investment company responsible for more than $63B in annual media investment through agencies Mindshare, MediaCom, Wavemaker, Essence and m/SIX, as well as the outcomes-driven programmatic audience company, Xaxis and data and technology company Choreograph. GroupM’s portfolio includes Data & Technology, Investment and Services, all united in a vision to shape the next era of media where advertising works better for people. By leveraging all the benefits of scale, the company innovates, differentiates and generates sustained value for our clients wherever they do business.

The GroupM IT team in WPP IT are the technology solutions partner for the GroupM group of agencies and are accountable for co-ordinating and assuring end-to-end change delivery, managing the GroupM IT technology life-cycle and innovation pipeline.

This role will work as part of the Local Systems Team for EMEA. You will be part of a new team Data team in Chennai, that will support our existing and future BI setup for EMEA markets. You will be responsible for delivering the solutions formulated by product owners and key stakeholders for different EMEA markets.  In collaboration with the Data development team, you update the architecture and data models to new data needs and changes in source systems.


What you'll be doing:

  • Assist in the build, development, and management of custom databases/solutions using SSIS.
  • Monitoring and optimizing data processing and storage resources on GCP.
  • Clearly communicate technical terms to non-technical people and help them understand why change might be required to achieve a specific goal or to complete a project
  • Design, build and deploy ETL and data management processes. Develop and deploy ETL job workflow with reliable error/exception handling and rollback framework.
  • Monitoring and optimizing data processing and storage resources on GCP.
  • Troubleshooting and resolving data pipeline issues and performance bottlenecks.
  • Documenting data engineering processes, best practices, and technical specifications.
  • Conform to agile development practices – Evolutionary design, refactoring, continuous integration/delivery, test-driven development.
  • Work collaboratively with Business Partner Team and Business Stakeholder during projects scoping and feasibility phases as a SME for concept investigation/viability and technical impact; Identify and communicate technical risks and mitigations.
  • Provide production support for data load jobs.
  • Write customized query to generate automatic periodic reports.
  • Build applications writing SQL scripts to manipulate data and / or writing specific instructions for an off-shore programmer to write the scripts.
  • Maintain or upgrade existing applications.
  • Attend key design meetings and provide support.
  • Other ad hoc duties.
  •  

What you'll need:

  • 2+ years experience with creating and managing SSIS and writing TSQL (views/functions/stored procedures).
  • 3+ years experienced engineer who has worked on GCP environment and its relevant tools/services. (Big Query, Data Proc, Data flow, Workflows, Cloud Storage, Terraform, Cloudrun , Cloud scheduler, Astronomer/Airflow)
  • 1 or 2 + years of strong experience in Python development (Object oriented/Functional Programming, Pandas, Pyspark etc)
  • 1 or 2 + years of strong experience in SQL Language (CTEs, Window functions, Aggregate functions etc)
  • Good to have DBT knowledge
  • Experience with major RDBMS systems like MS-SQL, Oracle, PostgreSQL, Teradata etc
  • Hands-on with GitHub or equivalent source control repositories 
  • Bachelor’s degree in Computer Science, Engineering, Mathematics or other technical field is highly preferred.
  • Experience with data modeling, and working with star schema
  • Experience with the full development life cycle of an application stack - from architecture through test and deployment.
  • Demonstrated experience in data warehouse analysis and design, with full knowledge of data warehouse methodologies and data modelling.
  • Unit testing low level components – SQL scripts, Stored Procedures, ETL modules; Integration testing data transition points; Performance, load and stress testing.
  • Knowledge and experience in software development methodology and toolset for implementing, lifecycle and management – Agile methodology.
  • TFS/GIT code repository and branching strategies; Microsoft Release Management and any deployment tools; Jira knowledge.
  • Team player
  • Organized and detail oriented
  • Excellent communication, presentation, and writing skills

Who you are:

You're open: We are inclusive and collaborative; we encourage the free exchange of ideas; we respect and celebrate diverse views. We are accepting: of new ideas, new partnerships, new ways of working.

You're optimistic: We believe in the power of creativity, technology and talent to create brighter futures or our people, our clients and our communities. We approach all that we do with conviction: to try the new and to seek the unexpected.

You're extraordinary: we are stronger together: through collaboration we achieve the amazing. We are creative leaders and pioneers of our industry; we provide extraordinary every day.


What we'll give you:

Passionate, inspired people – We promote a culture of people that do extraordinary work.

Scale and opportunity – We offer the opportunity to create, influence and complete projects at a scale that is unparalleled in the industry.

Challenging and stimulating work – Unique work and the opportunity to join a group of creative problem solvers. Are you up for the challenge?

#LI-Onsite

We believe the best work happens when we're together, fostering creativity, collaboration, and connection. That's why we’ve adopted a hybrid approach, with teams in the office around four days a week. If you require accommodations or flexibility, please discuss this with the hiring team during the interview process.

WPP is an equal opportunity employer and considers applicants for all positions without discrimination or regard to particular characteristics. We are committed to fostering a culture of respect in which everyone feels they belong and has the same opportunities to progress in their careers.

Please read our Privacy Notice (https://www.wpp.com/people/wpp-privacy-policy-for-recruitment) for more information on how we process the information you provide.

Top Skills

BigQuery
Cloud Scheduler
Cloud Storage
Cloudrun
Data Flow
Data Proc
Dbt
GCP
Ms-Sql
Oracle
Postgres
Python
SQL
Ssis
Teradata
Terraform
Tsql
Workflows

Similar Jobs

9 Days Ago
Chennai, Tamil Nadu, IND
Mid level
Mid level
Information Technology • Marketing Tech • Analytics
You will design data pipelines, support data quality initiatives, and provide strategic advice to stakeholders while collaborating with teams to implement data solutions.
Top Skills: AccurevAlteryxBig QueryCloud ComposerCloud SqlCloud StorageData FlowData StageDataprocGitGoogle Cloud PlatformHadoopHiveKafkaPub SubPythonQliksenseScalaSparkSQLTerraform
3 Days Ago
Easy Apply
Hybrid
Chennai, Tamil Nadu, IND
Easy Apply
Senior level
Senior level
Artificial Intelligence • Consumer Web • Edtech • Enterprise Web • HR Tech • Social Impact • Generative AI
The Staff Data Scientist will partner with product managers to drive data-informed decisions, develop metrics and dashboards, and lead analytics initiatives focused on global markets.
Top Skills: AirflowDbtModePythonSparkSQLTableau
4 Days Ago
Hybrid
5 Locations
Junior
Junior
Artificial Intelligence • Healthtech • Professional Services • Analytics • Consulting
As a Decision Analytics Associate, develop statistical models and custom analyses using tools to solve business challenges and enhance decision-making for clients.
Top Skills: ExcelHadoopJavaPythonRSASTableauVisual Basic

What you need to know about the Chennai Tech Scene

To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
By clicking Apply you agree to share your profile information with the hiring company.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account