Sr. BI Analyst

Senior BI Analyst (Markets Loyalty CRM)

What You’ll Be Doing

• Create interactive dashboards using Power BI, integrating data from SQL, Excel, Azure, and other sources for real-time reporting.
• Apply strong data modeling and UX principles in Power BI, including DAX, row-level security, and performance optimization to support business KPIs.
• Translate complex business problems into structured, data-driven insights that drive strategic and operational decisions.
• Bring deep domain expertise in Mobility and CPG analytics, including KPI benchmarking, incrementality measurement, and campaign evaluation.
• Demonstrates strong communication and storytelling abilities, with the capability to negotiate, influence decisions, and align diverse stakeholders through clear, data-driven narratives.
• Design and execute A/B testing, hypothesis testing, and pre-post analysis to assess campaign effectiveness and business impact.
• Build scalable tools and frameworks to monitor and enhance Loyalty/CRM performance across customer segments.
• Deliver insights through compelling storytelling, making advanced analytics accessible to non-technical audiences.
• Conduct root cause analysis and deep-dives to answer critical business questions and uncover hidden opportunities.
• Independently develop data quality assessment frameworks and automate campaign analysis workflows for efficiency.
  
  

What You Bring

• Strong proficiency in SQL and MS Excel for data extraction and manipulation.
• Minimum 3 years of hands-on experience with Power BI for dashboard development and reporting.
• Intermediate understanding of Python for data automation and analysis.
• Experience working with Power Automate, Power Apps, and Alteryx is a plus.
• Solid foundation in statistical analysis, including:
• Exploratory Data Analysis (EDA)
• Hypothesis testing
• Univariate and multivariate analysis
  

What We Offer

You bring your skills and experience to Shell and in return you work with talented, committed people on one of the most important challenges facing our planet. You’ll have the opportunity to develop the skills you need to grow in an environment where we value honesty, integrity, and respect for one another. You’ll be able to balance your priorities as you become the best version of yourself.

• Progress as a person as we work on the energy transition together.
• Continuously grow the transferable skills you need to get ahead.
• Work at the forefront of technology, trends, and practices.
• Collaborate with experienced colleagues with unique expertise.
• Achieve your balance in a values-led culture that encourages you to be the best version of yourself.
• Join an organisation working to become one of the most diverse and inclusive in the world. We strongly encourage applicants of all genders, ages, ethnicities, cultures, abilities, sexual orientation, and life experiences to apply.
• Grow as you progress through diverse career opportunities in national and
• international teams.
• Gain access to a wide range of training and development programmes.
  
  

An Inclusive & Progressive Place to Work

• To power progress together, we need to attract and develop the brightest minds and make sure every voice is heard. Here are just some of the ways we’re nurturing an inclusive environment – one where you can express your ideas, extend your skills, and reach your potential.
• We’re creating a space where people with disabilities can excel through transparent recruitment process, workplace adjustments and ongoing support in their roles. Feel free to let us know about your circumstances when you apply, and we’ll take it from there.
• We’re closing the gender gap – whether that’s through action on equal pay or by enabling more women to reach senior roles in engineering and technology.
• We’re striving to be a pioneer of an inclusive and diverse workplace, promoting equality for employees regardless of sexual orientation or gender identity.
  
  

Shell in India

Shell is a diversified energy company in India with 13,000 employees, and presence in Integrated Gas, Downstream, Power, Renewable and Upstream. Additionally, we have deep capabilities in R&D, digitalisation, and business operations.

Our global strategy, Powering Progress, is designed to generate value for our shareholders, customers, and the wider society, and focuses on creating more value with less emissions. The strategy supports our purpose of providing more and cleaner energy solutions, with the aim of profitably transforming Shell into a net-zero emissions energy business by 2050. As India moves towards its target of net-zero emissions by 2070, Shell India aims to play a leading role in securing vital energy for today, while investing in, and helping to build, the energy system of the future through strategic investments in the country.

Our Lubricants business serves over 50,000 consumers through a strong network of over 200 distributors, and operates an end-to-end value chain that spans conceptualization, development, and production at a world-class blending plant at Taloja. Through our 350-plus retail stations, we offer an integrated mobility experience including fuels, cafes, and convenience stores, with a prominent network of EV recharging facilities.

Shell owns and operates a LNG re-gasification terminal at Hazira, Surat, with a capacity of 5 MTPA and a LNG truck-loading unit that plays a crucial role in helping meet India’s growing demand for gas across sectors. In 2022, Shell acquired Sprng Energy in a $1.55 billion deal to build an integrated energy transition business in the country. Sprng is a leading renewable energy company in India which develops and manages solar, wind, and hybrid power generation facilities and infrastructure.

Our three capability centres across Bangalore and Chennai serve as a technology and innovation powerhouse for Shell globally, working as a delivery engine for core technical, digital, and finance processes: pioneering digital innovation and cutting-edge technologies across the energy sector. We also have strong academic partnerships and collaborations with leading universities and technology institutes to accelerate decarbonization efforts within the energy sector.

We are committed to positively contributing to the communities in which we operate through programmes on STEM Education, Skilling, and Livelihood across India. We nurture and invest in startups developing initiatives focused on accelerating energy innovation through programs such as Shell E4 and Shell Eco-marathon. We also have strategic investments in new energy companies such as Husk Power, d.light, Orb Energy, and Cleantech Solar.