Senior, Business Data Analyst

Be part of an amazing story

Macy’s is more than just a store. We’re a story. One that’s captured the hearts and minds of America for more than 160 years. A story about innovations and traditions…about inspiring stores and irresistible products…about the excitement of the Macy’s 4th of July Fireworks, and the wonder of the Thanksgiving Day Parade. We’ve been part of memorable moments and milestones for countless customers and colleagues. Those stories are part of what makes this such a special place to work.

Job Overview

The Senior, CRM Solutions & Technology serves as a vital link between business users, technology teams, and other stakeholders, acting as the primary point of contact for developing robust solutions. Focused on quick resolution, root cause analysis, and process improvement, this role requires a detail-oriented approach to accurately capture and translate data requirements for both tactical and analytical needs. The Senior, CRM Solutions & Technology also validates and verifies working solutions to ensure effectiveness.

What You Will Do

• Participate in end-to-end marketing system solutions, including requirement gathering, planning, solution design, development, execution, and documentation.
• Collaborate with business stakeholders to understand challenges and define solution requirements.
• Translate high-level business needs into actionable, achievable solutions.
• Clearly document both business and technical requirements.
• Ensure developed solutions meet all business requirements.
• Conduct thorough data analysis to assess feasibility, identify limitations, and highlight key considerations.
• Identify opportunities for scalability, automation, and process improvement.
• Provide guidance on data conversion, mapping decisions, and data integrity.
• Develop effective data visualization solutions to address business questions.
• Understand and document data elements, constraints, flows, and sources supporting the business domain.
• Create and maintain documentation such as Source-to-Target Mapping, data dictionaries, data lineage, and other supporting artifacts.
• Perform detailed data validation to ensure quality and accuracy.
• Serve as a subject matter expert on macys.com business processes, data, marketing ecosystem, and external data sources.
• Communicate project status, milestones, and issues to management and stakeholders.
• Analyze data to identify key trends and patterns.
• Demonstrate expertise in CRM platforms such as Oracle and Adobe.
• Build and maintain strong relationships with vendors and external partners.
• Collaborate and communicate effectively with internal and external business partners, marketing analysts, IT developers, project and product managers, and all levels of the business community.
• Support day-to-day data and analytics challenges, including:
  • Researching and resolving data and system issues.
  • Prioritizing issue resolution and identifying data quality problems.
  • Interpreting complex physical and logical data models.
  • Conducting testing, validation, and user acceptance testing.
  • Delivering end-user training and support.
• Foster an environment of acceptance and respect that strengthens relationships, and ensures authentic connections with colleagues, customers, and communities
• In addition to the essential duties mentioned above, other duties may be assigned.

Skills You Will Need

SQL & Data Analysis: Proficiency in SQL, PL/SQL, and scripting languages (Shell, AWK, SED) for data manipulation.

ETL & Data Processing: Experience with ETL tools (e.g., Informatica, Talend, Apache NiFi) and data warehouses (Oracle, Hadoop, Snowflake, DB2).

CRM & Marketing Platforms: Strong knowledge of Oracle Responsys, Salesforce Marketing Cloud, Adobe Campaign, and Braze.

Analytics & Reporting: Experience with Adobe Analytics, Tableau, Power BI, and customer segmentation techniques.

Data Integration & APIs: Familiarity with RESTful APIs, MuleSoft, and Postman for system connectivity.

Cloud & Big Data: Exposure to AWS (Redshift, S3, Glue), Google BigQuery, and Azure Synapse Analytics.

Root Cause Analysis & Data Quality: Ability to investigate data discrepancies, optimize customer journeys, and ensure data integrity.

Marketing & Customer Insights: Understanding of campaign execution, segmentation, A/B testing, and cross-channel analytics.

Data Governance & Compliance: Experience with GDPR, CCPA, and secure handling of PII data.

Stakeholder Management: Effectively collaborates with marketing, IT, developers, vendors, and product managers.

Data Storytelling & Visualization: Ability to translate data insights into clear, actionable business recommendations.

Project Management & Documentation: Experience with JIRA, Confluence, Agile methodologies, and maintaining data dictionaries.

Problem-Solving & Automation: Identifies opportunities for scalability, automation, and process improvement.

Self-Starter & Adaptability: Manages multiple priorities in a fast-paced, evolving environment.

Who You Are

• Candidates with a Bachelor’s degree or equivalent work experience in a related field are encouraged to apply
  • 5-7 years of relevant experience. 
• 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
• Able to work a flexible schedule based on department and company needs

What We Can Offer You

Join a team where work is as rewarding as it is fun! We offer a dynamic, inclusive environment with competitive pay and benefits. Enjoy comprehensive health and wellness coverage and a 401(k) match to invest in your future. Prioritize your well-being with paid time off and eight paid holidays. Grow your career with continuous learning and leadership development. Plus, build community by joining one of our Colleague Resource Groups and make a difference through our volunteer opportunities.

Some additional benefits we offer include:

• Merchandise discounts
• Performance-based incentives
• Annual merit review
• Employee Assistance Program with mental health counseling and legal/financial advice
• Tuition reimbursement

 Access the full menu of benefits offerings here.

About Us

This is a great time to join Macy’s! Whether you’re helping a customer find the perfect gift, streamlining operations in one of our distribution centers, enhancing our online shopping experience, buying in-style and on-trend merchandise to outfit our customers, or designing a balloon for the Thanksgiving Day Parade, we offer unique opportunities to be part of some of the most memorable moments in people’s lives.

Join us and help write the next chapter in our story - 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.

DIGITAL00