Data Engineer III

About McDonald’s:

One of the world’s largest employers with locations in more than 100 countries, McDonald’s Corporation has corporate opportunities in Hyderabad. Our global offices serve as dynamic innovation and operations hubs, designed to expand McDonald's global talent base and in-house expertise. Our new office in Hyderabad will bring together knowledge across business, technology, analytics, and AI, accelerating our ability to deliver impactful solutions for the business and our customers across the globe.

One of the world’s largest employers with locations in more than 100 countries, McDonald’s Corporation has corporate opportunities in Hyderabad. Our global offices serve as dynamic innovation and operations hubs, designed to expand McDonald's global talent base and in-house expertise. Our new office in Hyderabad will bring together knowledge across business, technology, analytics, and AI, accelerating our ability to deliver impactful solutions for the business and our customers across the globe.

Position Summary:

Data Engineer III

Builds the data pipelines behind how guests and crew experience the restaurant. Restaurant Experience combines customer satisfaction surveys from multiple survey vendors, customer care cases, and social listening. It links them to guest counts, sales, and speed of service, and measures them against operational performance standards. This role brings these multi-vendor sources together into trusted, privacy-safe datasets for reporting, data science, and restaurant performance applications.

• Build ingestion from customer satisfaction survey vendors (such as Medallia, Qualtrics, and SMG), in-app surveys, and customer care cases in Salesforce, using vendor APIs and secure file exchange (SFTP, S3 to Cloud Storage, PGP-encrypted files).
• Integrate social listening data as a guest experience source alongside the survey and customer care data, applying privacy rules to any personal data.
• Build a reusable vendor ingestion framework that handles rate limits, pagination, retries, incremental loads, and schema changes.
• Model experience data in BigQuery at restaurant, month, daypart, and channel grain, aligned to restaurant hierarchy master data and linked at aggregate level to guest counts, sales, and speed of service.
• As vendor verbatim comments become available, prepare free-text feedback for NLP and sentiment models with data scientists, with PII-safe handling of care case notes.
• Implement PII controls, including masking, tokenization, column-level access, retention, anonymity thresholds, and GDPR access and delete flows, in line with GDPR and CCPA / CPRA.
• Deliver curated datasets for performance reporting, scorecards, and short-term operational views.
• Build or extend Python REST services (Flask / FastAPI) that serve curated experience data to restaurant performance applications, and agree API contracts and Data Interface Contracts with the application teams.
• Develop orchestration with Apache Airflow (Astronomer) and transformations with dbt, using Git, GitHub Actions, automated testing, and vendor-to-warehouse reconciliation.
• Act as level-2 support for production pipeline incidents, and support market onboarding as survey vendors change.
• Use approved AI coding assistants (such as GitHub Copilot and Gemini Code Assist) across the lifecycle for code, tests, SQL and dbt models, debugging, and documentation, and review and validate every AI-generated change.
• Work with the product owner and analysts on survey validity rules and a single satisfaction calculation standard across reporting surfaces. Document pipelines, mentor junior engineers, and coordinate across time zones.

• 7–11 years of professional experience, with 7+ years of hands-on data engineering.
• Advanced Python and production-grade SQL.
• Python REST frameworks (Flask, FastAPI) for building data services.
• Strong experience integrating third-party and SaaS APIs (REST, OAuth, webhooks) and file-based feeds, including SFTP / S3 file exchange and PGP-encrypted files.
• Strong GCP data experience: BigQuery, Cloud Storage, Dataflow / Dataproc, Pub/Sub, Cloud Run, and IAM.
• Hands-on experience with Apache Airflow (Astronomer) and dbt.
• Experience handling PII and sensitive data with masking, access controls, retention policies, and GDPR access and delete workflows.
• Practical experience with Docker, Git, GitHub Actions CI/CD, and Terraform.
• Expert knowledge of data quality functions such as cleansing, standardization, parsing, de-duplication, and mapping.
• Experience supporting BI users in Tableau.
• Hands-on experience using AI coding assistants and LLM tools to improve engineering productivity, with sound judgment on code quality and security, and responsible use that keeps confidential and personal data out of prompts.
• Background in Computer Science, Engineering, or a related field with a bachelor's degree or higher.
• Preferred: survey and customer care platforms (Medallia, Qualtrics, SMG, Salesforce); NLP pipelines (Vertex AI, Natural Language API); social listening data; Google Professional Data Engineer certification; and quick service restaurant guest experience or delivery domain.
• Good to know: Java / Spring Boot; MicroStrategy; semantic engineering (semantic layers and governed metric definitions, for example dbt Semantic Layer, and ontology design) and knowledge graphs (Neo4j or Spanner Graph, with Cypher, GQL, or SPARQL).

McDonald’s is the world’s leading global foodservice retailer with over 40,000 locations in over 100 countries. Approximately 95% of McDonald’s restaurants worldwide are owned and operated by independent local business owners. At McDonald’s, we lead through our values centered on inclusivity, service, integrity, community, and family. Here is your chance to get in on something special as we grow our corporate team in India and allow you to grow your career.