EALDW-1719-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 technical resource (Data Warehouse Architect, Developer/Analyst) to provide IT expertise. This is a senior technical resource leading a team of matured BI practitioners. The successful candidate will bring up to date knowledge on technology, expertise in applying emergent BI technologies and industry BI practices to data warehouse and analytics management in project and enhancement and operational works. 
Skills 
Type 
Project Description 
Experience Required/ Mandatory Skills
  • 3+ years of related experience working in a data warehouse/business intelligence environment in a development or support role
  • 2+ years of related experience working on a project through all stages from initiation to implementation
  • 2+ years of related experience writing documentation (for example, impact analysis, data definitions, technical design specifications, operations manual, test plans)
  • 2+ years of related experience developing data models
  • 2+ years of related experience working in a Windows operating system environment
  • 2+ years of related experience working in a SQL Server environment
  • 2+ years of related experience creating SQL Server stored procedures
  • 2+ years of related experience using SQL Server Query Analyzer and T-SQL
  • 2+ years of related experience creating SQL Server tables and views
  • Experience and knowledge in BI Technology specifically in Power BI, SSRS, SSAS
  • Experience and knowledge in designing, developing and implementation of data cubes
  • Experience and knowledge in implementing Self Serve BI
  • Experience in gathering and defining analytic requirements from the business areas
  • Practical experience in the agile / scrum methodology
  • Leading and developing MVP (minimum viable product)
 
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 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 with current version of SQL Server environment
  • Experience working in a Windows Office 2007 or newer environment
  • Experience in capturing metadata
  • Experience with Microsoft BI technology
  • Experience with SQL Server 2012 on Windows 2010
  • Formal training or education in business intelligence and data warehouse management (TDWI or equivalent)
 
LocationEdmonton 
Work Environment3 months with optional 2+ year extension 
Hourly RateNegotiable