Data Architect Mcdonald's
Chicago, IL

Job Description

We currently have a need for a Data Architect

McDonald's is looking for an established Data Architect 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.

Role:

The Data Architect 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 platform.
* 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