Oh Snap!
This job is no longer active - but you can still view the details below.

Senior Business Technical Analyst

Job Description


The MCD IT Business Intelligence Operations team has an exciting opportunity for a Business Analyst / Business Technical Analyst.   With supervision this position defines the business requirements and creates process and data models for technology solutions that meet the business needs.  Bridges the gap between the business customer and the technology solution providers by translating business needs to technical solutions throughout the lifecycle of the product.  Coordinates and/or executes plans to ensure that technical solutions meet the needs of the business. Key customers include users of the I/S solution, the project development team and project sponsors.




The ideal candidate will have extensive experience in a data warehouse environment facilitating requirements gathering sessions, documenting requirements, analyzing and evaluating possible solutions to meet requirements. Experience in managing QA processes including creating test strategy and test plan documents as well as executing tests and working with external QA vendors. The candidate must be a highly organized self-starter who thrives in a fast-paced and rapidly changing environment. 


Minimum Requirements


Required Experience


·Minimum of 3-6 years working in a data warehouse environment


·Bachelor’s degree - Business or IT


·Ability to work on multiple simultaneous projects


·Excellent communication skills


·Must have the ability to work independently and within a team environment.


·Experience working in a client-facing role with the ability to build strong relationships


·Ability to read, develop and test advanced SQL statements


·Data modeling experience


·Experience preparing advanced report designs


·Strong problem-solving skills and ability to focus on details as well as the big picture


·Experience identifying project tasks and providing estimates for those tasks


·Experience in executing training strategies


·Demonstrated ability to adhere and promote standard business analyst tools, procedures and SDLC best practices




Preferred Skills and Experience:






·Ability to grasp technical concepts quickly.


·Ability to adapt to and understand new products and applications


·Ability to understand & analyze complex data concepts and calculations


·Strong problem-solving skills and ability to focus on details as well as the big picture


·Excellent verbal and written communication skills and the ability to communicate technical information to non-technical audiences






·Experience working in a data warehouse environment


·Strong background in writing SQL code


·Experienced in working with data models to understand data relationships and to aid in creating SQL queries


·Experienced in working with business users to gather and document requirements


·Ability to translate business requirements into technical specifications


·Experienced in writing test plans and scripts


·Highly experienced in Excel






·Experience working in a data warehouse environment


·Strong background in writing SQL code


·Experience in working with data models to understand data relationships and to aid in creating SQL queries


·Experience in writing test plans and scripts


·Experience in executing test scripts, including documentation of test results


·Experience in defect management/resolution, including documentation of defects and regression testing


·Highly experienced in Excel


Read Full Job Description

Technology we use

  • Engineering
  • Product
    • .NETLanguages
    • C#Languages
    • C++Languages
    • JavaLanguages
    • JavascriptLanguages
    • SqlLanguages
    • SwiftLanguages
    • CustomLanguages
    • jQuery UILibraries
    • ReactLibraries
    • CustomLibraries
    • AngularJSFrameworks
    • ASP.NETFrameworks
    • ExpressFrameworks
    • HadoopFrameworks
    • Node.jsFrameworks
    • SparkFrameworks
    • SpringFrameworks
    • TensorFlowFrameworks
    • CustomFrameworks
    • CassandraDatabases
    • HBaseDatabases
    • Microsoft SQL ServerDatabases
    • OracleDatabases
    • RedisDatabases
    • SQLiteDatabases
    • TeradataDatabases
    • CustomDatabases
    • CustomAnalytics
    • CustomDesign
    • Custom Management


In the heart of the West Loop, a vibrant and rapidly growing tech neighborhood. Our new HQ is accessible by all forms of transportation.

An Insider's view of McDonald's Technology

What’s the vibe like in the office?

The entrepreneurial spirit at McDonald’s is noticeable at all levels. People inspire; people are nimble; people are team-driven; people are focused on evolving and improving. When you walk around the space, you can feel the energy that comes from collaboration and problem-solving. I am motivated to push myself every day.


Product Manager, Global Mobile App

What kinds of technical challenges do you and your team face?

We are providing insights and real time event data for decision making and marketing activation at a scale very few other companies can compare to. We are moving from a 1 to many CRM strategy to a 1 to 1 contextual and personalized experience for our customers and are watching our data drive the direction of feature development within McDonald’s.


Sr. Manager, Digital Analytics

What does career growth look like on your team?

Working at a company of this Global scale has stretched my skills like never before. The sheer number and variety of customers using the product I work on every day is both challenging and exhilarating; developing my skillset in a way that would be hard to match elsewhere


Sr. Product Manager, Kiosk

What's the biggest problem your team is solving?

McDonald’s has a few consistent challenges that we’re always solving for - scale and flexibility are critical. Every piece of technology that we build has to be scalable to 30,000+ restaurants! The second challenge is flexibility –we need to provide a consistent and reliable experience, and every restaurant is unique!


Product Capabilities and Innovation

What are McDonald's Technology Perks + Benefits

Health Insurance & Wellness Benefits
Disability Insurance
McDonald's provides both short and long term disability benefits at no cost to you.
Dental Benefits
McDonald’s Dental Plans allows you to see the dentist of your choice and provides coverage for preventive, basic, major and orthodontic care.
Vision Benefits
Health Insurance Benefits
Life Insurance
Onsite Gym
We have an 8000 square foot gym on our 9th floor with best-in-class equipment, classes, personal training, and magnificent views of the city!
Retirement & Stock Options Benefits
401(K) Matching
Once you’re eligible for the company match, McDonald’s will match your contributions with $1 for each $1 you contribute up to a maximum of 6% of your annual pay, up to IRS limits.
Performance Bonus
Child Care & Parental Leave Benefits
Child Care Benefits
We offer Dependent Care Spending Accounts where you fund the accounts with pre-tax contributions.
Generous Parental Leave
We offer a variety of parental leave: paid parental leave, maternity leave, adoption leave, and unpaid paternal leave.
Flexible Work Schedule
We offer summer hours (short Fridays) from May through the end of September!
Family Medical Leave
Adoption Assistance
Vacation & Time Off Benefits
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
Happy Hours
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Diversity Program
More Jobs at McDonald's Technology21 open jobs
All Jobs
Data + Analytics
Design + UX
Dev + Engineer
Project Mgmt
Data + Analytics
Data + Analytics
Project Mgmt
Project Mgmt
Data + Analytics
Design + UX
Project Mgmt
Project Mgmt
Data + Analytics