Bangalore / Bengaluru
4 years ago
121 Applied
JOB ID:38432
Job details
Job Type
Full Time
Functional Area
Research/Analytics/Business Intelligence/Big data
Industry
FMCG/Food/Consumer Durables
Education
Not Specified
Experience Required
3 - 6 Yrs
Key Skills Required
MS Access, Power Excel, Power BI, Azure SQL, ADF, SQL, Python or R
Other Skills Required
Job Description
Context:Diageo is a global leader in beverage alcohol with an outstanding collection of brands across spirits and beer categories. These brands include Johnnie Walker, Crown Royal, JεB, Smirnoff, Cîroc, Ketel One, Captain Morgan, Baileys, Don Julio, Tanqueray and Guinness.
Diageo has set up a Data and Analytics (D&A) function within Diageo Business Services (GDBS) focused on leveraging our core information assets (data, reporting, insights and advanced analytics capabilities) to better equip markets to improve their decisions and optimize their actions through the use of improved data, insights and advanced analytics. The Data and Analytics function consists of 4 key areas of expertise: Technology, Business Insights and Reporting, Transformation and Advanced Analytics.
D&A will increasingly become a core differentiator for Diageo, identifying and enabling capabilities to improve innovation, performance and differentiation across a wide range of functions and activities globally.Strateg... See More
Diageo has set up a Data and Analytics (D&A) function within Diageo Business Services (GDBS) focused on leveraging our core information assets (data, reporting, insights and advanced analytics capabilities) to better equip markets to improve their decisions and optimize their actions through the use of improved data, insights and advanced analytics. The Data and Analytics function consists of 4 key areas of expertise: Technology, Business Insights and Reporting, Transformation and Advanced Analytics.
D&A will increasingly become a core differentiator for Diageo, identifying and enabling capabilities to improve innovation, performance and differentiation across a wide range of functions and activities globally.Strateg... See More
Context:Diageo is a global leader in beverage alcohol with an outstanding collection of brands across spirits and beer categories. These brands include Johnnie Walker, Crown Royal, JεB, Smirnoff, Cîroc, Ketel One, Captain Morgan, Baileys, Don Julio, Tanqueray and Guinness.
Diageo has set up a Data and Analytics (D&A) function within Diageo Business Services (GDBS) focused on leveraging our core information assets (data, reporting, insights and advanced analytics capabilities) to better equip markets to improve their decisions and optimize their actions through the use of improved data, insights and advanced analytics. The Data and Analytics function consists of 4 key areas of expertise: Technology, Business Insights and Reporting, Transformation and Advanced Analytics.
D&A will increasingly become a core differentiator for Diageo, identifying and enabling capabilities to improve innovation, performance and differentiation across a wide range of functions and activities globally.Strategy / Scope:
Extracting and inspecting data for patterns, data quality.
Cleansing of data & Transformation of data
Cleansed data to be uploaded via mass upload options available.This role is expected to use manual and semi auto methods using tools such as MS Access, Power Excel, Power BI, Azure SQL, ADF, under the guidance of the Senior Data Analyst.Top 3-5 Accountabilities:Execute Manual/ semi-automated routines to perform inspection/ cleansing Report back to team lead on findings and proposed actions required.
Report back to team lead on findings and proposed actions required.Qualifications, Skills and Experience Required:
Diageo has set up a Data and Analytics (D&A) function within Diageo Business Services (GDBS) focused on leveraging our core information assets (data, reporting, insights and advanced analytics capabilities) to better equip markets to improve their decisions and optimize their actions through the use of improved data, insights and advanced analytics. The Data and Analytics function consists of 4 key areas of expertise: Technology, Business Insights and Reporting, Transformation and Advanced Analytics.
D&A will increasingly become a core differentiator for Diageo, identifying and enabling capabilities to improve innovation, performance and differentiation across a wide range of functions and activities globally.Strategy / Scope:
- Structure and quality of data is the no 1 issue holding back our transformational programs – NRM, BPM, Marketing Catalyst/ Efficiency etc.
- Whilst there are currently some gaps in availability of data (external data, promo), we do have most of the data we need, but it is rarely harmonized, not in common data structures or source systems, and has questionable accuracy (incorrectly posted, of the wrong level of detail etc.). Further, moving forward, we will want to utilize many new external data sets, so these issues will be ongoing.
- There is no substitute for having data correctly captured and recorded at source by data owners to ensure we have reliable good quality data – the problem is that this takes time to fix – changes in systems, people and process.
- Build a Data Cleansing Factory to drive a low cost, systematic approach for tackling data issues:
- Take specific data problems and apply people and tech to improve the usability of data immediately for our key programs– high pace, high turnaround. This means we can fix data manually, where needed, to enable it to be used on a short-term/immediate basis to deliver insights that unlock value in the business as well as driving a change of behaviour (e.g. allocate data to enable VPMC insights.)
- Profile and assess our data, informing required harmonization and transformation work, before handing it off to our technology teams for automation.
- Build systematic capabilities in both of these areas for ongoing usage. Continue to manually handle data that doesn’t justify automation and move data out of the factory when automation makes sense and required profiling work is completed.
Extracting and inspecting data for patterns, data quality.
Cleansing of data & Transformation of data
Cleansed data to be uploaded via mass upload options available.This role is expected to use manual and semi auto methods using tools such as MS Access, Power Excel, Power BI, Azure SQL, ADF, under the guidance of the Senior Data Analyst.Top 3-5 Accountabilities:Execute Manual/ semi-automated routines to perform inspection/ cleansing Report back to team lead on findings and proposed actions required.
Report back to team lead on findings and proposed actions required.Qualifications, Skills and Experience Required:
- Degree in Computer Science
- Minimum 3 years’ experience in Consumer Goods or Retail Data Management or Business Intelligence at a leading multinational company or working with a leading multinational as a consultant
- Good communication skills
- Intermediate level knowledge in any Azure Stack such as Azure Data Bricks, Azure Synapse, ADF etc.
- Proficient in at least one of the technologies like SQL, Power BI, Power Excel, Python or R
About Company
<p>Diageo is the world’s leading premium drinks company with an outstanding collection of brands, such as Johnnie Walker, Smirnoff, Baileys, Captain Morgan, Tanqueray and Guinness. Our purpose - Celebrating life, every day, everywhere - has an important role in our company, for our people, our brands, in how we perform and how we create shared value.</p>
<p><strong>About Diageo India </strong></p>
<p>We are India’s leading beverage alcohol company with an outstanding portfolio of premium brands. Our portfolio of over 140 brands of Scotch whisky, IMFL whisky, brandy, rum, vodka, gin and wine includes the much-loved McDowell's No.1, Royal Challenge, Signature, and Antiquity as well as Diageo’s iconic brands such as Johnnie Walker, VAT 69, Black & White, Smirnoff and Ciroc among others. . In 2013-14, Diageo plc acquired a 54.8% shareholding in United Spirits making India one of its largest markets. We are a high p... See More
<p>Diageo is the world’s leading premium drinks company with an outstanding collection of brands, such as Johnnie Walker, Smirnoff, Baileys, Captain Morgan, Tanqueray and Guinness. Our purpose - Celebrating life, every day, everywhere - has an important role in our company, for our people, our brands, in how we perform and how we create shared value.</p>
<p><strong>About Diageo India </strong></p>
<p>We are India’s leading beverage alcohol company with an outstanding portfolio of premium brands. Our portfolio of over 140 brands of Scotch whisky, IMFL whisky, brandy, rum, vodka, gin and wine includes the much-loved McDowell's No.1, Royal Challenge, Signature, and Antiquity as well as Diageo’s iconic brands such as Johnnie Walker, VAT 69, Black & White, Smirnoff and Ciroc among others. . In 2013-14, Diageo plc acquired a 54.8% shareholding in United Spirits making India one of its largest markets. We are a high performing business that is sensitive to consumer, community and societal needs. We are proud of being a responsible producer and marketer of beverage alcohol, and we champion responsible consumption as part of a balanced lifestyle.</p>
<p>We are looking to hire exceptional women talent in:</p>
<ul>
<li>Manufacturing and Supply Chain areas like Operations, Quality, Sourcing, Environment, Health Safety (EHS) & Productivity.</li>
<li>Commercial Function like Sales, Key Accounts Management, Market Activation, Sales Excellence and Sales Analytics.</li>
<li>Marketing roles like Brand & Product Management.</li>
<li>Corporate Support Functions like Treasury, Taxation, Secretarial, Compliance and Law.</li>
</ul>
<p>Join us on our LinkedIn page to keep in touch and know more: <a href="https://www.linkedin.com/company/3069440/">https://www.linkedin.com/company/3069440/</a></p>
<p><strong>About Diageo Business Services India</strong></p>
<p>We are one of the five Diageo Business Services that are based around the world and our India office is in Bengaluru. The remaining four centers are in: Budapest, Bogota, Manila and Nairobi. We provide a broad range of services to our businesses around the world. We are already 600 strong people in Bengaluru and growing. This global scale and reach helps deliver strong control environment and significant cost savings, while freeing local teams to market and sell our great brands to customers and consumers.</p>
<p>As part of the team, you’ll have the opportunity to develop your skills in an array of different areas, including:</p>
<ul>
<li>Source to Pay</li>
<li>Order to Cash</li>
<li>Financial Control and Record to Report</li>
<li>Controls</li>
<li>HR shared services</li>
<li>Data and Analytics</li>
<li>Project Management</li>
<li>Technology</li>
</ul> See Less
Recommended Companies
Recommended Events
