Data Warehouse
Architect/Analyst/Developer
Architect/Analyst/Developer
ARC Business Solutions Inc. is an
established, growing and customer oriented information technology solution
provider with proven abilities to incorporate strategy, creativity and
technical aspects into business solutions. Core business verticals are:
Professional IT Services, Enterprise Content Management, Utility Services
and Managed Services.
established, growing and customer oriented information technology solution
provider with proven abilities to incorporate strategy, creativity and
technical aspects into business solutions. Core business verticals are:
Professional IT Services, Enterprise Content Management, Utility Services
and Managed Services.
ARC Business Solutions
Inc. Is
currently seeking a Data Warehouse Architect/Analyst/Developer for an immediate
opportunity in Edmonton, AB.
Role: Data Warehouse
Architect/Analyst/Developer
Architect/Analyst/Developer
Skills & Experience
The Successful Candidate will have
demonstrated experience in the following:
demonstrated experience in the following:
Mandatory Experience:
•Experience working in a data
warehouse/business intelligence environment in a development or support role –
three (3) years
warehouse/business intelligence environment in a development or support role –
three (3) years
•Experience working on a project
through all stages from initiation to implementation – two (2) years
through all stages from initiation to implementation – two (2) years
•Experience writing documentation
(for example, impact analysis, data definitions, technical design
specifications, operations manual, test plans) – two (2) years
(for example, impact analysis, data definitions, technical design
specifications, operations manual, test plans) – two (2) years
•Experience developing data models –
two (2) years
two (2) years
•Experience working in a Windows
operating system environment – two (2) years
operating system environment – two (2) years
•Experience working in a SQL Server
environment – two (2) years
environment – two (2) years
•Experience creating SQL Server
stored procedures – two (2) years
stored procedures – two (2) years
•Experience using SQL Server Query
Analyzer and T-SQL – two (2) years
Analyzer and T-SQL – two (2) years
•Experience creating SQL Server
tables and views – two (2) years
tables and views – two (2) years
Desirable Experience:
•Experience dealing directly with
clients
clients
•Experience querying and analyzing
data sources to understand the data and determine logic for data
transformations
data sources to understand the data and determine logic for data
transformations
•Experience in designing and
developing data marts
developing data marts
•Experience designing, developing
and maintaining ETL processes
and maintaining ETL processes
•Experience using IBM WebSphere
DataStage ETL tool
DataStage ETL tool
•Experience using an ETL tool
(excluding Microsoft DTS and DataStage)
(excluding Microsoft DTS and DataStage)
•Experience using SQL Server Data
Transformation Services (DTS) to import/export to/from flat files, SQL tables,
Access tables
Transformation Services (DTS) to import/export to/from flat files, SQL tables,
Access tables
•Experience with IBM WebSphere
MetaStage tool
MetaStage tool
•Experience using Microsoft Visio to
create diagrams or process models
create diagrams or process models
•Experience using Visual Source Safe
for code version control
for code version control
•Experience using Oracle PLSQL and
SQL PLUS
SQL PLUS
•Experience with current versions of
SQL Server environment
SQL Server environment
•Experience working in a Windows
Office 2007 or newer environment
Office 2007 or newer environment
•Experience in capturing metadata
•Experience with post-secondary
education or education systems.
education or education systems.
•Experience with IAE’s LIFe/LIMS
enterprise architecture framework
enterprise architecture framework
We offer a competitive salary,
profit sharing, and comprehensive benefits package. We thank all
applicants for their interest, however, only candidates considered for
interviews will be contacted. We will be conducting interviews
immediately.
profit sharing, and comprehensive benefits package. We thank all
applicants for their interest, however, only candidates considered for
interviews will be contacted. We will be conducting interviews
immediately.
To be considered, please forward
your resume clearly displaying reference number GM:DWA in the subject line, to
hr@arcbus.com.
your resume clearly displaying reference number GM:DWA in the subject line, to
hr@arcbus.com.