Sr. Software Engineer - Sr. BI Engineer at Williams-Sonoma, Inc. in Pune

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