Business Intelligence Architect

Hey, we're Ardene!

We're the ultimate destination in North America and beyond for head-to-toe apparel, footwear, and accessories - all at the best prices. In 1982, we started as an accessories and jewelry retailer. Today, we're on a whole new level, with 250+ stores in Canada, the USA and internationally – not to mention ardene.com and our app!

We believe that fashion shouldn’t 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 Ardene? Check out our careers site for the latest updates & read one-on-one personal interviews with team members from across Ardene.

https://ardenecorporate.com/life-at-ardene

WHO YOU ARE:

As our BI Architect, you 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 support business-wide decision-making. 
• Design, develop, and maintain dashboards and reports, including Power BI solutions, covering sales, inventory, merchandising, and store performance metrics. 
• Utilize Microsoft Fabric components, including OneLake, Lakehouse, Data Warehouse, Dataflows Gen2, and Notebooks, to support end-to-end data solutions.  
• Design, develop, and optimize semantic data models using Power BI datasets and DAX.  
• Build, maintain, and enhance ETL/ELT pipelines leveraging Fabric Data Factory.  
• Integrate and consolidate data from diverse sources such as SQL Server, Azure SQL, APIs, and cloud-based platforms.  
• Ensure data accuracy, consistency, and reliability by monitoring quality, enforcing governance, and maintaining compliance standards. 
• Create and maintain clear documentation for PBI Fabric Lakehouse/Warehouse configurations, datasets and data models. 
• Serve as the primary IT point of contact for all reporting and analytics needs across corporate and store operations. 
• Collaborate with project managers and team members to understand their business requirements and translate them into dashboard visualizations, providing actionable 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. 
• Additional tasks as required. 

WHAT YOU’LL NEED:

• Bachelor's degree in computer science, Information Systems, Data Analytics, Business, or related field. 
• 10+ years of experience in reporting tools like Power BI development. 
• Strong hands-on experience with Microsoft Fabric, including Lakehouse and Warehousing concepts. 
• Strong expertise in Power BI (DAX, Power Query, data modeling, dashboard development), SQL and 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 of data 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 with additional BI tools is a plus. 

GROW WITH US!

We’re pretty proud to say that everything we do starts with our people – whether it’s 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!