Sr Enterprise Architect

McDonald's Corporation•Chicago, IL

About The Position

McDonald’s is accelerating its growth strategy, "Accelerating the Arches," focusing on Delivery, Digital, and Drive Thru to enhance customer experience through technology innovation. McDonald’s Global Technology aims to power future feel-good moments by leveraging AI, robotics, and emerging tech to digitize the Golden Arches and reshape the business globally. The company faces complex tech challenges, addressed by diverse and talented teams. The Global Technology Technical Blog provides insights into how technology enables the Accelerating the Arches strategy. The department is seeking an experienced Data Architect proficient in designing data architectures for advanced analytical solutions, actively participating in data governance, and ensuring security and regulatory compliance. The ideal candidate will have a proven track record in designing architectures for advanced data analytics and data warehousing, understanding various data models, optimizing performance, and aligning designs with business needs. Successful collaboration with data strategy teams, data analysts, and other stakeholders to address complex data requirements is crucial. A dedication to continuous data architect design and management improvements is expected to contribute significantly to data-driven initiatives.

Requirements

Bachelor’s or Master’s degree in information technology, or a related field.
10+ years in data architecture: expertise in ER, dimensional, canonical models; tailored designs for advanced analytics and data warehousing; collaboration with BI and analytics teams.
5+ years of experience with ERwin Data Modeler: expertise in logical, physical, and conceptual modeling; ability to translate business requirements.
5+ years of experience with cloud services like AWS, AZURE, or GCP – AWS preferred.
5+ years of experience coding advance SQL and experience with database technologies like Redshift, Snowflake, Databricks, or BigQuery.
Understanding of data processing frameworks and pipelines utilizing cloud managed services and tools like Talend, Informatica, or DBT.
Strong analytical skills and problem-solving aptitude.

Nice To Haves

Familiarity with ERwin's collaboration capabilities and integration with other data management tools is a plus.
Expertise in creating and managing Data Lake architectures a plus.
Experience with data governance tools like Collibra a plus.
Deep expertise in data architecture design, demonstrating mastery in crafting ER (Entity-Relationship), dimensional, and canonical modeling techniques.
Demonstrated expertise in data governance, data management, and data quality geared towards data analytics, data science and GenAI contexts.
Adept at leveraging ERwin's features to design complex data structures, ensure data integrity, and support database optimization efforts.
Excellent written, verbal, and meeting facilitation skills.
Strong analytical and critical thinking skills.
Self-driven with ability to set priorities and mentor others in a performance driven environment.

Responsibilities

Oversee the design, development, deployment, and management of all data architecture design solutions. Ensure that designs are scalable, flexible, and tailored for advanced analytics and data warehousing scenarios across various database technologies including AWS Redshift, Databricks, Snowflake, and GCP BigQuery.
Take an active role in data governance initiatives. Collaborate with cross-functional teams to drive best practices, emphasizing data accuracy, security, and ensuring that all architectures are in line with regulatory compliance standards.
Utilize tools such as ERwin for advanced data modeling, ensuring optimal schema designs that align with business analytics and warehousing needs.
Generate data solution architecture blueprints, data flow diagrams, data impact analysis, and comprehensive data design documents to facilitate understanding and streamline implementation.
Regularly liaise with data analysts, business intelligence teams, and other key stakeholders to gather, understand, and address complex data requirements. Ensure that the data solutions designed are both technically sound and aligned with business needs.
Regularly review and refine data architectures for optimal performance. Work closely with the database management and analytics teams to identify bottlenecks and implement solutions.
Ensure that various data sources, platforms, and tools can seamlessly integrate, allowing for a unified and coherent data landscape.
Work closely with the IT security team to ensure that all data architectures adhere to strict security protocols, ensuring data privacy and protection.
Stay updated with the latest trends and best practices in data architecture. Continuously evaluate the existing architectures and processes, recommending and implementing improvements as necessary.
Conduct effective meetings, workshops, and training sessions. Be skilled at conveying complex ideas in a clear and understandable manner, tailoring communication strategies based on the audience and the nature of the project.
Provide guidance, mentorship, and training to junior members of the team, ensuring they are well-equipped to meet their responsibilities and contribute effectively to the team's goals.