Data Warehouse Automation Architect / WhereScape Consultant

Location: Vancouver, BC


  • We are looking for a passionate Data Warehouse Automation Architect to join our fast growing team focused on efficiently implementing effective Data Warehouse solutions for our clients.

  • In this role you will work with next generation data warehouse technologies and frameworks (eg. Snowflake and WhereScape)

  • We are looking for someone with strong development background in data warehouse automation or a desire / track record to automate tasks rather than performing recurring tasks.


DUTIES AND RESPONSIBILITIES                                   

  • Analyze business and system requirements to determine best use of Data Warehouse technologies in the client’s environment.

  • Translate business requirements into Data Warehouse models and develop end-user/business-oriented Data Models.

  • Provide production support, including working with clients to identify issues and to ensure ongoing customer satisfaction.


ESSENTIAL QUALIFICATIONS                                    

  • 5+ years of ETL/ELT Development experience

  • 2+ years Data Vault Modelling and Automation Patterns

  • 2+ years Dimensional Modelling and Automation Patterns

  • Excellent knowledge of MS SQL and/or Oracle PL/SQL

  • Familiarity with basic shell scripts

  • Full system development life cycle (SDLC) experience.

  • Advanced SQL knowledge, database knowledge and data modeling knowledge are a must

  • Educational or professional background in computer science or business administration

  • Profound knowledge of programming, databases, networking and PC operating systems/platforms

  • Outstanding communication and interpersonal skills

  • Outstanding problem solving and analytical skills

  • Thinker and Planner


  • Data Warehouse or Data Mart Development Experience using WhereScape RED

  • Data Warehouse Modelling using WhereScape 3D

  • Snowflake Data Warehouse

  • Qlik


  • We offer a competitive base salary based on experience, a performance bonus, profit sharing and a benefits plan.


Ready to join a passionate, fun team in a challenging environment with lots of personal growth opportunities? Then send your resume to