Business Analyst, Analytics Systems (

San Francisco - California

Date Posted: Jan. 12, 2018

Requisition ID: MAC08055


Job Overview:


The Business Analyst enables Macys marketing with data and data management solutions. As a member of the marketing systems team, the Business Analyst acts as a liaison between the business users and the technology teams to advocate marketing data, data marts and systems/applications. This position enables marketing solutions by assuring quality and availability of associated data. The Business Analysts function is detail intensive, requiring the accurate capture and translation of data requirements (both tactical and analytical needs) and validation/verification of the working solution.


Essential Functions:

  • Participate in end-to-end documentation of data and reporting requirements for marketing systems projects, including:
    • Identify source systems and data required to meet user’s current and potential future needs.
    • Identify source and target mappings.
    • Define and validate transformation logic required to support information requirements.
    • Ability to identify effective data visualization solutions to address business questions.
    • Participate in solution development process to ensure solution addresses all business requirements
    • Identify and implement reporting solutions, using automation capabilities when appropriate.
    • Define acceptance criteria for each project.
    • Establish and coordinate user acceptance testing and plan.
    • Conduct testing and validation.
    • Deliver end-user training.
    • Present status, milestones and issues to management and other stakeholders related to assigned projects. 
    • Develop the process and supporting artifacts to organize information management into data dictionary, data lineage, and other supporting documents.
  • Maintain a thorough understanding of analytics, data repositories, data models and reporting systems, including:
    • Understand and document the underlying data elements, constraints, flows and sources supporting the business domain.
    • SME (subject matter expert) on business processes, data, marketing eco-system as well as data received from other sources.
    • Participate in meetings with all interested groups to evaluate potential changes to the marketing data and processes.
    • With understanding of marketing system and data needs, proactively identify gaps in data coverage and identify required enhancements and opportunities for improvement.
    • Work with customers to bring clarity to translate high-level requirements into actionable and achievable products.
  • Help analyze and solve day-to-day challenges with data and analytics/reporting systems, including:
    • Research data and systems issues.
    • Resolve and/or prioritize issue resolution.
    • Pro-actively identify data quality problems and support solution identification.
    • Interpret highly complex physical and logical data models.
    • Ability to operate as a project coordinator utilizing a cross functional/matrix team.
    • Perform other job-related duties and activities as requested.



  • BA/BS Degree, advanced degree preferred or equivalent work experience.
  • 6+ years of business analyst experience.
  • 6+ years working experience with databases.
  • 2+ years SQL. 
  • Comfortable using systems/technology including Hadoop, SAS, Coremetrics, and Tableau.

Communication Skills

  • Strong communication skills and ability to communicate effectively with senior management, architects, data modelers, data visualization experts, and developers.

Reasoning Ability

  • Comfortable working independently to achieve successful results with minimal guidance.
  • Confidently handle multiple projects simultaneously and under deadlines.
  • Strong prioritization and organizational skills.
  • Possess an analytical mindset and demonstrable critical thinking skills.

Other Skills

  • Extremely detail oriented.

Company Profile:

As the fastest growing part of Macy's Inc. business, is achieving record sales and broadening our workforce. With offices in New York and San Francisco, is the best of all worlds. The entrepreneurial thinking of a Web business complements the stability and support of a national brand. Creativity and ingenuity partner with business acumen and tech savvy to build a unique business poised for continued growth. Employees at have long term opportunities and are encouraged to utilize their Supervisors and Human Resources for cross-functional movement to further their careers. At we are committed to giving back to the community by partnering with local charitable organizations.  By skillfully combining the power of the Internet with the best in retailing, is reaching new heights.


This job description is not all inclusive. Macy’s Inc. reserves the right to amend this job description at anytime. Macy's Inc. is an Equal Opportunity Employer, committed to a diverse and inclusive work environment.                                                                                                                          

Macy's Inc., including Macy's and Bloomingdale's, will consider for employment qualified applicants with criminal histories in a manner consistent with SF PC Art. 49 and LA MC ch. XVIII Art. 9.