EDWAADE1008 - Data Warehouse Architect/Analyst/Developer

‹ 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
DescriptionThe successful candidates for this position requires 3 years experience working in a data warehouse/business intelligence environment in a development or support role. They must have 2 years demonstrated experience with a project through all stages from initiation to implementation 
SkillsWindows Operating System, SQL Server 7/2000 SQL Server Query Analyzer T-SQL and SQL Server Tables and Views 
TypeContract or Permanent 
Project Description 
Experience Required/ Mandatory Skills
  • 3 years experience in a data warehouse/business intelligence environment in a development or support role
  • 2 years experience working with a project through all stages from initiation to implementation
  • 2 years experience writing documentation (E.g. impact analysis, data definitions, technical design specifications, operations manual, test plans
  • 2 years experience developing data models
  • 2 years experience working in a Windows operating system environment
  • 2 years experience working in a SQL Server 7/2000 environment
  • 2 years experience creating SQL Server stored procedures
  • 2 years experience using SQL Server Query Analyzer and T-SQL
  • 2 years experience 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 designing and developing data marts
  • Experience using IBM Websphere DataStage ETL tool
  • Experience using an ETL tool (excluding Microsoft DTS and Datastage
  • Experience using SQL Server Data transformation to import/export to/from flat files, SQL tables, Access tables
  • Experience with IBM Websphere Metastage tool
  • Experience using Microsoft Visio to create diagrams or process models
  • Experience using Visual Source Safe for code version control
  • Experience using Oracle PL/SQL and SQL PLUS
 
LocationEdmonton 
Work EnvironmentAll work to be done on client site 
Hourly Ratenegotiable