Applied Successfully!
Thank you for applying on this job post, We will get back to you shortly, Meanwhile start browsing our other jobs
Job id : 38273

Analytics Technology and Development – Big Data ETL Architect

Analytics Technology and Development – Big Data ETL Architect

  Bangalore / Bengaluru
   Diageo        Bangalore / Bengaluru
  4 years ago      18 Applied

JOB ID:38273

Job details

Job Type

  Full Time

Functional Area

Research/Analytics/Business Intelligence/Big data

Industry

FMCG/Food/Consumer Durables

Education

Not Specified

Experience Required

  7 - 10 Yrs

Key Skills Required

  ETL, Design and framework in ETL, Azure Data Factory, Azure Databricks, SQL Server Integration Services, BODI

Other Skills Required

 

Job Description

Context/Scope:Diageo has created an end to end Data and Analytics Centre of Excellence to support our growth agenda, while delivering our productivity ambition. Our mission is to accelerate business performance by providing advanced business insight via new and evolving analytics tools, technology, and capabilities.
As part of the CoE, the Technology & Development team focuses on:
Delivering and sustaining analytics platforms and solutions that provide actionable insights
Empowering stakeholders to analyse and understand information
Providing deep expertise on technologies, data, and processes needed to uncover and deliver insights.
We deliver analytics solutions through an Agile, Product led approach. We are organized accordingly into teams around the Products that we deliver to the organization. The lead developer is accountable for all aspects of Product design, build, testing, deployment, sustaining, and optimizing solutions. This is a key leadership role leading a team of developers fol...  See More
Context/Scope:Diageo has created an end to end Data and Analytics Centre of Excellence to support our growth agenda, while delivering our productivity ambition. Our mission is to accelerate business performance by providing advanced business insight via new and evolving analytics tools, technology, and capabilities.
As part of the CoE, the Technology & Development team focuses on:
Delivering and sustaining analytics platforms and solutions that provide actionable insights
Empowering stakeholders to analyse and understand information
Providing deep expertise on technologies, data, and processes needed to uncover and deliver insights.
We deliver analytics solutions through an Agile, Product led approach. We are organized accordingly into teams around the Products that we deliver to the organization. The lead developer is accountable for all aspects of Product design, build, testing, deployment, sustaining, and optimizing solutions. This is a key leadership role leading a team of developers following agile sprint process.There are seven product teams in the Analytics Technology & Development team, organized by business and technology functions. Each team is globally diverse, with team members and stakeholders around the world in the different regions and timezones.This role is expected to liaise and work with Diageo’s IT partners and technology vendors to build the correct competencies. The role will require on-site presence and may also require global travelLeadership Responsibilities/ Key Stakeholders:Assessed against the Diageo CapabilitiesBe AuthenticBe yourself, stand up for what you feel is right and important
Build great relationships with those you work with, both internally and externally
Take time to really understand the five Diageo Values, live them every day
Be honest and open at all times; demonstrate high integrity
Value the differences in people, treat everyone with dignity and respect
Find SolutionsThink in the future, anticipate trends and opportunities
Generate ideas and move them to action
Be imaginative in finding solutions to issues and pursuing opportunities for the business
Develop and apply a great understanding of the business to your work
Connect to the Diageo PurposeUnderstand the Diageo Purpose, what it means for the business and for you personally.
Show pride in Diageo; act as a positive representative of the company and our reputation
Play an active part in the responsible drinking and corporate citizenship agenda
Consistently deliver great performanceDemonstrate drive to make a positive difference to business performance
Be clear about your own performance commitments ensure they are linked to business goals
Identify clear priorities and focus on them at all times
Demonstrate brilliant execution, be thorough and apply high standards in everything you do
Understand the controls and governance required in your area. Work within these and always speak up if they are not met
Have a positive outlook, channel your energy into finding opportunities and solutions even in times of uncertainty and ambiguity
Show commitment to outstanding teamwork
Grow yourselfDevelop and apply self-awareness, get to know your own strengths and development needs
Grow your capability and experience
Look for and respond to feedback
Purpose of RoleThe purpose of this role is to be the lead Big Data ETL Architect within the Analytics Platform Architecture team leading the design and scaling big data solutions to improve our data processing and data quality capabilities across the various ETL platforms within Diageo.DiageoInsights Technology: Azure Data Factory, Azure Databricks, SQL Server Integration Services, BODI, and AlteryxTop 3-5 Accountabilities
  • The Big Data ETL architect works with the team of Platform and Data Architects to design enterprise class data processing and data quality frameworks that maximize speed of delivery and reusability across the various ETL tools in our environment.
  • Works with the Big Data Product Owner to design a reusable Data Quality framewok to support our Logical Data Warehousing strategy built on Azure Cloud and Big Data technologies
  • Develops a cohesive strategy for which ETL tools, techniques and frameworks should be used for specific classes of problems and projects within Diageo
  • As a member of the Analytics Platforms team, the Big Data ETL Architect will focus on establishing a prescriptive ETL Architecture and Framework as an extension of Diageo’s existing Azure based
  • DiageoInsights technology stack including technologies such as Azure Data Factory, Alteryx, R, Python, Spark/Databricks, and Azure Data Lake Store
  • Participate in the Architecture Forum to support governance, architecture processes, best practices and structure to enable other projects to be successful using our approved tech stack and ETL tools and framworks consistently across Data Products
Qualifications and Experience Required
  • 10 years analytics development experience
  • 5+ years’ experience in designing big data technology solutions
  • Expertise in DiageoInsights Technology: Azure Data Factory, Azure Databricks, SQL Server Integration Services, Talend, Altery,Nifi
  • Previous experience in building frameworks to measure and improve data quality, using business rules engines or similar technology
  • Familiarity with core Data Warehousing concepts: Kimball Modelling, Data Warehouse ETL Toolkit, Data Quality Frameworks, Business Rules Engines,
  • Attention to detail is key, inquisitive & questioning nature
See Less
About Company
<p>Diageo is the world&rsquo;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&rsquo;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&rsquo;s iconic brands such as Johnnie Walker, VAT 69, Black &amp; 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&rsquo;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&rsquo;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&rsquo;s iconic brands such as Johnnie Walker, VAT 69, Black &amp; 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) &amp; Productivity.</li> <li>Commercial Function like Sales, Key Accounts Management, Market Activation, Sales Excellence and Sales Analytics.</li> <li>Marketing roles like Brand &amp; 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&rsquo;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