Role Overview
We are seeking a Senior Business Intelligence Specialist with AI & Automation capabilities to lead and accelerate BI development.
This role goes beyond traditional reporting. You will:
- Build robust BI and data warehouse solutions
- Automate repetitive BI tasks using AI and scripting
- Leverage AI-assisted analytics, data modelling, and development workflows
- Act as a senior individual contributor, improving speed, quality, and scalability of BI delivery
You will work closely with architects, developers, and clients to modernize how BI solutions are designed, built, and maintained.
Key Responsibilities
BI & Data Platform Delivery
- Deliver end-to-end BI and data platform solutions by partnering with retail stakeholders to translate business needs into scalable analytics, designing and maintaining data warehouses and models, building high-impact Power BI dashboards, and developing optimized SQL queries for large datasets.
Data Integration & Engineering
- Design and operate robust data integration pipelines using Azure-native and ELT/ETL best practices, ensuring high data quality and performance while leveraging cloud platforms such as Azure SQL, Snowflake, and Azure Data Lake.
AI-Driven BI & Automation (Core Differentiator)
- Leverage Python and AI-assisted tools to automate and optimize BI workflows, accelerate delivery through LLM-enabled development, and implement AI-powered analytics use cases such as automated insights, natural-language BI, and forecasting, while continuously improving productivity through reusable tools and automation.
Best Practices & Technical Leadership
- Provide technical leadership by setting and enforcing BI best practices, optimizing solutions for scalability and cost efficiency, and mentoring junior BI talent on modern, AI-enabled development approaches.
Requirements
- 58+ years of experience in Business Intelligence, Analytics, or Data Engineering roles.
- Strong experience delivering BI solutions in retail, FMCG, or multi-store environments is highly preferred.
- Advanced SQL (performance tuning, large fact tables, partitioning concepts).
- Strong experience with Power BI (DAX, data modelling, performance optimization).
- Hands-on experience with Azure BI stack
- Experience with Snowflake or similar cloud data warehouses.
- Python for data processing, automation, or analytics tasks.
- Experience using AI Tools to accelerate development.
- Ability to design automation scripts or workflows to reduce manual BI effort.
- Familiarity with LLM concepts (prompting, limitations, validation, hallucination control).
- Experience integrating AI outputs safely into BI or analytics workflows.
