Job Location
BUCHAREST OFFICEJob Description
The Data & BI Engineer designs, builds, and operates the data models, pipelines, and reporting layer that turn our Key Opinion Leader (KOL) / influencer marketing platform's operational data into trusted analytics. Working hands-on across Cloud Spanner (the platform's transactional database), BigQuery (analytical warehouse), and Looker (BI and dashboards), this role powers reporting across the end-to-end campaign lifecycle — partner discovery, contract automation, campaign execution, content performance, brand-safety, and adoption tracking. The role supports the Social Digital Products space.
Key Responsibilities
- Design, evolve, and optimize data models and schemas in Cloud Spanner — tables, primary keys that avoid hotspots, secondary indexes, and interleaved (parent-child) tables — and write efficient, parameterized DML and queries with sound read-only vs. read-write transaction handling
- Design, build, and operate GCP data pipelines that move and transform data from Cloud Spanner (OLTP) into the BigQuery analytics warehouse, using federated queries (EXTERNAL_QUERY), scheduled queries, and BigQuery Data Transfer Service
- Model the BigQuery warehouse across staging and curated layers, applying partitioning, clustering, and cost-aware design for performance and spend control
- Develop and maintain reporting views and analytical SQL (window functions, incremental logic, reconciliation) that feed dashboards and downstream consumers
- Develop and extend our Looker (LookML) semantic layer — models, views, explores, dashboards, and persistent derived tables (PDTs) — and build and maintain Looker data tests and custom visualizations
- Own data quality, freshness, and reconciliation across both Spanner and BigQuery: implement tests, monitoring, and alerting so metrics are accurate and trustworthy for leadership reporting
- Integrate data from social platforms, third-party influencer marketplaces, comment / brand-safety annotation jobs, and internal P&G systems into the warehouse
- Orchestrate pipelines and jobs with Cloud Workflows, Cloud Run, Pub/Sub, and Cloud Scheduler; manage secrets with Secret Manager and logs with Cloud Logging
- Contribute to Terraform for Spanner instances/databases, BigQuery datasets, scheduled queries, connections, and IAM, supporting self-serve provisioning and policy guardrails
- Optimize query performance and cost across Spanner and BigQuery, and identify and implement reliability and cost-reduction opportunities across the data and BI layer
- Partner with analysts, product managers, and engineers to translate reporting requirements into well-modeled, reusable data products, and uphold data-modeling standards, documentation, and conventions (P&G fiscal calendar, sector/brand taxonomy)
- Apply security and governance best practices: parameterized queries, least-privilege IAM, row/column-level access where required, and no hardcoded secrets
Preferred Certifications (nice-to-have, not required)
- Professional Data Engineer – Google Cloud Platform (GCP)
- Associate Cloud Engineer – GCP
- Looker LookML Developer / Looker Business Analyst – Google Cloud
- HashiCorp Certified: Terraform Associate
Job Qualifications
- Bachelor's degree in Computer Science, Data Engineering, or a related field
- Experience in data engineering, analytics engineering, BI development, or a related field
- Strong SQL, with hands-on BigQuery experience (partitioning, clustering, window functions, scheduled queries, cost optimization)
- Hands-on experience with Cloud Spanner (or a comparable distributed/relational database): schema and data modeling, DDL/DML, primary-key and hotspot design, secondary indexes, interleaved tables, transactions, and query optimization
- Hands-on experience developing in Looker / LookML — models, views, explores, dashboards, and PDTs
- Experience building data pipelines on GCP (BigQuery, Cloud Workflows, Pub/Sub, Cloud Run, Cloud Scheduler, BigQuery Data Transfer Service), including federated queries between Spanner and BigQuery
- Proficiency with Python for data processing, automation, and pipeline tooling
- Experience with data modeling (dimensional / star-schema) and building curated, reusable data marts
- Familiarity with Terraform and infrastructure-as-code for data resources
- Understanding of data quality, testing, and observability practices
- Working knowledge of Git, CI/CD, and conventional commits
- Awareness of data security and governance (least-privilege IAM, parameterized queries, PII handling, HTTPS-only)
- Nice to have: custom Looker visualizations; Dataform or dbt; experience with marketing / campaign or social-media data
Becoming part of P&G, you will benefit of:
- Competitive salary package, annual bonus and vacation bonus
- Private medical insurance & life insurance & 24 Hours Accident Insurance
- Stock Ownership Plan - You have the opportunity to buy P&G shares quoted on the New York Stock Exchange to participate in the profits of the Company and the company will match part of the investments
- Flexible working schedule & Hybrid Work from Home/Work from Office option
- Meal allowance of 40 lei / worked day and access to our private canteen
- Flex Benefits Fund allows employees to customize their benefits according to their unique situations, aspirations, and life stages. You can allocate flexibly for your Mental, Financial, Physical, and Work-Life Wellbeing (e.g., sports, dental, public transportation support, cultural events, books & study materials, kids care expenses, pet care, etc)
- Access to a variety of learning and development internal platforms
- Fresh fruits every day in the office
- Purchase of company products option at reduced prices
- Additional bridge days off offered by the company (up to 3 days per year)
- Employee Assistance Program – confidential expert guidance and specialist support on any work, wellbeing, emotional, financial, physical or family issue.
The above benefits are granted under the conditions of the collective labor agreement applicable, and P&G internal policies.
About Us
We produce globally recognized brands, and we grow the best business leaders in the industry. We leverage innovation and technology to power our globally unique marketing strategies and recognized supply chain. We serve consumers around the word with 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.
This role is part of our Bucharest Innovation Hub, find out more by visiting https://www.pgcareers.com/eu/en/see-tech-hub
At Procter & Gamble, we embrace a hybrid work model that combines the flexibility of remote work with the collaborative benefits of in-office engagement. Employees can enjoy the option to work from home two days a week while also spending time in the office to foster teamwork and enhance communication.
At P&G #weseeequal
We are an equal opportunity employer and value diversity at our company. At P&G we strive to build a culture where everyone feels welcome, included, and able to bring their full selves to work.
We ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process. Please click here if you require an accommodation during the application process. Please make sure to wait to hear back from us regarding your accommodation before proceeding with the online assessment, we thank you in advance for your patience.
Job Schedule
Full timeJob Number
R000159389Job Segmentation
Experienced ProfessionalsSkills Required
- Bachelor's degree in Computer Science, Data Engineering, or a related field
- Experience in data engineering, analytics engineering, BI development, or a related field
- Strong SQL and hands-on BigQuery experience, including partitioning, clustering, window functions, scheduled queries, and cost optimization
- Hands-on Cloud Spanner or comparable distributed/relational database experience, including schema modeling, DDL/DML, indexes, transactions, and query optimization
- Hands-on Looker and LookML experience with models, views, explores, dashboards, and persistent derived tables
- Experience building GCP data pipelines using BigQuery, Cloud Workflows, Pub/Sub, Cloud Run, Cloud Scheduler, and BigQuery Data Transfer Service
- Experience with federated queries between Cloud Spanner and BigQuery
- Proficiency with Python for data processing, automation, and pipeline tooling
- Experience with dimensional or star-schema data modeling and curated data marts
- Familiarity with Terraform and infrastructure as code for data resources
- Understanding of data quality, testing, and observability practices
- Working knowledge of Git, CI/CD, and conventional commits
- Awareness of data security and governance, including least-privilege IAM, parameterized queries, PII handling, and HTTPS-only practices
- Professional Data Engineer certification on Google Cloud Platform
- Associate Cloud Engineer certification on Google Cloud Platform
- Looker LookML Developer or Looker Business Analyst certification
- HashiCorp Certified: Terraform Associate certification
- Experience with custom Looker visualizations
- Experience with Dataform or dbt
- Experience with marketing, campaign, or social-media data
Procter & Gamble Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Procter & Gamble and has not been reviewed or approved by Procter & Gamble.
-
Fair & Transparent Compensation — Compensation is considered competitive and benchmarked against top industry peers, supported by formal pay‑equity audits and stated transparent principles. Feedback suggests pay is a strong draw, with raises described as attainable and benefits starting from day one of training.
-
Healthcare Strength — Health coverage is broad and immediate, including medical, dental, vision, life and disability insurance, with mental‑health and telemedicine offerings expanded recently. This breadth and day‑one access contribute to a perception of reliable, comprehensive care.
-
Parental & Family Support — Parental leave is inclusive under a global framework for all parents, with added recovery time for birth mothers. Adoption, fertility, childcare support and eldercare services further strengthen family support.
Procter & Gamble Insights
What We Do
Procter & Gamble Company is an American multi-national consumer goods corporation. P&G was founded over 180 years ago as a soap and candle company. Today, we’re the world’s largest consumer goods company and home to iconic, trusted brands, including Always®, Charmin®, Braun®, Fairy®, Febreze®, Gillette®, Head & Shoulders®, Oral B®, Pantene®, Pampers®, Tide®, and Vicks®. The design, development, growth and success of these products—and many more—is thanks to the innovative and insightful minds of our people. From Day 1, you’ll help make everyday life easier for our 5 billion consumers through billion dollar brands. With our large global footprint, there are many opportunities to work with P&G in multiple locations. We offer opportunities in approximately 70 countries and continually aim to attract, reward and advance the finest people in the world. As a "build from within" organization, we see 95% of our people start at an entry level and progress through the organization. Here, we want you to get your career off to a fast start. That's why we don't have any rotational development programs or gradual ramping-up periods: you’ll be able—and encouraged—to dive right in from day 1. Join us and help make life better through meaningful work that makes an impact from Day 1.
