Power BI Consultant

Ness Digital Engineering

Ontario, Canada

JOB DETAILS
JOB TYPE
Full-time
SKILLS
Agile Programming Methodologies, Analysis Skills, Business Analysis, Business Solutions, Cloud Computing, Communication Skills, Consulting, Content Management, Data Analysis, Data Modeling, Data Quality, Data Warehousing, Digital Hierarchy, Documentation, Ecosystems, Leadership, Maintain Compliance, Metadata, Metrics, Onboarding, Performance Metrics, Power BI, Pricing, Problem Solving Skills, Product Lifecycle, Product Management, Product Merchandising, Product Support, Promotional Products, Protocol Independent Multicast (PIM), Quality Management, Reporting Dashboards, Requirements Management, Retail, Retail Strategy, Sales, Stock Keeping Unit (SKU), Supply Chain, Systems Analysis, Usability Engineering, Use Cases
LOCATION
Ontario, Canada
POSTED
12 days ago

Description

Role Summary
The Business Systems Analyst (BSA) will support digital transformation initiatives by bridging Product, Merchandising, Content, and Technology teams. This role requires strong retail domain expertise, a product‑centric mindset, and hands‑on Power BI analytics experience to enable insight‑driven decision making across assortment, pricing, inventory, and product content.
The successful candidate will play a key role in ensuring high‑quality, trusted product and content data flows seamlessly across enterprise systems, digital channels, and analytical platforms, supporting both in‑store and omnichannel experiences.

Key Responsibilities
Retail Product & Business Analysis
  • Partner with Product Management, Merchandising, Pricing, Supply Chain, and Digital teams to understand retail strategies, product objectives, and operational needs.
  • Translate business and product needs into clear functional, data, and reporting requirements, including user stories and acceptance criteria.
  • Support initiatives across the product lifecycle, including assortment planning, SKU onboarding, pricing and promotion changes, and product rationalization.
  • Analyze impacts of changes across core retail, digital, and analytics ecosystems, ensuring alignment with enterprise standards.

Product Content Management (PCM / PIM)
  • Support product content management capabilities including product attributes, hierarchy, digital content, and enrichment processes.
  • Work with business and technology teams to define requirements for product data consistency and completeness across systems such as PIM/PCM platforms, and downstream analytical systems.
  • Ensure alignment of product content definitions, hierarchies, and metadata to support search, browse, and reporting use cases.
  • Partner with data and digital teams to improve product content quality, governance, and lifecycle controls.

Analytics & Power BI
  • Design, develop, and maintain Power BI dashboards and reports focused on product performance, sales, margin, inventory, and content completeness.
  • Collaborate with data engineering and analytics teams to define KPIs, metrics, and semantic models.
  • Deliver executive‑ready insights for senior leadership, ensuring clarity, accuracy, and actionable outcomes.
  • Enable self‑service analytics through effective documentation, metric definitions, and report enablement.

Stakeholder & Delivery Management
  • Act as a trusted advisor to business stakeholders by challenging assumptions, identifying gaps, and proposing practical, data‑driven solutions.
  • Facilitate workshops and working sessions to align on product, content, and analytics requirements.
  • Ensure adherence to data quality, governance, security, and non‑functional requirements across solutions.

Required Qualifications
  • 8+ years of experience as a Business Systems Analyst / Business Analyst within a retail or consumer‑facing enterprise environment.
  • Strong understanding of retail product domains, including assortment, pricing, promotions, inventory, and product hierarchies.
  • Demonstrated experience supporting Product Content Management (PCM / PIM) or product data capabilities.
  • Proven hands‑on Power BI expertise, including:
    • Dashboard and report development
    • Data modeling and DAX
  • Strong ability to translate complex business needs into functional, data, and analytics requirements.
  • Excellent communication skills, with experience engaging cross‑functional teams and senior leadership.

Preferred Qualifications
  • Experience within large‑scale retail organizations and multi‑banner environments.
  • Familiarity with product‑centric Agile teams and modern delivery practices.
  • Experience working with enterprise data platforms, data warehouses, or cloud analytics ecosystems.
  • Exposure to digital commerce, product search, or content enrichment processes.

Key Competencies
  • Product‑first and customer‑centric mindset
  • Strong analytical thinking and problem solving
  • Ability to bridge retail business, product, content, and technology perspectives
  • Clear, executive‑level communication
  • Strong focus on data quality, governance, and usability

About the Company

N

Ness Digital Engineering