Job Description

Senior Business Intelligence Engineer

About Williams-Sonoma, Inc.

Founded in 1956 and headquartered in San Francisco, California, Williams-Sonoma, Inc. is a Fortune 500, digital first, multi-channel specialty retailer. Our company vision is to own the home, and the places where our customers work, stay, and play. We bring the latest home furnishing trends to life for customers through the individual lenses of our ten distinct brands, each serving different life stages and rooms of the home and beyond. Our brands include Williams Sonoma, Williams Sonoma Home, Pottery Barn, Pottery Barn Kids, Pottery Barn Teen, West Elm, Rejuvenation, Mark & Graham, GreenRow, and Dormify. We are committed to sustainability, continuously working to protect our planet, while building an open and collaborative culture across our organization.

With more than 500 retail stores globally and multiple international franchise operations, technology is a core driver of our business strategy. We build and operate in-house platforms powering e-commerce, supply chain, merchandising, analytics, and customer experience ecosystems worldwide.

Engineers at the Williams-Sonoma India Technology Center build and scale digital commerce platforms that power these global brands, serving millions of customers worldwide.

Role Overview

We are looking for a Senior Business Intelligence Engineer who can turn complex data into simple and meaningful business insights.

Location: Pune, India

You will work closely with business teams, Product Managers, Data Engineers, Data Scientists, and other technology teams to understand business needs and build scalable reporting and analytics solutions.

The role requires strong hands-on experience in Power BI, SQL, Snowflake, and MicroStrategy, along with a good understanding of Databricks and modern data platforms.

We are also looking for someone who understands how Business Intelligence is evolving, especially how strong semantic models can support AI-assisted and natural-language analytics.

Impact of the Role

• Understand the business meaning behind the data, ask the right questions, and build reporting solutions that business teams can trust and easily use.
• Take ownership, solve complex reporting problems, work directly with business and engineering teams, and help improve the overall BI platform.
• Contribute to how business users will interact with enterprise data in the future as Business Intelligence continues to move toward semantic models, conversational analytics, and AI-assisted reporting.

Technology Platforms You Will Work On

• Power BI, DAX, Power Query, Power BI Copilot, and Microsoft Fabric
• MicroStrategy, Intelligent Cubes, REST APIs, SDK-based integrations, and System Manager
• SQL, Snowflake, Azure Databricks, and Delta Lake
• Azure Data Factory (ADF), Azure Blob Storage, and Azure DevOps
• Python, PySpark, and Apache Spark
• Apache Kafka and other streaming technologies
• AI agents, Large Language Models (LLMs), Retrieval-Augmented Generation (RAG), and natural-language analytics
• CI/CD pipelines and Dev, QA, and Production environments

Key Responsibilities

• Design and develop scalable Power BI dashboards, reports, and analytical solutions.
• Build and maintain business semantic models with clear measures, dimensions, relationships, KPIs, and business definitions.
• Develop and maintain MicroStrategy reports, dashboards, scorecards, and reporting solutions.
• Design and work with MicroStrategy schema objects such as attributes, facts, hierarchies, relationships, metrics, filters, prompts, consolidations, and custom groups.
• Work with MicroStrategy projects, Intelligent Cubes, caching, aggregate tables, and VLDB settings to improve reporting performance.
• Write and optimize complex SQL queries across large enterprise datasets.
• Work with Snowflake, Azure Databricks, Delta Lake, and other enterprise data platforms.
• Understand business requirements and convert them into clear data models, semantic models, reports, and analytical solutions.
• Build solutions using good data modeling practices, including fact and dimension models, star schemas, and snowflake schemas.
• Improve dashboard, SQL, semantic model, and reporting performance.
• Work with business teams to define and maintain consistent business metrics, KPIs, definitions, and calculation logic.
• Understand how AI agents and natural-language analytics can work on top of a governed business semantic layer.
• Add meaningful metadata, descriptions, synonyms, relationships, and business context so AI-based analytics can interpret business questions correctly.
• Work with Data Engineering and AI teams to ensure AI-assisted analytics uses trusted and governed enterprise data.
• Ensure data quality, security, access control, lineage, and consistency across reporting solutions.
• Troubleshoot production issues, perform root cause analysis, and provide long-term fixes.
• Support deployments and production releases across reporting platforms.
• Review solutions developed by other engineers and help maintain good engineering standards.
• Mentor junior engineers and share knowledge and best practices across the team.
• Take ownership of solutions from requirement understanding through design, development, testing, deployment, and production support.

Qualifications

• 5+ years of experience in Business Intelligence, Analytics Engineering, Data Engineering, or a similar role.
• Strong hands-on experience with Power BI, including semantic models, DAX, Power Query, and performance optimization.
• Strong hands-on experience with MicroStrategy reporting and dashboard development.
• Good understanding of MicroStrategy schema objects, metrics, filters, prompts, Intelligent Cubes, caching, and performance tuning.
• Strong SQL skills with experience working with large enterprise datasets.
• Good hands-on experience with Snowflake.
• Experience working with Azure Databricks / Delta Lake or similar modern data platforms.
• Strong understanding of data warehousing and dimensional modeling, including fact tables, dimensions, star schemas, and snowflake schemas.
• Good understanding of semantic layers, business measures, KPIs, metadata, and relationships.
• Experience with report and query performance optimization.
• Understanding of data quality, governance, security, lineage, and Role-Based Access Control (RBAC).
• Ability to troubleshoot complex reporting and data issues independently.
• Ability to work directly with business users and translate business questions into technical solutions.
• Good communication and problem-solving skills.
• Bachelor's degree in Computer Science, Engineering, Information Technology, or equivalent experience.

Good to Have

• Experience with Azure Data Factory (ADF) for building simple ETL/ELT and reporting pipelines.
• Ability to use ADF to move data from source systems to Azure Blob Storage or other cloud storage.
• Understanding of ADF linked services, parameters, variables, and environment-specific configurations.
• Exposure to deploying ADF resources across Dev, QA, and Production using Azure DevOps and CI/CD.
• Experience with Microsoft Fabric and Power BI Copilot.
• Basic understanding of how LLMs, RAG, and AI agents can work with enterprise data and business semantic models.
• Experience with Python, PySpark or Apache Spark.
• Exposure to Apache Kafka or other streaming technologies.
• Experience with MicroStrategy REST APIs or SDK-based integrations.
• Exposure to MicroStrategy administration or System Manager activities.
• Experience working with retail, e-commerce, supply chain, merchandising, customer, or finance data would be an advantage.

Why Join Williams-Sonoma India Technology Center

• Our people first and performance driven culture means that we provide opportunities to grow and build a career and invest in the well-being of our associates, including comprehensive benefits to support you and your family.
• Scale and innovation of a Fortune 500 company combined with a high-ownership that empowers engineers to make real impact.
• Build and operate large-scale digital commerce platforms serving millions of customers worldwide, working on systems that run at global scale.
• Continuous learning environment with opportunities to work on cutting-edge technologies, AI-driven solutions, and large-scale engineering challenges.
• Hybrid work model designed for flexibility and collaboration, with two in-office days for team engagement.

Williams-Sonoma India Pvt. Ltd.

Founded in 1956, Williams-Sonoma Inc. is the premier specialty retailer of high-quality products for the kitchen and home in the United States. Today, Williams-Sonoma, Inc. is one of the United States' largest e-commerce retailers with some of the best known and most beloved brands in home furnishings. Our family of brands are Williams-Sonoma, Pottery Barn, Pottery Barn Kids, Pottery Barn Teens, West Elm, Williams-Sonoma Home, Rejuvenation, and Mark and Graham. We currently operate retail stores globally. Our products are also available to customers through our catalogs and online worldwide.

Williams-Sonoma India sourcing office was established in 2013. We are based in Gurugram, India. We are sourcing premium products across all categories of Home Furnishing and recorded double digit year-on-year growth. We have a dynamic team of over 100 members handling versatile vendors across India, Nepal & Bangladesh. We are looking to onboard talented people and create successful professional journey.