Sr Data Analyst in Chicago, IL

$80K - $100K(Ladders Estimates)

McDonalds   •  

Chicago, IL 60601

Industry: Hospitality & Recreation


Less than 5 years

Posted 29 days ago

Job Description

We currently have a need for a Sr Data Analyst

McDonald's is looking for an established Data Analyst to

join the Global Data and Analytics Platform. You will be a self-starter who can

work in a diverse and fast-paced environment. If you enjoy working closely with

multi-functional teams and learning about new technologies then this job is for you.


The Sr Data Analyst will be part of a team of data

modeler/architects supporting the data and analytics team. The team is

responsible for all logical and physical dimensional modeling using Erwin (or

similar) modeling and support for the NoSQL databases. They will interact

directly with product owners, business analysts, developers and DBA team. This

person should possess excellent oral and written communication skills with the

ability to quickly learn about multiple business subject areas.


Translates and transforms business requirements into data

models (Conceptual, Logical and Physical)

Analyze source system data and profile data as needed.

Design dimensional and NoSQL data models for the analytics


Maintain relational data model repository in Erwin as well

as NoSQL data models.

Design dimensional and relational data models

Provide insight, best standards for NoSQL data modeling as

well as assist in data modeling tool selection.

Drive conversations with development and DBA teams to

optimize the schema structure and ingestion processes influencing the write and

read performance.

Provide assistance to project teams on data modeling policies,

procedure, processes and standards.

Provide recommendations to enhance current DA standards as

necessary or develop standards for new technology implementations.

Assist with collecting and documenting system flow and other

pertinent technical information about data database design and/or systems

Implement and follow established data governance and

consistency in the data model and standardization of business definitions

Knowledge of DBMS platforms (e.g. Redshift, SQL Server,

NoSql, Cassandra) with experience in generating DDL as needed

Minimum Requirements

BS in Computer Science or related field is


<!--[if !supportLists]-->·

<!--[endif]-->You have 2+ years of exposure to the CA Erwin

Data Modeler or something similar

<!--[if !supportLists]-->·

<!--[endif]-->Possess 2+ in Relational and Dimensional data

design and modeling in a large multi-platform data environment

<!--[if !supportLists]-->·

<!--[endif]-->1+ years of experience with creating SQL to

investigate data anomalies, patterns and profiling

<!--[if !supportLists]-->·

<!--[endif]-->1+ years exposure to an Agile Tool, specifically

JIRA and Confluence is a plus

<!--[if !supportLists]-->·

<!--[endif]-->1+ years of professional experience with Agile

terminology and practices such as User Stories, Backlog, Scrum, and Acceptance


Desired Skills:

<!--[if !supportLists]-->·

<!--[endif]-->Advanced SQL coding skills preferred

<!--[if !supportLists]-->·

<!--[endif]-->Cloud AWS experience preferred.

<!--[if !supportLists]-->·

<!--[endif]-->Experience with Redshift, NoSQL, Cassandra, and

SQL Server is preferred

<!--[if !supportLists]-->·

<!--[endif]-->Possess excellent written and verbal communication.

<!--[if !supportLists]-->·

<!--[endif]-->Strong knowledge of principles, techniques, and

methodologies of enterprise data modeling and dimensional data modeling and

enterprise data modeling related to Data Warehousing and Business Intelligence

<!--[if !supportLists]-->·

<!--[endif]-->Experience or knowledge of NoSQL Modeling

<!--[if !supportLists]-->·

<!--[endif]-->Knowledge and experience in CRM standards a plus

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. Needless to say, you'll be lovin' it here…

McDonald's Corporation continues to grow and expand!

We are one of most recognizable names in the world. In 2018,

we have been rated as a 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



United States

Requisition Number


EOE Statement

Valid Through: 2019-10-15