Business Intelligence/Data Warehouse Architect

Employment type: Full-time
City: Edmonton
Last visit: 2014-10-30
Author's ads: 1

Posted: 2014-10-30


• Teamwork • Fun • Service • Community •

Liquor Depot is a great place to work, with a friendly atmosphere and energetic work environment. We provide our Customers with convenience, selection, and top notch service!

Each person at Liquor Depot plays an important role in our Company's success. We promote a team atmosphere that is busy and challenging, but always aims to be co-operative and fun. When you choose to work at Liquor Depot you can be sure you will be treated with the respect and support you need to be a success.

Job Opportunity

We are North America's largest publicly traded retailer of adult beverages operating 240+ stores within Alberta, British Columbia, Kentucky and Alaska.

Reporting directly to the Director of Business Applications, this position’s primary objective is to work across Technology and Business teams to create the future for Information and Analytics in Finance, Merchandising and other key areas within our retail business.

What you will be doing:

Be responsible for designing technology architecture for Information and Analytics, which will adequately support the enterprise vision of the organization.

Drive a consistent data architecture approach across the organization: contribute to and communicate data architecture standards & guidelines

Work with the Business Analyst, Project Managers and business people to deliver high quality Information and Analytics projects.

Evaluate new Technologies for innovation and improvement of Information and Analytics efficiency, cost effectiveness and additional capabilities.

Ensure a governance model  so that project designs are in compliance with data architecture standards

Work across Liquor Stores to emphasize and enable a shared data vision

Collaborate in defining Liquor Stores strategy around data management initiatives including, Master Data Management (MDM) and Data Quality (DQ)

Work on the most complex projects that contribute to the overall strategic vision of the organization.

Integrate a broad range of ideas regarding technical architecture and develop strategies for migration toward the architectural vision.

Use strong collaborative skills to work across multiple stakeholder groups to translate business strategies, initiatives, goals and objectives into data management proposals.

Employ strategic thinking to participate in planning, design and policy development related to Data Architecture and Information management.

Use storytelling techniques to translate technical concepts and break down complex situations into easily understandable communications - visual, written and verbal that can be understood by less technically oriented stakeholders, including senior executives

Be visionary, grounded in reality, with the ability to think conceptually, suggest solutions, provide functional expertise and bring the big picture perspective.

Provide thought leadership, create strategies and make recommendations on a wide variety of complex issues having a significant and strategic impact on processes and the business.

Continuously develop and maintain an understanding of Business Intelligence technology and architecture, including, dimensional modeling, OLAP functionality, reporting tools, and other methods of information delivery

Develop & maintain expertise with MSBI tools including: Excel/PowerPivot, SSRS, PerformancePoint, SSIS, & SSAS/BISM

Develop database and/or data presentation solutions to deliver information to end-users accurately and efficiently

Working knowledge and experience of working and reporting on SAP, SAP HANA and BusinessObjects

Extract, transform, and load data using data management tools and T-SQL

Contribute to, and possibly lead, project teams that are developing or modifying highly complex information solutions

Administer and maintain the BI Portal, and existing BI solutions

What you must have:

Bachelor's degree in Business, Computer Science, Information Systems or a related field required.

8+ years professional experience in the concepts of complex Business Intelligence, Information or Data Architecture, with internal and external design, capabilities required

Expert knowledge of Business Intelligence and Analytics technologies required

5+ years Data architecture and/or Data Warehousing experience required

3+ Experience with Data Modeling Software and Processes required

3+ years of experience utilizing data visualization tools like Tableau preferred

Experience with balancing usability, data integrity, and performance

Experience in learning and adapting quickly to new tools and new business situations

Strong Team player who can define and enforce data standards

Proven ability to communicate technical concepts to non-technical team members

Strong verbal and written communication skills

Experience interfacing with and presenting to senior business leaders

Understanding of industry trends; ability to recognize potential risks and benefits to Liquor Stores

What you must value:

Knowing that your routine is in fact, not routine

Have ‘attention to detail’ as your middle name

Creation and promotion of an environment where people are on-side and feel a collective sense of success.

Be comfortable communicating with all levels of management and peers

Take ownership and drive forward

Get things done!

If you are interested in this position please submit your resume and cover letter to Robbie Madan, Director of IT, Business Applications at

We will treat you right.

At Liquor Depot we invest in our people. We provide educational reimbursement for industry related courses. We prefer to promote individuals from within the organization providing our employees excellent opportunities to advance their careers.

Additional reasons to join our Team!

Competitive salary and benefits

Flexible hours

Employee Discount

Free Uniforms

Contests and prizes

Product Knowledge training

Why is this a great place to work? Learn more

We are always looking for GREAT people to join our team!

Career Level: Experienced

Years of Relevant Experience: 8 Years

Education: Bachelors (Including Honours)

Industry: Retail Head Office and Warehouse

Job Function: Technology and Digital Media