Data Engineer III

McDonald's Corporation•Chicago, IL

2d•Onsite

About The Position

McDonald’s growth strategy, Accelerating the Arches, encompasses all aspects of our business as the leading global omni-channel restaurant brand. As the consumer landscape shifts we are using our competitive advantages to further strengthen our brand. One of our core growth strategies is to Double Down on the 3Ds (Delivery, Digital and Drive Thru). McDonald’s will accelerate technology innovation so 65M+ customers a day will experience a fast, easy experience, whether at one of our 25,000 and growing Drive thrus, through McDelivery, dine-in or takeaway.  McDonald’s Global Technology is here to power tomorrow’s feel-good moments.   That’s why you’ll find us at the forefront of transformative technology, exploring new and innovative ways to serve our millions of customers and spread happiness one delicious Hot Fudge Sundae-dipped fry at a time. Using AI, robotics and emerging tech, we’re digitizing the Golden Arches. Combine that with our unparalleled global scale, and we’re reshaping all areas of the business, industry and every community that is home to a McDonald’s restaurant. We face complex tech challenges every day. But that’s where our diverse and talented teams come in. They’re made up of the best and brightest from all over the globe, and they thrive in the space where feel-good meets fast-paced.   Check out the McDonald’s  Global Technology Technical Blog to learn how technology and our global team are directly enabling the Accelerating the Arches strategy.  We are seeking a highly motivated individual to be our Data Engineer with strong technical and communication skills for our Customer Data Products, End-to-End (E2E) integrated testing team. This role requires both business and technical expertise working with various integrated applications, Data, Product teams and Global Market partners. E2E team plays vital role to bridge the gap between McDonald’s Digital and Data systems with E2E integrated testing support to deliver required quality data to our business partners for marketing and reporting needs so this role is crucial in our Customer domain. This role is based in Chicago, IL

Requirements

Bachelor’s degree or higher in Computer Engineering, Software, or relevant technology field
10+ years of experience as Software Engineer, Data Engineer, or combined work experience
10+ years of experience working in Java, Python, HTML, JavaScript, Node.js, Terraform, SQL and NoSQL
Experienced with large scale enterprise application development, deployment, integration, and testing
Experienced writing SQL scripts, Store Procedures and Functions on large complex data sets, Datawarehouse, ETL, reporting and analytics
Experienced developing shell scripts, creating batch scripts, Linux, Cron and CICD pipeline workflows. Use of programming languages such as Java and Python to build and optimize those automations
Hands on experience automating to create data in various data formats for load and performance testing
Development experience with Big Data processing frameworks, ETL tools, API tools, Data integrations and data pipeline automations
Experienced with AWS and GCP Cloud services, Airflow DAGs, DBT, Talend Studio, Databricks
Experienced with various testing frameworks and automations such as OpenTest, Junit, JMeter, Selenium
Experienced with developing reporting dashboards in New Relic, Kibana, Grafana, Tableau
Well versed with various data generation sources such as Mobile, Web, POS, Kiosk and data format such as JSON, SOAP, CSV, Parquet, Avro, XML
Skilled with customer facing applications such as native app, web, multiple integration layers, databases, event transactions, log data, elastic search, message queueing, transformations, processing, and storage
Experienced with N-tier architecture, Client/Server, Pub/Sub and distributed micro services development.
Thorough knowledge of customer data flow from Account registration flow to Order transactions, Subscriptions, Offer redemptions, Loyalty program, Mobile Ordering & Payments, and Marketing CRM tools.
Good knowledge of legal compliance when working with Data privacy, and various Markets such as GDPR, CCPA, PCI and HIPPA
Previous experience in McDonald’s or similar QSR business model, large-scale E-commerce applications.

Nice To Haves

Certified with AWS Solutions Architect Associate or higher certifications
Certified with GCP Cloud Engineer, Data practitioner or higher certifications.

Responsibilities

Team up with E2E team to understand existing E2E integrations with upstream and downstream applications, environments mapping, testing strategy, design, evolving scope and implement continuous improvements
Participate in daily scrum for day-to-day updates, understand testing needs for ongoing and upcoming initiatives
Capture requirements, design/architect, develop, and implement day-to-day testing automation needs for the team
Document artifacts for the solutions built, optimize for continuous improvements with emerging tools and technologies
Develop, deploy, and monitor day-to-day automation builds using both open source and proprietary tools/applications
Partner with internal Data product team/s, upstream Digital and downstream systems for E2E integration, testing, defect triage, troubleshoot and resolution
Identify and manage necessary infrastructure, tools and environments for the required integration, development, deployment, testing, and automation needs
Develop and manage automated testing workstreams, review new requirements and add test cases for Continuous Integration (CI), Continuous Deployment (CD) and Continuous Testing (CT)
Develop/maintain source code with Git, Code Commit, CICD pipeline builds and deployments
Lead E2E team when coordinating with stakeholders from Markets, various team leads, products and identify issues/resolution in timely manner to prevent unnecessary escalations.