VICDA-2546-Data-Architect

‹ 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 Data Architecture, Data Modeling, ETL Development, Technical Architecture, Administration, and Business Analysis. Proven experience using and supporting SQL and Tableau Servers are key criterion. 
SkillsEDW, BI, Architecture, Modeling, PL/SQL, ETL 
TypeContract 
Project Description 
Experience Required/ Mandatory Skills
  • Minimum of 5 years’ experience, specializing in enterprise-wide Data Warehouse and Business Intelligence (DW/BI) solution architecture design, development and deployment utilizing methodologies and techniques from transactional databases to dimensional data modeling, to wide denormalized Data Marts.
  • Experience in data loading using PL/SQL Scripts and SQL Server Integration Services packages (SSIS), with Hub/Satellite data modeling methodologies, and with TOAD Data modeler (or equivalent).
  • Demonstrated experience designing enhancements and issue resolution to maintain the EDW information architecture and support analytic outputs.
  • A minimum of 7 years of experience in architecture, installation, configuration, and maintenance of related Microsoft technology, and management of a role-based access environment.
  • Knowledge of MS SQL Server architecture with proven experience in database administration for MS SQL Server databases in OLTP, OLAP and SSIS environments including configuration, patching and upgrades, migration release, backup, recovery, database monitoring and security management.
  • A minimum of 3 years of experience with Tableau Server, implementing advanced Tableau features and capabilities, implementing software updates and patches, showing a bias for data security.
  • Ability to create clear visualizations of specific data as required by the Customer and provide feedback of the best approach to visualize the Customer’s request
  • Experience in dimensional modeling using Star and Snowflake Schemas and data analysis to provide Business Intelligence solutions.
  • Demonstrated experience with Release Management processes, ensuring the successful source control and migration of solutions through development into production environments.
  • Extensive experience in architecture design of source table mappings to Extract, Transform, Load data into target environment using ETL Tools in SQL Server databases
  • Proven experience with development and maintenance of the metadata and master data management repositories associated with ETL and related testing solutions.
  • A minimum of seven years’ experience performing a full range of business analysis activities, including leading elicitation of business requirements, documenting and participating in the design process, testing and participating in all aspects of the requirements cycle.
  • A minimum of three years of experience developing data visualizations, interactive outputs and insights which reflect detailed business processes, complex projects, data and the resulting documentation, within a Tableau Server environment.
  • Demonstrated ability to quickly review, analyze, and translate information, business and technical requirements into a meaningful format that can be communicated to both technical and non-technical audiences.
  • Experience analyzing, modelling and communicating business, technical and other system requirements and solution alternatives for technical and non-technical audiences.
 
Nice To Have Skills 
LocationVictoria 
Work Environment1 year with 2 possible 1-year extensions 
Hourly RateNegotiable