Sr Manager, Data Architecture

Job Description:

Company Description:

McDonald's growth strategy, Accelerating the Arches, encompasses all aspects of our business as the leading global omni-channel restaurant brand. As the consumer landscape shifts we are using our competitive advantages to further strengthen our brand. One of our core growth strategies is to Double Down on the 3Ds (Delivery, Digital and Drive Thru). McDonald's will accelerate technology innovation so 65M+ customers a day will experience a fast, easy experience, whether at one of our 25,000 and growing Drive thrus, through McDelivery, dine-in or takeaway.?

McDonald's Global Technology is here to power tomorrow's feel-good moments.??

That's why you'll find us at the forefront of transformative technology, exploring new and innovative ways to serve our millions of customers and spread happiness one delicious Hot Fudge Sundae-dipped fry at a time.?Using AI, robotics and emerging tech, we're digitizing the Golden Arches. Combine that with our unparalleled global scale, and we're reshaping all areas of the business, industry and every community that is home to a McDonald's restaurant.?We face complex tech challenges every day. But that's where our diverse and talented teams come in. They're made up of the best and brightest from all over the globe, and they thrive in the space where feel-good meets fast-paced.??

Check out the McDonald's ?Global Technology Technical Blog ( ?to learn how technology and our global team are directly enabling the Accelerating the Arches strategy.?

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 business requirements.

• Familiarity with ERwin's collaboration capabilities and integration with other data management tools is a plus.

• 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.

• Expertise in creating and managing Data Lake architectures a plus.

• Experience with data governance tools like Collibra a plus.

• Strong analytical skills and problem-solving aptitude.

Preferred Skills:

• 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.

Compensation

Bonus Eligible: YES

Long - Term Incentive: YES

Benefits Eligible: YES

Salary Range

The expected salary range for this role is $152,678.00 - $190,847.00 per year

The above represents the expected salary range for this job requisition. Ultimately, in determining your pay, we may also consider your experience, and other job-related factors.

Additional Information:

Benefits eligible: This position offers health and welfare benefits, including but not limited to comprehensive health insurance, which includes medical, prescription drug, mental health, dental and vision coverage, as well as, life insurance; a 401(k) plan; adoption assistance program; educational assistance program; flexible ways of working; and time off policies (including sick leave, parental leave, and vacation/PTO). McDonald's is an equal opportunity employer committed to the diversity of our workforce. We promote an inclusive work environment that creates feel-good moments for everyone. McDonald's provides reasonable accommodations to qualified individuals with disabilities as part of the application or hiring process or to perform the essential functions of their job. If you need assistance accessing or reading this job posting or otherwise feel you need an accommodation during the application or hiring process, please contact View email address on click.appcast.io. Reasonable accommodations will be determined on a case-by-case basis.McDonald's provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to sex, sex stereotyping, pregnancy (including pregnancy, childbirth, and medical conditions related to pregnancy, childbirth, or breastfeeding), race, color, religion, ancestry or national origin, age, disability status, medical condition, marital status, sexual orientation, gender, gender identity, gender expression, transgender status, protected military or veteran status, citizenship status, genetic information, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.Nothing in this job posting or description should be construed as an offer or guarantee of employment.

Requsition ID: 3510