Business Intelligence Architect

Hey were Ardene!

Were the ultimate destination in North America and beyond for head-to-toe apparel footwear and accessories - all at the best 1982 we started as an accessories and jewelry retailer. Today were on a whole new level with 250 stores in Canada the USA and internationally not to mention and our app!

We believe that fashion shouldnt be exclusive or intimidating it should be celebrated with youthful confidence and fearless enthusiasm. Our journey is ongoing in this new era of retail as we focus more than ever before on customer experience and sustainable practices.

We also take employee wellbeing and personal growth to heart. Our teams focus on driving initiatives in the area of mental health diversity & inclusion engagement and recognition. This includes our many mindfulness programs too so our teams can create meaningful connections lead with intention and kindness and be their best selves at work and in their lives.

Want to learn more about Life at ArdeneCheck out our careers site for the latest updates & read one-on-one personal interviews with team members from across Ardene.

YOU ARE:

As our BIArchitectyou will lead the development and delivery of actionable business intelligence solutions that drive decision-making across sales inventory and operations.

Reporting to the Head of IT your responsibilities include but are not limited to:

• Lead and mentor a high-performing BI and data analytics team within IT.
• Define and execute a BI and analytics roadmap to scale self-serve analytics improve reporting efficiency and supportbusiness-wide decision-making.
• Design develop andmaintaindashboards and reports includingPower BI solutions covering sales inventory merchandising and store performance metrics.
• Utilize Microsoft Fabric components includingOneLake Lakehouse Data Warehouse Dataflows Gen2 and Notebooks to support end-to-end data solutions.
• Design develop andoptimizesemantic data models using Power BI datasets and DAX.
• Buildmaintain and enhance ETL/ELT pipelinesleveragingFabric Data Factory.
• Integrate andconsolidatedata from diverse sources such as SQL Server Azure SQL APIs and cloud-based platforms.
• Ensure data accuracy consistency and reliability bymonitoringquality enforcing governance andmaintainingcompliance standards.
• Create andmaintainclear documentation for PBI Fabric Lakehouse/Warehouse configurationsdatasetsand data models.
• Serve as the primary IT point of contact for all reporting and analytics needs across corporate and store operations.
• Collaborate with project managersand team members to understand theirbusiness requirementsand translate themintodashboard visualizations providingactionable insights and strategic recommendations to support retail operations.
• Act as a subject matter expert in modern BI tools advising on reporting analytics methodologies and data visualization best practices.
• Stay current with emerging BI technologies and IT best practices to enhance reporting and analytics capabilities.
• Additionaltasks asrequired.

WHAT YOULL NEED:

• Bachelors degree in computer science Information Systems Data Analytics Business or related field.
• 10years of experienceinreporting tools likePower BI development.
• Strong hands-on experience withMicrosoft Fabricincluding Lakehouse and Warehousing concepts.
• Strongexpertisein Power BI (DAX Power Query data modeling dashboard development)SQLand Oracle.
• Experience working with Azure Data Services (Azure SQL Synapse Data Lake) and integrating data from multiple sources (e.g. ERP systems ServiceNow Workday Jira SonarQube).
• Experience with retail data systems POS/ERP integrations and retail metrics reporting.
• Understanding ofdata security RLS and governance.
• Knowledge of data warehousing and ETL/ELT processes.
• Proven ability to lead cross-functional teams mentor staff and manage multiple priorities.
• Strong analytical problem-solving and communication skills.
• Familiarity withadditionalBI tools is a plus.

GROW WITH US!

Were pretty proud to say that everything we do starts with our people whether its in-store or at the head office. From sales associates and store leadership; dedicated in-house apparel and design teams; marketing brand and digital experts; stylists photographers and graphic designers; all the way to store concept and operations. We do it all. Ardene is truly a creative hub that is second to none.

The Ardene head office is truly a creative hub that is second to none. Join us and see for yourself!