Business Intelligence Analyst

We are seeking a highly creative and strategic Business Intelligence (BI) Analyst with expertise in Power BI / Excel and ETL (Extract, Transform, Load) processes. The ideal candidate will be responsible for designing, developing, and maintaining BI solutions that support data-driven decision-making.

This role is responsible for designing and maintaining BI solutions that provide insights into sales, inventory, supply chain, and customer trends. The ideal candidate will transform raw data into actionable intelligence, supporting key business decisions to drive profitability and operational efficiency.

Key Responsibilities:

Power BI and Excel Development:

• Design, develop, and maintain interactive Power BI dashboards for sales, inventory, merchandising, and supply chain analytics.
• Create data visualizations to track key metrics such as sell-through rates, stock levels, revenue, and customer behaviour.
• Optimize Power BI and Excel reports for performance and user experience.

ETL & Data Integration:

• Develop and manage ETL processes to extract, transform, and load data from ERP systems (e.g., Cin7, Xero), POS systems, eCommerce platforms (Shopify), and supplier databases.
• Automate data pipelines to ensure seamless data flow between multiple systems.
• Maintain data accuracy, integrity, and consistency across different business functions.

Data Analysis & Reporting:

• Analyze sales trends, customer purchasing behaviour, and demand forecasting to support merchandising and inventory planning.

Database & Data Warehousing:

• Manage data sources, including SQL databases, cloud storage, and APIs.
• Design and maintain data models, including star and snowflake schemas.
• Collaborate with data engineers to improve database performance and data accessibility.

Required Skills:

• Expertise in Power BI and Excel (DAX, Power Query, custom visuals, and report optimization).
• Experience with data modelling (star schema, snowflake schema, normalization, and denormalization).