Senior Systems Analyst, Business Intelligence

Holt Renfrew offers you an inspiring, fashion-driven environment with opportunities to learn and grow. From our incredible partnerships with iconic luxury brands, to our commitments to corporate social responsibility, you will be inspired every day.

A job at Holt Renfrew offers a competitive total compensation, a generous employee discount, pension, and health & dental benefits, tuition assistance, and continuous learning and development.

The Senior System Analyst for Business Intelligence will bring their knowledge and expertise to bear by supporting the overall Enterprise Reporting capability at Holt Renfrew. They will work closely with the Enterprise Reporting team to develop and continuously improve the reporting capabilities across the business, which includes developing and supporting data cubes and dossiers on the MicroStrategy platform as well as emerging cloud-based solutions.

Responsibilities include (but are not limited to) the following:

1. Take responsibility for identifying information sources, gathering and interpreting data, and presenting findings to the designated business areas within Holt Renfrew.
2. Work with the enterprise reporting team to define, develop and maintain a knowledge base, including standardization and upkeep of data cubes and dossiers plus other deliverables as required.
3. Work closely with the Data Architect to help drive the development of a data centric organization.
4. Optimize and maintain Data Warehouse and MicroStrategy environments (including upgrades).
5. Help deliver self-serve objects and targeted reporting on the Microsoft platform.
6. Provide insights and strategies to the organization to enhance usage of MicroStrategy and adoption of new functionalities.
7. Implement new technologies and business processes across Holt Renfrew that will ultimately improve delivery to our internal teams.

The ideal candidate:

1. Bachelor's Degree in technical related field (Sciences, Information Systems, Technology, Engineering) or Business Administration.
2. Expert understanding and enterprise scale experience working with Business Intelligence (BI) implementations and Data Warehouse solutions.
3. 5+ years of experience developing business intelligence solutions; data cubes, dashboards and reports using MicroStrategy 10 or later.
4. Must be well versed with Object Migration, User Management, Security Groups, roles, ACLs, Security Filters.
5. Extensive hands-on experience working with Microsoft SQL Server 2019 or later and building ETL solutions using SQL Server Integration Services (SSIS).
6. Must be well versed with static and dynamic MicroStrategy subscriptions.
7. Must be well versed with Microsoft cloud tooling including visualizations in Power BI, Synapse Analytics, security access control, and Purview. SQL and Python abilities are preferred.
8. Team oriented - objective driven.
9. Excellent verbal, written and interpersonal communication skills.
10. Ability to communicate effectively with and positively influence the IT organization, executives, management, employees, suppliers and all internal and external stakeholders.
11. Experience working in a team environment with clear deliverables and deadlines.
12. Strong demonstrated problem-solving skills.
13. Strong business and financial acumen.
14. Adaptable and comfortable with ambiguity and change.
15. Proficient in Microsoft Office Suite (Word, Excel, PowerPoint, Outlook).

The measures of success:

1. Contribution to financial objectives.
2. Individual objectives linked to the achievement of department goals.
3. Feedback from internal and external clients.

Holt Renfrew is an equal opportunity employer committed to fostering a diverse and inclusive workplace. Our future success depends on the perspectives and contributions of all our employees -- their diverse backgrounds, abilities and experiences make our business stronger. If you are contacted for a job opportunity and require accommodation, please email careers@holtrenfrew.com and let us know so we can ensure you have an accessible candidate experience throughout the recruitment process. All requests are confidential and used only to meet candidate needs.