Data Engineering Senior Manager - Consumer Data Platform

Procter & Gamble; Philippines; On-site; PHP 1,500,000 - 2,100,000; Full time

Job summary

Procter & Gamble in Manila is seeking a Senior Data Engineer to own end-to-end data platform development on Google Cloud and partner with engineering, operations and product leaders to unlock new business opportunities while safeguarding consumer data.

You will design, build, and optimize data pipelines, warehouses and dashboards, working across event-driven architectures and multiple data sources. Strong GC tools, SQL and Python required.

Qualifications

• Bachelor's or master's degree in computer science, data engineering, or related field; 5+ years in data engineering and cloud platforms.
• Proficiency in Google Cloud services such as Spanner, BigQuery, Cloud Composer or equivalent.
• Experience with ETL tools and frameworks like Spark, Dataflow and Cloud Composer/Airflow.
• Programming skills in Python, Java and SQL.
• Knowledge of data modeling techniques and relational database technologies.
• Understanding of data warehousing concepts and BI reporting tools.
• Awareness of data governance, privacy regulations, and security.

Responsibilities

• Ingest data by developing and maintaining data pipelines into Google Cloud environments.
• Transform data with cleansing, normalization, streaming validation and aggregation.
• Model data and schemas for efficient storage and retrieval in Google Cloud platforms.
• Build data warehouses or data lakes using Google Cloud services like BigQuery.
• Integrate data from multiple sources using tools like Airflow/Dataflow/Dataform.
• Apply data governance practices including security and privacy compliance.
• Optimize performance balancing scale and cost for data operations.
• Monitor and troubleshoot data-related issues with observability tools.
• Develop data structures for responsive front ends and dashboards.
• Collaborate with product managers to deliver business value.
• Document data engineering processes and configurations.

Skills

Analytical thinking

Problem solving

Communication

Education

Bachelor's or Master's in CS/Data Engineering

Tools

BigQuery

Cloud Spanner

Cloud Composer/Airflow

Dataflow

Looker Studio/PowerBI

Terraform

Github

Job description

Overview of the job

Join us as a Senior Data Engineer responsible for working with global first party Consumer Data Platform. You will work with engineering, operations and product leaders to ensure that our Consumer Data Platform opens new business opportunities while securing and governing our consumer’s personal data.

Job Location

MANILA NET PARK OFFICE

Job Description

Join us as a Senior Data Engineer responsible for working with global first party Consumer Data Platform. You will work with engineering, operations and product leaders to ensure that our Consumer Data Platform opens new business opportunities while securing and governing our consumer’s personal data.

Your team

Reporting to the Engineering Director, you’ll be part of a global, dynamic IT team at P&G. Our team is responsible for working across all P&G brands across the world and managing their first party engagement leveraging cutting edge-technologies across event-driven architecture, integrations across multiple systems and big-data analytics.

What Success Looks Like

• Transform product requirements into high-quality software features.
• Lead the design and development of the data platform in Google Cloud Platform.
• Mentor junior developers and keep yourself up to date with the latest technologies.

Responsibilities Of The Role

• Data Ingestion: Develop and maintain data pipelines to extract data from various sources and load it into Google Cloud environments.
• Data Transformation: Implement data transformation processes, including data cleansing, normalization, streaming schema validation and aggregation, to ensure data quality, completeness and consistency.
• Data Modeling: Develop and maintain data models and schemas to support efficient data storage and retrieval in Google Cloud platforms using multiple database technologies – CloudSQL, BigQuery and Cloud Spanner.
• Data Warehousing: Build data warehouses or data lakes using Google Cloud services such as Big Query.
• Data Integration: Integrate data from multiple sources using integration tools like Managed Airflow, Dataflow, Dataform or other relevant tools.
• Data Governance: Implement data governance practices, including data security, privacy, and compliance, to ensure data integrity and regulatory compliance.
• Performance Optimization: Optimize database performance, balancing both scale and cost to ensure efficient data operations.
• Monitoring and Troubleshooting: Monitor database performance using the latest observability tools and troubleshoot data-related problems in collaboration with other teams.
• Data Visualization: Build data structures to support responsive front ends and build our data dashboards and reports to enable faster decision making
• Collaboration: Work with product managers to ensure superior product delivery to drive business value & transformation
• Documentation: Document data engineering processes, data flows, and system configurations for future reference and knowledge sharing.

Job Qualifications

• Experience: Bachelor's or master's degree in computer science, data engineering, or a related field, along with 5+ year work experience in data engineering and cloud platforms. Previous experience in a senior or lead engineering role.
• Google Cloud Development: Strong proficiency in Google Cloud services such as Spanner, BigQuery, Cloud Composers or equivalent experience in other cloud-environments
• ETL Tools: Experience with ETL (Extract, Transform, Load) tools and frameworks, such as Spark, Dataflow and Cloud Composer/Airflow for data integration and transformation.
• Programming: Proficiency in programming languages such as Python, Java and SQL for data manipulation, scripting, and automation.
• Data Modeling: Knowledge of data modeling techniques and experience with data modeling tools.
• Relational Database Technologies: Familiarity with relational databases (e.g., Cloud SQL, Cloud Spanner) for efficient data storage and retrieval.
• Data Warehousing: Understanding of data warehousing concepts, dimensional modeling, and experience with data warehousing technologies such as Big Query.
• Data Governance: Knowledge of data governance principles, data security, privacy regulations (e.g., GDPR, CCPA), and experience implementing data governance practices.
• Data Visualization: Experience of working with Looker Studio/PowerBI or other reporting tools to build semantic data model & BI reports/dashboards.
• Cloud Computing: Familiarity with cloud computing concepts and experience working with cloud platforms, particularly Google Cloud Platform.
• Problem-Solving: Strong analytical and problem-solving skills to identify and resolve data-related issues. Proficiency in DevOps Tools and CICD tools (e.g. Terraform, Github)

About Us

We produce globally recognized brands and we grow the best business leaders in the industry. With a portfolio of trusted brands as diverse as ours, it is paramount our leaders are able to lead with courage the vast array of brands, categories and functions. We serve consumers around the world with one of the strongest portfolios of trusted, quality, leadership brands, including Always®, Ariel®, Gillette®, Head & Shoulders®, Herbal Essences®, Oral-B®, Pampers®, Pantene®, Tampax® and more. Our community includes operations in approximately 70 countries worldwide

Visit http://www.pg.com to know more.

Our consumers are diverse and our talents - internally - mirror this diversity to best serve it. That is why we’re committed to building a winning culture based on Inclusion and our ideal candidate is passionate about the same principle: you will join our daily effort of being “in touch” so we craft brands and products to improve the lives of the world’s consumers now and in the future. We want you to inspire us with your unrivaled ideas.

We are committed to providing equal opportunities in employment. We do not discriminate against individuals on the basis of race, color, gender, age, national origin, religion, sexual orientation, gender identity or expression, marital status, citizenship, disability, veteran status, HIV/AIDS status, or any other legally protected factor.

Job Schedule

Full time

Job Number

R000149624

Job Segmentation

Experienced Professionals