BI Developer

BAT is evolving at pace - truly like no other organisation.

To achieve the ambition, we have set for ourselves, we are looking for colleagues who are ready to live our ethos every day. Come be a part of this journey!

GRADE: G33

JOB TITLE: BI Developer

FUNCTION: Digital Business Solutions

CITY & COUNTRY: Lahore, Pakistan

ROLE POSITIONING AND OBJECTIVES

The BI Developer will play a crucial role in fostering data-driven narratives at BAT. This position entails creating visualizations with PowerBI, focusing on Descriptive and Diagnostic Dashboards. Additionally, the role involves developing and improving BI infrastructure, ensuring data integrity and relationships, and refining reporting and business process architectures. These efforts strive to facilitate purposeful analytics and more efficient insights delivery.

The BI Developer is anticipated to serve as a subject matter expert (SME) on ETL tools, collaborating with Business Analysts to construct integrated, scalable solutions for Functional Leaders worldwide.

Key Objectives:

• Foster proactive and efficient stakeholder engagement across all levels to uphold positive relationships.
  • Engage with the Platform Management Team (Data Warehouse), Functional COEs, and APME and Global Users (Not co-located in Pakistan).
• Identify and actively pursue opportunities for continuous improvement to improve overall process efficiency and effectiveness.

WHAT YOU WILL BE ACCOUNTABLE FOR

• Lead End-to-End Dashboard Development SDLC (Data to Dashboard), utilizing strong expertise in Power Query, M Language, DAX, and PowerBI functions.
• Develop dashboards with multiple data sources and effectively communicate requirements to Data Analyst or relevant teams.
• Conduct diagnostics on existing Excel reports, propose solutions, oversee implementation, and monitor validation processes to ensure data integrity and optimal performance.
• Execute all phases of the ETL process to ensure adherence to standard operating procedures and global templates.
• Support Business Analyst in conducting feasibility studies, developing proof of concepts, and providing recommendations and consultations to stakeholders.
• Collaborate with Data Analyst and Platform Team to facilitate rapid BI developments.
• Maintain internal processes and quality standards documentation to ensure compliance with process controls and audits aligned with BAT standards.
• Contribute to the development of SDLC, Project Governance Files, and Templates.
• Establish data governance checkpoints and contribute to the creation of the Operating Model.
• Efficiently manage multiple stringent project timelines in a fast-paced business environment.
• Continuously enhance current tools and methodologies to improve information analysis.

ESSENTIAL EXPERIENCE, SKILLS AND KNOWLEDGE

Experience

• Bachelor’s degree in Computer Science, Marketing, Finance, Analytics, or related field.
• Minimum of 1-2 years of previous experience in a similar role.
• Proficiency in English, both verbal and written.
• Strong expertise in Power Query, M Language, DAX, and PowerBI functions.
• Proficiency in automating reports and conducting data analytics.
• Strong problem-solving skills, continuous improvement mindset, and resourcefulness.
• Experience using direct query with Database Infrastructure such as Snowflake, Azure Blob.
• Proficient in integration with PowerApps and PowerAutomate.
• Hands-on development experience with Microsoft Products (Excel, PowerBI, SharePoint, PowerAutomate, PowerApps, Excel Macro, PowerQuery).
• Comfortable with numbers and possesses good analytical sense.
• Experience in developing products using agile methodologies and ways of working.
• Good understanding of data structure, transformation, and architecture.
• Ability to collaborate effectively within a team.
• Capable of working independently with minimal supervision.

BENEFICIAL

• Contributions to forums would be advantageous.
• Exposure to Alteryx, Dataiku, MicroStrategy is a plus.

WE ARE BAT

At BAT we are committed to our Purpose of creating A Better Tomorrow. This is what drives our people and our passion for innovation. See what is possible for you at BAT.

• Global Top Employer with 53,000 BAT people across more than 180 markets
• Brands sold in over 200 markets, made in 44 factories in 42 countries
• Newly established Tech Hubs building world-class capabilities for innovation in 4 strategic locations
• Diversity leader in the Financial Times and International Women’s Day Best Practice winner
• Seal Award winner – one of 50 most sustainable companies

BELONGING, ACHIEVING, TOGETHER

Collaboration, diversity and teamwork underpin everything we do here at BAT. We know that collaborating with colleagues from different backgrounds is what makes us stronger and best prepared to meet our business goals. Come bring your difference!