A career at Brown-Forman is just like a good bottle of bourbon: unique and refined, with a bit of a kick. Making our products from barrel to bottle requires detailed planning along each step. Just like bourbon production, our employees work in many different aspects to create the best possible product. This way, our customers can enjoy the world-class brands we promise to deliver. Heres the kicker - we, too, get to enjoy this process, just one of the sweet benefits of leading the market with the worlds favorite whiskey. Whether in the ground, in the store, or in the office, we hand pick all of our ingredients in order to be proud of what we achieve.
Scope of Position:
The Business Insights Analyst role will be critical in supporting Brown Formans objectives toward an insight driven organization and will be responsible for gathering and documenting business, functional and non-functional requirement as well as managing those requirements from development through to testing and release.
The Business Insights Analyst is a true business partnering role working alongside key stakeholders across the whole business in understanding and documenting business requirements, identifying processes and procedures to source data and deliver analytical reports and tools to drive business outcomes.
This role requires experience in data visualization and reporting techniques with Tableau to deliver reporting and analytical capabilities to our business as well as advanced experience in Microsoft Excel.
Responsibilities include, but are not limited to:
Reporting & Analytics
Collaborating with key stakeholders in the delivery of new dashboards to drive actionable insights particularly in the areas of sales/ revenue, return on investment, discounts, pricing, forecasting, targeting and other predictive opportunities.
Bring technical and commercial expertise to business problems and use the latest BI technologies, tools and methodologies to quickly develop solutions for the business.
Work with other finance/ commercial analysts and business partners to translate data into relevant and meaningful business insights.
Lead or participate in projects to deliver on BF-As reporting roadmap as well as contribute to the future deliverables based on stakeholder feedback.
Identify and integrate potential data sources external to the BF-A business.
Proactively collaborating and creating best in class practices with other stakeholders within BF and external to the business to promote a data driven culture.
Project Management
Project manage or participate in BI projects to deliver on approved proof of concepts.
Manage stakeholder expectations throughout each project, effectively prioritizing, tracking, guiding and advising on project deliverables. Foreseeing gaps or issues from scope to delivery.
Work closely with Project Managers as a technical expert in projects managed by other teams.
Work with Global IT and local counterparts on global projects with regard to data consolidation and business intelligence capabilities.
Manage multiple projects and timely delivery of projects in accordance with project timelines.
Brown Forman Core Competencies:
Operating with Integrity
Living the Brown Forman Vision and Values
Driving for Results
Acting as a Brand Ambassador
Modeling Diversity and Inclusion
Key Competencies:
Strong communication skills, both verbal and written.
Interpersonal skills.
Strong influencing skills and time management skills.
Develop strong consultative relationships with senior executives and business partners.
Ability to take initiative and work with ambiguity.
Ability to prioritize, manage and execute tasks.
Ability to present with impact.
Ability to work independently; or with local or international teams and is a team player.
Excellent attention to detail with ability to discover inconsistencies in numerical data.
Proven project management skills.
Excellent stakeholder management skills.
Strong analytical and problem solving skills with a high degree of initiative and flexibility.
Strong commercial and financial acumen.
Attention to detail (Numerical accuracy & design consistency).
Qualifications & Requirements
Must Requirements:
Degree or Masters in Business Analytics, Economics, Commerce or Finance, Science or Computing (critical thinker).
2-3 years experience in an analytical role, including exposure to data visualization.
2-3 years using SQL (preferably in a database environment)
Partitioning, aggregation, conditional statements.
Working knowledge of SQL Joins (e.g. LEFT, INNER, UNION ALL, CROSS).
2-3 years experience with BI and visualization tools such as Tableau, Power BI, Qlikview
2-5 years using Tableau to deliver reporting and analytical capability. Working knowledge of data analysis, data modelling, data segmentation, data integration and database design.
CASE statements, Parameters, Complex functions (FIXED, EXCLUDE, INCLUDE), Context filters, WINDOW_SUM etc.
Experience working with dates (e.g. CY vs LY, FYTD, MAT)
Blue sky thinking/ problem solving.
UI improvements/ design experience.
2-3 years experience with data preparation and data blending software such as Alteryx.
Advanced Excel skills.
Working knowledge of relational database design, technical ability to access, organize and build datasets.
Understanding of change management, development and testing.
Preferred Requirements:
Experience with Tableau server.
Familiarity with development, staging and production workflow.
Experience using statistical modelling and algorithms (predictive).
Familiarity with BI systems & Tools (e.g. Databases & ETL tools).
Experience in FMCG desirable (e.g. Price optimization).
Experience in FMCG industry.
Knowledge of project management.
MS Access skills.
SAP experience.
Working knowledge of statistical computing software such as R / Python.
