Job Description

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!

BAT DIGITAL BUSINESS SOLUTION IS LOOKING FOR A BI DEVELOPER

SENIORITY LEVEL: Junior Management Level

FUNCTION: Marketing - Business Intelligence

SALARY RANGE: Competitive Salary + Excellent Benefits + Market Leading Bonus

LOCATION: Sunway Geo Tower, Bandar Sunway

ROLE POSITIONING AND OBJECTIVES

BI Developer will be a key role in enabling data driven story telling in BAT. Role will be responsible to develop visualization using PowerBI revolving Descriptive, Diagnostic, Predictive and Prescriptive Dashboards.

The role will be spearheading the activation, operational and outcome of BI team to ensure high quality output, fit for purpose solution.

Role is expected to develop, optimize BI infrastructure, data integrity/relationships, as well as reporting and business process architectures, enabling fit for purpose analytics and more effective insights delivery.

BI Developer is expected to be SME on ETL tools and assist Business Analyst in building End to End integrated, scalable solution to Functional Leaders Globally.

Reports To: APMEA Marketing Transformation Manager

Reporting Level: Manages Self

Geographic Scope: Global

WHAT YOU WILL BE ACCOUNTABLE FOR

• End to End Dashboard Development SDLC (Data to Dashboard), Strong developing knowledge of PowerQuery, M Language, DAX and PowerBI functions is a must
• Manage data extraction on demand from Snowflake data warehouse using SQL.
• Work closely with Data Engineers and Data Scientists to provide visualization on demand for POC analysis.
• Contribute in High Level Engagement and collaborate with Business Analyst to perform feasibility study, delivering POC and provide consultation and recommendation to stakeholders
• Proven track records in developing dashboard with multiple data sources and communicate requirements to Data Engineers / Data Scientists or relevant team
• Perform diagnostic on existing excel reports, develop solutions, perform implementation and monitor validation processes to ensure data integrity and optimal performance
• Perform all phases of the ETL process to ensure compliance with standard operating procedures and global templates
• Collaborate with Data Scientists and Platform Team to enable rapid BI Developments
• Define and maintain internal processes and quality standards documentation to ensure process controls and audits are up to date and aligned to BAT standards
• Execute modification on existing dashboards and diagnostic the impact of the expected modifications on the data model behind the dashboards
• Contribute in the development of SDLC, Project Governance Files and Templates
• Build data governance checkpoints and contribute in building Operating Model
• Effectively manage multiple stringent project timelines in fast paced business environment
• Continuously strive to improve current tools and methodologies improve analysis of information

ESSENTIAL REQUIREMENTS

• Degree in Mathematics, Data Science, Marketing, Finance, Analytics, Economics or related field
• At least 3-5 years proven track records in developing BI projects, (years in top tiers consulting company count double)
• Proficiency in English, both verbal and written (Japanese knowledge would be a plus)
• Detail oriented and continues learner
• Strong Problem Solving, Continuous Improvement, and Resourceful Mindset
• Experience in using direct query with Database Infrastructure i.e. Snowflake, Azure Blob
• Strong Expertise in using PowerBI, including integration with PowerApps and PowerAutomate are preferred
• Proven track records in delivering multiple BI projects with various complexity
• Hands-on Developing Experience with Microsoft Products (Excel, PowerBI, Sharepoints, PowerAutomate, PowerApps, Excel Macro, PowerQuery)
• Experience with SQL to format and extract data
• Comfortable with numbers and good analytical sense
• Experience in developing product using agile methodologies and ways of working
• Good Understanding of Data Structure, Transformation and Architecture
• Knowledge in coding languages will be a plus (Python, R, etc.)

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!

British American Tobacco