Williams - Sonoma, Inc

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 and other Williams-Sonoma teams as needed.. 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.. Working knowledge of visualization tools such as Tableau, Domo, Power BI, Dataroma, etc.. 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.

business intelligence

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 9 Brands and International efforts. WSI manages all large digital programs in-house, and this role is critical in ensuring the accurate and timely execution of 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 and other Williams-Sonoma teams as needed. You will work closely with the Search, Social, Display, Affiliates, and CRM teams to build & optimize reports and 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 BI tool 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 and BI tool Criteria * BS/BA Required or equivalent work experience * 1-2 years digital marketing 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. 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 #LI-LG1 #LI-Hybrid We believe in People First We firmly believe that working in a culture focused on diversity, equity, and inclusion spurs innovation, creates healthy and high-performing teams, and delivers superior customer experiences. Our DEI initiatives prompt associate participation and engagement, aligning with our core vision to reflect the communities where we do business and put people first. Benefits Just for You Depending on your position and your location, here are a few highlights of what you might be eligible for: A generous discount on all Williams-Sonoma, Inc. 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 Your Journey in 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 and learning programs 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 $65,000 - $77,000. 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. #J-18808-Ljbffr

START NEW SEARCH