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.
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
COMPENSATION AND BENEFITS
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 firstname.lastname@example.org