EALDW-1832-Data-Warehouse

‹ Back to Current Opportunities

Please contact human resources if you have any questions.

Vantix Systems Inc. is a dynamic and savvy organization based in Edmonton, Alberta, Canada. We are looking for creative and talented professionals to join our team.

Job Opportunity
DescriptionOur client requires a DW Architect/Analyst to participate in the continuing improvement, development and support of the Workforce Reporting Platform (WRP), a data mart and business intelligence solution. The goal of WRP is to improve the consistency, timeliness, accessibility, accuracy and relevance of workforce data through architecture and technology upgrades. 
SkillsBI,SQL SERVER, WINDOWS 
TypeContract 
Project Description 
Experience Required/ Mandatory Skills
  • 3 years working in a data warehouse/business intelligence environment in a development or support role
  • 2 years working on a project through all stages from initiation to implementation
  • 2 years writing documentation (for example, impact analysis, data definitions, technical design specifications, operations manual, test plans)
  • 2 years developing data models
  • 2 years working in a Windows operating system environment
  • 2 years working in a SQL Server environment
  • 2 years creating SQL Server stored procedures
  • 2 years using SQL Server Query Analyzer and T-SQL
  • 2 years creating SQL Server tables and views
 
Nice To Have Skills
  • Experience dealing directly with clients
  • Experience querying and analyzing data sources to understand the data and determine logic for data transformations
  • Experience in designing and developing data marts
  • Experience with current versions of SQL Server environment
  • Experience in capturing metadata
  • Experience with Microsoft BI technology
  • Experience using Microsoft Visio to create diagrams or process models
  • Experience designing, developing and maintaining ETL processes
  • Experience using an ETL tool (excluding Microsoft DTS and Data Stage)
  • Experience using SQL Server Data Transformation Services (DTS) to import/export to/from flat files, SQL tables, Access tables
  • Experience with SQL Server 2012 on Windows 2010
  • Formal training or education in business intelligence and data warehouse management (TDWI or equivalent)
 
LocationEdmonton 
Work Environment6 months + 2 pos. 6 month extensions  
Hourly RateNegotiable