EALDW-1619-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 senior consultant to provide expertise to deliver a short term strategic (stop gap) data mart and business intelligence solution. The solution will help improve efficiencies and effectiveness and minimize inconsistency when reporting on data. The consultant will work closely with a workforce analyst team and internal Information Technology professionals to deliver the solution.  
SkillsBI strategy, data governance development, SAS, Tableau, Power BI, SQL Server, SharePoint 
TypeContract 
Project Description 
Experience Required/ Mandatory Skills
  • Experience working in a data warehouse/business intelligence environment in a development or support role (3+ years)
  • Experience working on a project through all stages from initiation to implementation (2+ years)
  • Experience writing documentation (for example, 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 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 (2+ years)
 
Nice To Have Skills
  • Experience in delivering solutions under tight timelines
  • Experience in leading development of BI strategy
  • Experience in developing data governance model and data stewardship strategy is a strong asset.
  • Experience in developing performance measures is a strong asset.
  • Experience in using statistical analysis tools such as SAS
  • Experience in BI tools such as Tableau and Power BI is a strong asset.
  • Experience in Microsoft SQL Server 2016
  • Experience in Microsoft SharePoint
  • 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 designing, developing and maintaining ETL processes
  • Experience using IBM WebSphere DataStage ETL tool
  • Experience using an ETL tool (excluding Microsoft DTS and DataStage)
  • Experience using SQL Server Data Transformation Services (DTS) 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
  • Experience working in a Windows Office 2007 or newer environment
  • Experience in capturing metadata
  • Experience with Microsoft BI technology
  • Formal training or education in business intelligence and data warehouse management (TDWI or equivalent)
 
LocationEdmonton 
Work Environment6 months with possbility of up to a 6 month extension 
Hourly RateNegotiable