Williams Sonoma
Senior Software Engineer
Williams Sonoma, San Francisco, California, United States, 94199
About the Team
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 Role
Williams-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).
Responsibilities
Design 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 building data models that have data integrity, align with business needs, maintain SLAs and enable self-service analytics.
Criteria
5+ 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 & 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.
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:
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 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. Actual pay will be determined based on experience and other job-related factors permitted by law.
#J-18808-Ljbffr
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 Role
Williams-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).
Responsibilities
Design 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 building data models that have data integrity, align with business needs, maintain SLAs and enable self-service analytics.
Criteria
5+ 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 & 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.
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:
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 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. Actual pay will be determined based on experience and other job-related factors permitted by law.
#J-18808-Ljbffr