Business Intelligence Analyst



Circle K Ireland is currently recruiting for a Business Intelligence (Pricing) Analyst to join the Trading & Category Management Team.   


Reporting to the Price Execution Manager, the Business Intelligence (Pricing) Analyst will work closely with our local Trading & Category team and Global Data & Analytics team to produce decision-making data for the business.  Day to day work will include gathering business requirements and relevant data to optimise and automate PowerBI reports, dashboards and other visualizations, algorithms, and business tools for use across the organization.


The Pricing Analyst responsibilities:

  • You will review, analyze and validate deliveries from our global Data Science Team and propose recommendations regarding price, range and promotion to our category managers.
  • You will turn business requirements into technical requirements and present solutions to stakeholders (non-technical audiences)
  • You will independently source and interpret the correct and best data sources for a given analysis from a variety of sources (AC Nielsen, other competitive data, price surveys, census data, etc.) to create actionable BI insights
  • You will select and implement the right analytic toolset for each deliverable, which will include SQL, Python, PowerBI, and other Company data structures and tools
  • You will work on automation and improvement of processes and embed new processes in BI workflows
  • You will provide analytics support to the Price Execution Manager and Global Data Science team with a particular focus on BI and price optimization activities and develop tools to support  our Category Managers in making data driven decisions
  • You will create and maintain local templates, tools and solutions for managing assortment, pricing rules, price families, promotions and map them to associated metadata to enhance data sets and BI insights


Are you a fit?  

  • Bachelor's degree in Economics, Finance or Mathematics.
  • 3+ years of experience writing complex and optimized SQL and ETL skills along with working knowledge of data warehouse concepts and processes - Multidimensional models, SSAS, Azure Databricks, Apache Spark, Oracle.
  • 3+ years of experience solving problems programmatically and using R, Python to transform and integrate data from SQL databases, APIs, unstructured and big data sources
  • 3+ years of experience in data analytics, business intelligence, and/or data science with a particular focus on retail / commercial / financial analytics.
  • 3+ years experience in PowerBI data visualization using complex DAX and presenting data in an attractive way to different target groups
  • Professional background in retail and commercial BI analytics preferably in a multinational FMCG environment.