Senior Software Engineer

Business Analytics provides end-to-end analytical and application solutions to HR, Care Center, Corporate, Supply Chain, and Global business partners in WSI. The team consists of analysts and full-stack engineers that serve business partners, leadership, and external stakeholders. Leveraging both business acumen and technical skills, the team is involved in high impact and high visibility business enablement, analytical, and platform migration projects.About the RoleWilliams-Sonoma, Inc. is looking for a Senior Software Engineer with full-stack analytical and web application experience. This role is an instrumental resource to both business stakeholders and the team in identifying business problems, recommending solutions, driving projects, developing ETL pipelines and data warehouse jobs, creating and administering self-service dashboards and providing business insights. The role will help drive, implement, scale and rollout Business Analytics roadmap projects which includes but are not limited to tech modernization from SQL Server to Snowflake, creating business apps (ex: Merit app), and contributing to advanced analytics efforts (ex: Associate Opinion Survey).ResponsibilitiesDesign and develop SQL pipelines that are optimized for greater flexibility and reuse in the HR data warehouse.Support incoming and outgoing vendor feeds with PGP encryption.Support data feeds from Enterprise Data Warehouse used for retail reporting.Partner with ESRE/Stores team on retail associate-related data.Maintain and troubleshoot automated jobs that will ensure HR data warehouse stability.Create, update and monitor SSIS and python jobs.Build, manage and optimize the HR data warehouse pipelines, automated jobs, and integrations that enable downstream self-service dashboard and data feeds.Maintain and enhance critical store associate reporting such as Sales per Hour, Presidents Club, and Registry.Produce dashboards for HR and senior leadership for associate opinion surveys.Build/Enhance templates for annual total reward statements for domestic and global businesses.Develop data flows, reports, dashboards, and analysis through BI tools (Power BI, SSRS and SQL) with close attention to data accuracy and correct formatting.Work closely with business partners and stakeholders to understand business processes, gathering requirements, facilitating tech discussions, providing insights, and build data models that have data integrity, aligns with business needs, maintains SLAs and enables self-service analytics.Criteria5+ years of relevant experience in data engineering, data warehousing, and ETL pipelines.Bachelor’s degree in Computer Science, Engineering, or related field or equivalent work experience.Ability to create, maintain, and tune complex SQL queries in MS SQL and Snowflake. Azure experience is a plus.Experience with Web UI development using .NET. Console experience is a plus.Experience with automation scripting and building ETL pipelines utilizing SSIS, Power Automate, and Python. C#, SnowPipe or Azure Data Factory experience is a plus.Experience with Power BI dashboard development, user provisioning and workspace administration. Other BI tools such as SSRS or Crystal Reports is a plus.Expert database skills: querying, manipulating, summarizing, and analyzing data.Embraces an agile, growth and continuous learning mindset and possesses the entrepreneurial spirit to work independently with minimal guidance, handle multiple priorities, and drive projects with a sense of urgency.Strong data-driven, analytical, project management, organizational and efficiency skills with ability to solve problems while striking the right balance of tactical vs. strategic.Possess a strong work ethic, customer service, and commitment in delivering results to the organization.Outstanding verbal, written and presentation skills to both technical and non-technical audience at all levels within the organization.This role requires being onsite in the San Francisco office Monday through Thursday and Friday as optional in the office.Our Culture & ValuesWe 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 workThe contributions we make to our teams and the businessOur ability to lead and connectWe 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 FirstPutting 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:A generous discount on all WSI brandsA 401(k) plan and other investment opportunitiesPaid vacations, holidays, and time off to volunteerHealth benefits, dental and vision insurance, including same-sex domestic partner benefitsTax-free commuter benefitsA wellness program that supports your physical, financial and emotional healthIn-person and online learning opportunities through WSI UniversityCross-brand and cross-function career opportunitiesResources for self-developmentCareer development workshops, learning programs, and speaker seriesWSI will not commence an immigration case or "sponsor" an individual for this position at this time (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 $115,000 - $135,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.About Us

Our CompanyFounded in 1956, Williams-Sonoma, Inc. is the premier specialty retailer of high-quality products for the kitchen and home in the United States. Our family of brands are Williams Sonoma, Williams Sonoma Home, Pottery Barn, Pottery Barn teen, pottery barn kids, Rejuvenation, Mark & Graham, west elm, or Outward. These brands are among the best known and most respected in the industry. We offer beautifully-designed, stylish and functional products for every area of the home, including the kitchen, living room, bedroom, home office, closet, laundry room and even outdoor spaces. We've seen some big changes since our first brick-and-mortar store opened more than half of a century ago. What hasn't changed is our passion for high-quality products, functional design, outstanding customer service, and enhancing the lives of our customers and the communities where we operate. Today, we're a multi-brand, multi-channel, global enterprise supported by state-of-the-art technology and some of the most talented teams in retailing - and we're always looking for new energy and ideas.Job Info

Job Identification

13142Posting Date

10/18/2024, 05:42 PMLocations

100 North Point, San Francisco, CA, 94133, US

#J-18808-Ljbffr