Senior Data Quality Analyst

We are proud to be one of the most recognized brands in the world, with restaurants in over 100 countries and billions of customers served each year. As the global leader in the food service industry, we have a legacy of innovation and hard work that continues to drive us. Today, we are growing with velocity and are focused on modernizing our experiences, not to make a different McDonald’s but to build a better McDonald’s.

We pride ourselves in being a people business just as much as we are a restaurant business. We strive to be the most inclusive brand on the planet by establishing teams with varying strengths who create delicious, feel good moments that are easy for everyone to enjoy. Joining McDonald's means thinking big every day and preparing for a career that can have impact around the world.

We are dedicated to using our scale for good: good for people, our industry and the planet. From leading recycling initiatives and sustainable sourcing efforts to our partnership with Ronald McDonald House Charities, we see every day as a chance to have a genuine impact on our customers, our people and our partners.

Our new, state-of-the art headquarters is located in the booming West Loop area in the heart of downtown Chicago. It is set up to be a global hub that champions innovation: take a class at Hamburger University, sample future menu items in our Test Kitchen, and utilize the latest technology to stay up to date with your team around the globe. With monthly organized events, massive outdoor spaces, an 8000 square foot gym, and an onsite McDonald's serving international favorites, our office helps us connect with each other like never before.

McDonald's Corporation continues to grow and expand!

We are one of most recognizable names in the world. In 2018, McDonald’s was rated as one of the top 10 place to work in Chicago. As a modern, forward-thinking “Tech” company, we are continually changing the Retail QSR industry. Working in our IT sector of the corporation will provide you with important work and one of the best comprehensive benefits packages in the industry.

The McDonald's Global Data & Analytics team has an exciting opportunity for a Sr. Data Analyst. With supervision this position defines the business requirements (keeping Data Quality as the focus) and builds process and data models for technology solutions that meet the business needs. Bridges the gap between the business customer and the technology solution providers by translating business needs to technical solutions throughout the life cycle of the product. Coordinates and/or executes plans to ensure that technical solutions meet the needs of the business.

You will have extensive experience in a data warehouse environment facilitating requirements gathering sessions, documenting requirements, analyzing and evaluating possible solutions to meet requirements. Experience in leading QA processes including creating test strategy and test plan documents as well as executing tests and working with external QA vendors. The candidate will be a highly organized self-starter who thrives in a dynamic and fast paced environment.

  • BS in Computer Science or related field is REQUIRED.
  • Ability to read, develop and test advanced SQL statements
  • Working knowledge of relational and dimensional data design and modeling in a large multi-platform data environment.
  • Experienced in writing test plans and scripts
  • Excellent problem solver - use of data and technology to solve problems or answer complex data related questions.
  • Ability to manage multiple projects under multiple subject areas at once.
  • Ability to think creatively about data designs and options.
  • Superb communication skills both verbal and written.
  • 3+ years of experience with creating SQL to investigate data anomalies, patterns and profiling.
  • Experience with JIRA and Confluence as part of project workflow and documentation tools is a plus.
  • Experience with Agile project management methods and terminology a plus.

  • Gather business requirements and translate them into objects used for data ingest, reporting and advanced analytics.
  • Assist business analysts with providing clear and concise business and quality rules.
  • Data mapping and data profiling data sources using SQL and data profiling tools.
  • Collect and document system flows and other pertinent technical information about data database design and/or data systems.
  • Implement and follow established data governance standards in the data model and standardization of business definitions.
  • Transform business concepts into the written word to provide comprehensive business definition of objects.
  • Serve as subject matter expert on data within the Global Data and Analytics platform.
  • Participate on data quality management initiatives.
Read Full Job Description

Technology we use

  • Engineering
  • Product
    • .NETLanguages
    • C#Languages
    • C++Languages
    • JavaLanguages
    • JavascriptLanguages
    • SqlLanguages
    • SwiftLanguages
    • CustomLanguages
    • jQuery UILibraries
    • ReactLibraries
    • CustomLibraries
    • AngularJSFrameworks
    • ASP.NETFrameworks
    • ExpressFrameworks
    • HadoopFrameworks
    • Node.jsFrameworks
    • SparkFrameworks
    • SpringFrameworks
    • TensorFlowFrameworks
    • CustomFrameworks
    • CassandraDatabases
    • HBaseDatabases
    • Microsoft SQL ServerDatabases
    • OracleDatabases
    • RedisDatabases
    • SQLiteDatabases
    • TeradataDatabases
    • CustomDatabases
    • CustomAnalytics
    • CustomDesign
    • Custom Management

Location

In the heart of the West Loop, a vibrant and rapidly growing tech neighborhood. Our new HQ is accessible by all forms of transportation.

An Insider's view of McDonald's Technology

What’s the vibe like in the office?

The entrepreneurial spirit at McDonald’s is noticeable at all levels. People inspire; people are nimble; people are team-driven; people are focused on evolving and improving. When you walk around the space, you can feel the energy that comes from collaboration and problem-solving. I am motivated to push myself every day.

Jen

Product Manager, Global Mobile App

What kinds of technical challenges do you and your team face?

We are providing insights and real time event data for decision making and marketing activation at a scale very few other companies can compare to. We are moving from a 1 to many CRM strategy to a 1 to 1 contextual and personalized experience for our customers and are watching our data drive the direction of feature development within McDonald’s.

Eric

Sr. Manager, Digital Analytics

What does career growth look like on your team?

Working at a company of this Global scale has stretched my skills like never before. The sheer number and variety of customers using the product I work on every day is both challenging and exhilarating; developing my skillset in a way that would be hard to match elsewhere

Jade

Sr. Product Manager, Kiosk

What's the biggest problem your team is solving?

McDonald’s has a few consistent challenges that we’re always solving for - scale and flexibility are critical. Every piece of technology that we build has to be scalable to 30,000+ restaurants! The second challenge is flexibility –we need to provide a consistent and reliable experience, and every restaurant is unique!

Whitney

Product Capabilities and Innovation

What are McDonald's Technology Perks + Benefits

Culture
Volunteer in local community
Open office floor plan
Health Insurance & Wellness Benefits
Disability Insurance
McDonald's provides both short and long term disability benefits at no cost to you.
Dental Benefits
McDonald’s Dental Plans allows you to see the dentist of your choice and provides coverage for preventive, basic, major and orthodontic care at 100%.
Vision Benefits
McDonald's Vision Plan provides eye exam coverage and benefits that reduce your costs for prescription eyewear, contact lenses and laser vision correction.
Health Insurance Benefits
McDonald’s offers medical plan options to help pay for the cost of health care when you need it. During enrollment, you can sign up for the insurance and pick which plan is best for you.
Life Insurance
McDonald’s automatically gives you basic life, dependent life, accidental death and dismemberment (AD&D) and Business Travel Accident Insurance (BTA) at no cost to you.
Onsite Gym
We have an 8000 square foot gym on our 9th floor with best-in-class equipment, classes, personal training, and magnificent views of the city!
Retirement & Stock Options Benefits
401(K) Matching
Once you’re eligible for the company match, McDonald’s will match your contributions with $1 for each $1 you contribute up to a maximum of 6% of your annual pay, up to IRS limits.
Performance Bonus
Match charitable contributions
McDonald’s Matching Gifts Program encourages employee support of not-for-profit organizations. Under this program, McDonald’s gives $1 for every $1 you contribute, up to $5,000 a year.
Child Care & Parental Leave Benefits
Child Care Benefits
McDonald’s has agreements for employee child care discounts to help you with the cost of child care while you work.
Generous Parental Leave
McDonald’s provides four types of Parental Leave, and you may be eligible for one or more of the types of leave listed: Paid Parental Leave, Maternity Leave, Adoption Leave, Unpaid Parental Leave.
Flexible Work Schedule
McDonald's provides employees with a flexible work schedule that includes Summer hours, Core hours, Compressed week, Flexible start and end times.
Family Medical Leave
The Family and Medical Leave Act (FMLA) and certain state laws allow you to take unpaid leave to care for yourself and your qualified family members, as long as you are eligible.
Adoption Assistance
McDonald’s Adoption Assistance Program helps with the costs of adopting a child. The child must be under age 18 and not related to you by blood or marriage.
Vacation & Time Off Benefits
Generous PTO
McDonald's employees receive between 15 and 25 days per year of paid time off based on years of service.
Sabbatical
Eligible employees get 40 days of paid sabbatical after their first 10 years of working at McDonald's
Paid Holidays
Paid Sick Days
McDonald's employees receive 100 hours per year of paid sick leave.
Perks & Discounts
Casual Dress
Commuter Benefits
Happy Hours
Happy hours are hosted on Thursdays in the summer, and twice a month on Thursdays during the remainder of the year.
Parking
McDonald's offers employees paid on-site garage parking.
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Diversity Program
Continuing Education stipend
Paid industry certifications
More Jobs at McDonald's Technology38 open jobs
All Jobs
Data + Analytics
Design + UX
Dev + Engineer
Operations
Product
Project Mgmt
Data + Analytics
new
Chicago
Project Mgmt
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Project Mgmt
new
Chicago
Developer
new
Chicago
Project Mgmt
new
Chicago
Operations
new
Chicago
Design + UX
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Project Mgmt
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago