The Macy'S Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Macy'S Business Intelligence Interview Guide

Getting ready for an Business Intelligence interview at Macy'S? The Macy'S Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Macy'S Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Macy'S.</li>
<li>Practice real Macy'S Business Intelligence interview questions.</li>
</ul>
Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Macy'S Business Intelligence interview.


Getting ready for an Business Intelligence interview at Macy'S? The Macy'S Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Macy'S Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Macy'S.
- Practice real Macy'S Business Intelligence interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Macy'S Business Intelligence interview.
        

Overview

Macy'S Business Intelligence Salary

We've gathered this data from parsing thousands of interview experiences sourced from members.

We've gathered this data from parsing thousands of interview experiences sourced from members.

Macy'S Business Intelligence Interview Process

We’re given a table of bank transactions with three columns, <code>user_id</code>, a deposit or withdrawal value (determined if the value is positive or negative), and <code>created_at</code> time for each transaction.

Write a query to get the total three-day rolling average for deposits by day.

Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout

Example:

Input:

<code>bank_transactions</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>transaction_value</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
Output:

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>dt</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>rolling_three_day</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>

Rolling Bank Transactions

Write a query to identify the manager with the biggest team size.

You may assume there is only one manager with the largest team size.

Example:

Input:

<code>employees</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>manager_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<code>managers</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>team</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
Output:

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>manager</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>team_size</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>

Manager Team Sizes

Let’s say you have a time series dataset grouped monthly for the past five years.

How would you find out if the difference between this month and the previous month was significant or not?

Significance Time Series

Macy'S Business Intelligence Interview Questions

Technical Product Manager Johns Creek, GA, United StatesFull time Schedule $96,300 - $160,600Annually* * based on job, location, and schedule JOB DESCRIPTIONBring Your Amazing Self to WorkAt Macy's, Inc. we're on a mission to create a brighter future with bold representation for all. This is our Mission Every One. We know that each person here is unique. So we respect and invest in each individual to create growth, pride, and satisfaction. If we are able to bring our whole selves to work, it translates into a more abundant and wider array of ideas and energy for all to benefit from. Our success will be built on amazing colleagues, working together. Job OverviewAs a Technical Product Manager, you will be the voice of the customer while having a deep understanding of the technical requirements for the successful delivery of your product. You will own the execution of the product road map in your area and collaborate cross-functionally with engineering, architects, data scientists, analytics, and business partners throughout the product lifecycle, from ideation to execution. You will work in an agile environment with a focus on continuous improvement where ideas and feedback are encouraged. You will be empowered to make decisions and contribute in a meaningful and impactful way by balancing the business needs against technical feasibility and complexity. What You Will Do <ul><li>Develop, drive and maintain product roadmap that align business goals against technical requirements based on product strategy by delivering on milestones driven by OKRs.</li><li>Drive product discovery for defined customer problems, drawing insights and ideas that impact the product roadmap and individual feature development.</li><li>Gather customer needs and synthesize them into technical requirements.</li><li>Communicate product vision, roadmap, and progress to partners across Macy’s.</li><li>Continually maintain a healthy backlog of groomed, insight-driven user stories. </li><li>Work to align internal teams, including developers, engineers, Q.A, and operations. </li><li>Participate in engineering and analytical discussions around technology decisions and strategy related to product features that drive growth and technical optimization.</li><li>Understand data pipelines, automated systems, testing frameworks, and architectural diagrams.</li><li>Recognize, evaluate, and tackle risk.</li><li>Work with the Engineering team to prioritize and manage delivery features are on time with high quality.</li><li>Partner with engineering scrum teams and engineering leads to refine technical requirements.</li><li>Define success criteria for testing and product acceptance.</li><li>Own the creation and maintenance of product documentation.</li><li>Collaborate to conduct market research to look for gaps and conduct capability analyses regularly.</li></ul> Skills You Will Need<ul><li>Product Management: Build and execute roadmaps, ability gather and capture both business and technical requirements, and solid understanding of modern technologies and architecture patterns.</li><li>Communication: Strong communication, presentation, and negotiation skills.</li><li>Relationships: Demonstrates an energetic and positive attitude with strong interpersonal skills.</li><li>Collaboration: Customer-centric and experienced with successful cross-functional collaboration.</li><li>Analytical and Problem-Solving Skills: Attention to detail, strong documentation, organization, time management, and problem-solving abilities.</li></ul> Who You Are<ul><li>2+ years of product management experience, focusing on driving growth and engagement preferably with a focus on collaborative Microsoft Technology solutions such as Office 365, SharePoint, Viva, and Teams; 3+ years overall technical development experience.</li><li>SCRUM/Safe/Agile experience required.</li><li>Proven record in delivering end-to-end product solutions.</li><li>Experience working in an Agile environment, including defining and documenting product requirements, user stories, and acceptance criteria, is a plus.</li><li>Passionate about building great products and solving customer and business problems.</li><li>You love products and the art of the product management culture.</li><li>You are looking for a place to apply your human-focused inventor experience and learn from a team of other product practitioners.</li><li>Possesses high levels of ownership, innovation, and simplification with a strong bias for action.</li><li>Dedicated to fulfilling ideals of diversity, inclusion, and respect that Macy’s aspires to achieve every day in every way.</li><li>Regularly required to sit, talk, hear; use hands/fingers to touch, handle, and feel. Occasionally required to move about the workplace and reach with hands and arms. Requires close vision.</li><li>Able to work a flexible schedule based on department and company needs.</li></ul> What We Can Offer You<ul><li>An inclusive, challenging, and refreshingly fun work environment.</li><li>Competitive pay and benefits rooted in principles of equity.</li><li>Performance incentives and annual merit review.</li><li>Merchandise discounts.</li><li>Health and Wellness Benefits across medical, dental, vision, and additional insurance.</li><li>Retirement Savings Plan with 401k match opportunity.</li><li>Employee Assistance Program (mental health counseling and legal/financial advice).</li><li>Resources for continuous learning, career growth, and leadership development</li><li>8 paid holidays.</li><li>Paid Time Off (first year prorated depending on start date).</li><li>Tuition reimbursement program.</li><li>Guild education benefit funds 100% of tuition, books, and fees in designated programs.</li><li>Colleague Resource Groups (CRGs) and give-back/volunteer opportunities.</li><li>Empowerment and autonomy to perform impactful work with tangible results.</li></ul> About Macy’sNow is an exciting time for a Macy's career as we continue to focus on creating exciting and memorable experiences for every Macy's customer, whether their journey starts online or in the store. Our opportunities in Sales, Merchandise, Operations, Customer Service, Warehouse, Marketing, and other areas let you express your creativity and commitment to excellence, grow your career and make a difference to your Macy's colleagues and customers.Bring your creativity, energy, and ideas to the Macy's team – Apply Today!This job description is not all-inclusive. Macy's, Inc. reserves the right to amend this job description at any time. Macy's, Inc. is an Equal Opportunity Employer, committed to a diverse and inclusive work environment. TECH00 This position may be eligible for performance-based incentives/bonuses. Benefits include 401k, medical/vision/dental/life/disability insurance options, PTO accruals, Holidays, and more. Eligibility requirements may apply based on location, job level, classification, and length of employment. To view additional benefits information for this role, please visit <a>https://bit.ly/3Sy3fOs</a>

Job Description Bring Your Amazing Self to Work At Macy's, Inc. we're on a mission to create a brighter future with bold representation for all. This is our Mission Every One. We know that each person here is unique. So we respect and invest in each individual to create growth, pride, and satisfaction. If we are able to bring our whole selves to work, it translates into a more abundant and wider array of ideas and energy for all to benefit from. Our success will be built on amazing colleagues, working together. Job Overview The Senior Software Engineer position reports to the Manager, Software Engineering and is responsible for developing and supporting applications leveraging their expertise and knowledge of multiple systems/customer areas to build a robust, scalable, and reliable platform. If you're passionate about building highly scalable architecture and are motivated to make an impact in creating robust software used across the organization, come join us. You will help shape the vision and architecture of Macy's next-generation incredible growth. You will be part of an experienced engineering team and work with passionate leaders on challenging topics. What You Will Do <ul> <li>Perform coding/configuration, testing, implementation, and documentation for developed solutions, including design specifications.</li> <li>Conduct applications programming activities, encompassing coding, testing, debugging, documenting, maintaining, and modifying applications programs.</li> <li>Demonstrate the ability to extract, analyze, and report data, with a strong attention to detail when identifying data relationships, trends, and anomalies.</li> <li>Consider the long-term impacts of key design decisions and handle failure scenarios effectively.</li> <li>Stay updated on industry trends and assess the suitability of new software tools for platform development.</li> <li>Act as a coach and mentor to junior developers, including delegating and managing tasks as needed.</li> <li>Commit to meeting overall deliverables with customers and/or management.</li> <li>Maintain consistent attendance and punctuality.</li> <li>Perform any other duties as assigned.</li></ul> Skills You Will Need Technical Expertise: In-depth experience with SQL and NoSQL data stores, coding applications using Java or Python, building scalable web services, ESB, and event/stream processing. Technology Proficiency: Deep understanding of various technologies, including Hadoop, Spark, Kafka, Elasticsearch, stream processing, RDBMS, and NoSQL databases. Mentorship and Leadership: Act as a coach and mentor to junior developers, delegating and managing tasks as necessary. Communication Skills: Ability to effectively communicate technical information and issues, as well as provide solutions to all levels of the business. Project Management: Proficiency in juggling multiple projects, prioritizing objectives, and communicating timelines to team members. Ownership Mentality: Desire and ability to take ownership of products/projects. Application Development Methodology: Expert understanding of all application development processes, serving as a resource to others. System Maintenance: Expertise in existing applications supporting the business area, ensuring systems perform up to requirements. Who You Are <ul> <li>Dedicated to fulfilling ideals of diversity, inclusion, and respect that Macy's aspires to achieve every day in every way.</li> <li>Candidates with a bachelor's degree or equivalent work experience in a related field are encouraged to apply.</li> <li>Regularly required to sit, talk, hear; use hands/fingers to touch, handle, and feel. Occasionally required to move about the workplace and reach with hands and arms. Requires close vision.</li> <li>Able to work a flexible schedule based on department and company needs. </li></ul> What We Can Offer You <ul> <li>An inclusive, challenging, and refreshingly fun work environment</li> <li>Competitive pay and benefits rooted in principles of equity</li> <li>Performance incentives and annual merit review</li> <li>Merchandise discounts</li> <li>Health and Wellness Benefits across medical, dental, vision, and additional insurance</li> <li>Retirement Savings Plan with 401k match opportunity</li> <li>Employee Assistance Program (mental health counseling and legal/financial advice)</li> <li>Resources for continuous learning, career growth, and leadership development</li> <li>8 paid holidays</li> <li>Paid Time Off (first year prorated depending on start date)</li> <li>Tuition reimbursement program</li> <li>Guild education benefit funds 100% of tuition, books, and fees in designated programs</li> <li>Colleague Resource Groups (CRGs) and give-back/volunteer opportunities</li> <li>Empowerment and autonomy to perform impactful work with tangible results</li></ul> About Macy's Now is an exciting time for a Macy's career as we continue to focus on creating exciting and memorable experiences for every Macy's customer, whether their journey starts online or in the store. Our opportunities in Sales, Merchandise, Operations, Customer Service, Warehouse, Marketing, and other areas let you express your creativity and commitment to excellence, grow your career and make a difference to your Macy's colleagues and customers. Bring your creativity, energy, and ideas to the Macy's team - Apply Today! TECH00

Job Description Bring Your Amazing Self to Work At Macy's, Inc. we're on a mission to create a brighter future with bold representation for all. This is our Mission Every One. We know that each person here is unique. So we respect and invest in each individual to create growth, pride, and satisfaction. If we are able to bring our whole selves to work, it translates into a more abundant and wider array of ideas and energy for all to benefit from. Our success will be built on amazing colleagues, working together. Job Overview The Lead, Software Engineer at Macy's Technology reports to the Tech Manager, Engineering and plays a pivotal role in leading the technical direction and development of enterprise solutions. As a lead engineer, they serve as the technical anchor for the engineering team supporting a product. They create, own, and are responsible for the application architecture that best serves the product in its functional and non-functional needs. They identify and drive architectural changes to accelerate feature development or improve the quality of service. Possessing deep and broad engineering skills, they are capable of independently establishing an architecture, yet they choose to influence a wider team by acting as a "force multiplier". Job duties may change at any time due to business needs. Perform other duties as assigned. What You Will Do <ul> <li>Design and implement robust, scalable, and secure distributed software systems.</li> <li>Develop and review technical design documentation, and provide leadership through constructive code reviews and design guidance to team members.</li> <li>Collaborate effectively within a team of passionate developers in a fast-paced, outcome-oriented environment.</li> <li>Lead a technical team by setting an example and nurturing the growth of junior team members.</li> <li>Maintain regular, dependable attendance and punctuality.</li></ul> Skills You Will Need Software Architecture: Proficiency in designing and implementing robust, scalable, and secure distributed software systems. Technical Leadership: Ability to develop and review technical design documentation and provide leadership through constructive code reviews and design guidance to team members. Team Collaboration: Demonstrated effectiveness in collaborating within a team of passionate developers in a fast-paced, outcome-oriented environment. Team Leadership and Mentorship: Experience leading a technical team by setting an example and nurturing the growth of junior team members. Technical Proficiency: In-depth knowledge of Java and proficiency in mastering other tools of the trade, including various modern programming languages and experience with open-source web and data technologies such as Spring Boot, NoSQL, Microservices, and Cloud services (with a preference for Google Cloud Platform). Cloud-Native Application Development: Minimum of 3+ years of experience in building cloud-native applications in private and public cloud environments, with a preference for experience in Google Cloud Platform. Open Source Technologies: At least 4+ years of experience with open-source technologies in a high-volume distributed environment. DevOps Practices: Experience working in a DevOps-oriented culture that prioritizes continuous integration and continuous deployment. Retail Technologies: Experience in multi-channel retail technologies is preferred. Communication Skills: Ability to effectively share technical information and communicate technical issues and solutions to all levels of the business. Project Management: Ability to juggle multiple projects, identify primary and secondary objectives, prioritize time, and communicate timelines to team members effectively. Ownership Mentality: Demonstrated ability and desire to take product/project ownership. Who You Are <ul> <li>Dedicated to fulfilling ideals of diversity, inclusion, and respect that Macy's aspires to achieve every day in every way.</li> <li>Candidates with a bachelor's degree or equivalent work experience in a related field are encouraged to apply. MA/MS and BA/BS in Computer Science, Information Technology, or related field preferred. </li> <li>8+ years of experience in software development and with high-volume enterprise systems.</li> <li>Regularly required to sit, talk, hear; use hands/fingers to touch, handle, and feel. Occasionally required to move about the workplace and reach with hands and arms. Requires close vision.</li> <li>Able to work a flexible schedule based on department and company needs. </li></ul> What We Can Offer You <ul> <li>An inclusive, challenging, and refreshingly fun work environment</li> <li>Competitive pay and benefits rooted in principles of equity</li> <li>Performance incentives and annual merit review</li> <li>Merchandise discounts</li> <li>Health and Wellness Benefits across medical, dental, vision, and additional insurance</li> <li>Retirement Savings Plan with 401k match opportunity</li> <li>Employee Assistance Program (mental health counseling and legal/financial advice)</li> <li>Resources for continuous learning, career growth, and leadership development</li> <li>8 paid holidays</li> <li>Paid Time Off (first year prorated depending on start date)</li> <li>Tuition reimbursement program</li> <li>Guild education benefit funds 100% of tuition, books, and fees in designated programs</li> <li>Colleague Resource Groups (CRGs) and give-back/volunteer opportunities</li> <li>Empowerment and autonomy to perform impactful work with tangible results</li></ul> About Macy's Now is an exciting time for a Macy's career as we continue to focus on creating exciting and memorable experiences for every Macy's customer, whether their journey starts online or in the store. Our opportunities in Sales, Merchandise, Operations, Customer Service, Warehouse, Marketing, and other areas let you express your creativity and commitment to excellence, grow your career and make a difference to your Macy's colleagues and customers. Bring your creativity, energy, and ideas to the Macy's team - Apply Today! TECH00

Macy'S Business Intelligence Interview Guide

Overview

Macy'S Business Intelligence Salary

Macy'S Business Intelligence Interview Process

Macy'S Business Intelligence Interview Questions

Macy'S Business Intelligence Jobs