Marketing Business Intelligence Analyst

About the Team

You will be part of the Digital Marketing team responsible for developing strategies and optimizing William-Sonoma, Inc.'s digital spend across all 8 Brands and International efforts. WSI manages all large digital programs in-house, and this role is critical in ensuring the accurate and timely execution for the display channel and reporting across all digital programs.

About the Role 

Williams-Sonoma, Inc. is looking for a Marketing BI (Business Intelligence) Analyst who is responsible for processing data, developing dashboards, and extracting actionable insights for the Digital Marketing teams. You will work closely with the Search, Social, Display, Affiliates, and CRM teams to build & optimize reports, & drive informed / actionable insights to help all teams optimize their campaigns. The ability to recognize and understand trends, collaborate with cross-functional teams, and solve complex problems within the digital marketing landscape are key to success within this role.

Responsibilities 

• Collaborate with individual digital teams to understand reporting needs and translate strategic business questions into resource/data requirements.
• Design, create, and maintain reporting cards within Domo that will be viewed by all leadership, digital teams, and brand partners
• Write Extract-Transform-Load (ETL) and SQL jobs to build out desired outputs to visualize on.
• Build out any new connectors needed to bring in new reporting, connections varying from SFTP, API, Email, or custom connection
• Stay apprised of current and new functionality and/or metrics of digital platforms 

Criteria

• BA/BS Degree in Marketing, Business, or related field or equivalent experience
• Intermediate to Advanced MS Excel skills (Pivot tables, VLOOKUP, Conditional formatting); data blending tools such as Alteryx or domo a plus.
• Prior experience updating and creating reporting dashboards within a BI tool like Domo, Tableau, or Power BI.
• Knowledge of pixel technology such as HTML or JavaScript; familiarity with dynamic macro's a plus
• Well-organized, detail oriented and able to quickly react to changing priorities.
• Excellent analytical, technical, written, and verbal communication skills with the ability to synthesize and state detail to various levels of the organization.
• Team player with an entrepreneurial mindset.
• Experience writing SQL or other programming languages.
• This role requires being onsite in the San Francisco office Monday through Thursday and Friday as optional in the office 

Technical Competencies required:

• Experience with SQL and ETL dataflows
• Working knowledge of visualization tools such as Tableau, Domo, Power BI, Dataroma, etc.
• Strong MS Excel skills and analytical ability
• Knowledge of site tagging using Google Tag Manager or Tealium

Our Culture & Values 

We believe that taking care of our people is vital to our success and we strive to offer equitable and transparent practices for all. We prioritize connection, growth, and wellbeing. Our associates are encouraged to bring their authentic selves to work, so they can be their best and achieve their personal and professional goals.   We make inclusivity a cornerstone of our culture by welcoming associates with diverse cultures and backgrounds and celebrating them, together.  We nurture an open, inclusive environment for all. Our differences—whatever they may be—are valued, explored, and appreciated. Together, we’re creating a more just and inclusive company culture where the only criteria for advancement are: 

• The quality of our work
• The contributions we make to our teams and the business
• Our ability to lead and connect

We firmly believe that working in a culture focused on diversity, equity, and inclusion (DEI) spurs innovation, creates healthy and high-performing teams, and delivers superior customer experiences. Outside of WSI, we recognize the importance of playing a part in our communities through partnerships, collaborations, and commitments to a more just and inclusive world.

People First 

Putting People First means investing in overall well-being and opportunities to grow and advance within the organization. Depending on the position and location, here are a few highlights of what benefits may be available:
 

Benefits

• A generous discount on all WSI brands
• A 401(k) plan and other investment opportunities
• Paid vacations, holidays, and time off to volunteer
• Health benefits, dental and vision insurance, including same-sex domestic partner benefits
• Tax-free commuter benefits
• A wellness program that supports your physical, financial and emotional health

Continued Learning

• In-person and online learning opportunities through WSI University
• Cross-brand and cross-function career opportunities 
• Resources for self-development
• Advisor (Mentor) program
• Career development workshops, learning programs, and speaker series 

WSI will not now or in the future commence an immigration case or "sponsor" an individual for this position (for example, H-1B or other employment-based immigration).

This role is not eligible for relocation assistance.

Williams-Sonoma, Inc. is an Equal Opportunity Employer. Williams-Sonoma, Inc. will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of the San Francisco Fair Chance Ordinance, or other applicable state or local laws and ordinances.

The expected starting pay range for this position is $75,000 - $85,000 annually. Applicable pay ranges may differ across markets. Actual pay will be determined based on experience and other job-related factors permitted by law. In addition to competitive pay, compensation may include a variety of other components like benefits, paid time off, merit, and bonus opportunities.