Data & BI Engineer (BigQuery, Looker)

What do you call it when 3 billion people use your products in a single day? We call it just a normal day! We see big potential in life’s little moments. Brushing teeth. Washing hair. Showering. Shaving. Caring for the baby. Cleaning the house. Doing the dishes, and the laundry. We make the products that help make these moments a little easier. Procter & Gamble is a global company. We are the largest company in the world in the Fast Moving Consumer Goods (FMCG) industry. We manufacture over 60 brands (such as Gillette, Pampers, Ariel, Pantene, Old Spice, Blend-a-Med, Bonux, Head&Shoulders, Always, Fairy) to nearly 5 billion customers, competing in 160 marketplaces. More than 130 000 employees in more than 80 countries worldwide work every day to provide products of superior quality and value to the worlds consumers.

Cerințe

Job LocationBUCHAREST OFFICEJob DescriptionThe Data & BI Engineer designs, builds, and operates the data models, pipelines, and reporting layer that turn our Key Opinion Leader (KOL) / influencer marketing platforms operational data into trusted analytics. Working hands-on across Cloud Spanner (the platforms 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 ResponsibilitiesDesign, 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 handlingDesign, 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 ServiceModel the BigQuery warehouse across staging and curated layers, applying partitioning, clustering, and cost-aware design for performance and spend controlDevelop and maintain reporting views and analytical SQL (window functions, incremental logic, reconciliation) that feed dashboards and downstream consumersDevelop 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 visualizationsOwn data quality, freshness, and reconciliation across both Spanner and BigQuery: implement tests, monitoring, and alerting so metrics are accurate and trustworthy for leadership reportingIntegrate data from social platforms, third-party influencer marketplaces, comment / brand-safety annotation jobs, and internal P&G systems into the warehouseOrchestrate pipelines and jobs with Cloud Workflows, Cloud Run, Pub/Sub, and Cloud Scheduler; manage secrets with Secret Manager and logs with Cloud LoggingContribute to Terraform for Spanner instances/databases, BigQuery datasets, scheduled queries, connections, and IAM, supporting self-serve provisioning and policy guardrailsOptimize query performance and cost across Spanner and BigQuery, and identify and implement reliability and cost-reduction opportunities across the data and BI layerPartner 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 - GCPLooker LookML Developer / Looker Business Analyst - Google CloudHashiCorp Certified: Terraform AssociateJob QualificationsBachelors degree in Computer Science, Data Engineering, or a related fieldExperience in data engineering, analytics engineering, BI development, or a related fieldStrong 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 optimizationHands-on experience developing in Looker / LookML -- models, views, explores, dashboards, and PDTsExperience building data pipelines on GCP (BigQuery, Cloud Workflows, Pub/Sub, Cloud Run, Cloud Scheduler, BigQuery Data Transfer Service), including federated queries between Spanner and BigQueryProficiency with Python for data processing, automation, and pipeline toolingExperience with data modeling (dimensional / star-schema) and building curated, reusable data martsFamiliarity with Terraform and infrastructure-as-code for data resourcesUnderstanding of data quality, testing, and observability practicesWorking knowledge of Git, CI/CD, and conventional commitsAwareness 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 dataBecoming 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 platformsFresh fruits every day in the office Purchase of company products option at reduced pricesAdditional 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 UsWe 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(R), Ariel(R), Gillette(R), Head & Shoulders(R), Herbal Essences(R), Oral-B(R), Pampers(R), Pantene(R), Tampax(R) 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 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 #weseeequalWe 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 ScheduleFull timeJob NumberR000159389Job SegmentationExperienced Professionals

Competențe

Job LocationBUCHAREST OFFICEJob DescriptionThe Data & BI Engineer designs, builds, and operates the data models, pipelines, and reporting layer that turn our Key Opinion Leader (KOL) / influencer marketing platforms operational data into trusted analytics. Working hands-on across Cloud Spanner (the platforms 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 ResponsibilitiesDesign, 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 handlingDesign, 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 ServiceModel the BigQuery warehouse across staging and curated layers, applying partitioning, clustering, and cost-aware design for performance and spend controlDevelop and maintain reporting views and analytical SQL (window functions, incremental logic, reconciliation) that feed dashboards and downstream consumersDevelop 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 visualizationsOwn data quality, freshness, and reconciliation across both Spanner and BigQuery: implement tests, monitoring, and alerting so metrics are accurate and trustworthy for leadership reportingIntegrate data from social platforms, third-party influencer marketplaces, comment / brand-safety annotation jobs, and internal P&G systems into the warehouseOrchestrate pipelines and jobs with Cloud Workflows, Cloud Run, Pub/Sub, and Cloud Scheduler; manage secrets with Secret Manager and logs with Cloud LoggingContribute to Terraform for Spanner instances/databases, BigQuery datasets, scheduled queries, connections, and IAM, supporting self-serve provisioning and policy guardrailsOptimize query performance and cost across Spanner and BigQuery, and identify and implement reliability and cost-reduction opportunities across the data and BI layerPartner 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 - GCPLooker LookML Developer / Looker Business Analyst - Google CloudHashiCorp Certified: Terraform AssociateJob QualificationsBachelors degree in Computer Science, Data Engineering, or a related fieldExperience in data engineering, analytics engineering, BI development, or a related fieldStrong 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 optimizationHands-on experience developing in Looker / LookML -- models, views, explores, dashboards, and PDTsExperience building data pipelines on GCP (BigQuery, Cloud Workflows, Pub/Sub, Cloud Run, Cloud Scheduler, BigQuery Data Transfer Service), including federated queries between Spanner and BigQueryProficiency with Python for data processing, automation, and pipeline toolingExperience with data modeling (dimensional / star-schema) and building curated, reusable data martsFamiliarity with Terraform and infrastructure-as-code for data resourcesUnderstanding of data quality, testing, and observability practicesWorking knowledge of Git, CI/CD, and conventional commitsAwareness 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 dataBecoming 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 platformsFresh fruits every day in the office Purchase of company products option at reduced pricesAdditional 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 UsWe 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(R), Ariel(R), Gillette(R), Head & Shoulders(R), Herbal Essences(R), Oral-B(R), Pampers(R), Pantene(R), Tampax(R) 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 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 #weseeequalWe 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 ScheduleFull timeJob NumberR000159389Job SegmentationExperienced Professionals