Company Description:
McDonald’s is proud to be one of the most recognized brands in the world, with restaurants in over 100 countries that serve 70 million customers daily. As the global leader in the foodservice industry, our legacy of innovation and hard work continues to drive us.
From drive-thru updates to delivery to mobile order and pay, we are innovating quickly and growing. Joining McDonald's means thinking big and preparing for a career that can have influence around the world.
At McDonald’s, we see every day as a chance to create a positive impact. We lead through our values centered on inclusivity, service, integrity, community, and family. From the support of Ronald McDonald House Charities to our Youth Opportunity project and sustainability initiatives, our values keep us dedicated to using our scale for good: good for our customers, people, industry, and the planet. We also offer outstanding benefits including a sabbatical program, tuition assistance, and flexible work arrangements.
We are an equal opportunity employer committed to the diversity of our crew members, staff, operators, and suppliers. We promote an inclusive work environment that creates feel-good moments for everyone. We are interested in people who enhance our company culture: Does this role interest you? We encourage you to apply even if you don’t meet every single requirement!
Department Overview
McDonald’s is in search of an experienced Data Architect with proficiency in data architecture design for advanced analytical solutions, an active participation in data governance initiatives, and ensuring that solutions include security and regulatory compliance. The ideal candidate will possess a track record of designing architectures specifically tailored for advanced data analytics and data warehousing scenarios. This includes understanding the nuances of various data models, ensuring optimal performance, and aligning designs with business needs for analytics or warehousing purposes. A history of successful collaboration with data strategy teams, data analysts, and other stakeholders to understand and address complex data requirements is crucial. Your dedication to continuous data architect design and management improvements will contribute significantly to the effectiveness of our data-driven initiatives.
Duties
- 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.
Qualifications
- 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 busin