ETL Data Analyst - 6 Month Contract

Ontario (ON)  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Keywords

Description

ETL Data Analyst - 6 Month Contract

Company: Direct IT Recruiting Inc.

Location: Toronto

Position: 6 Month Contract

Job Category: ETL Data Analysis

Career Level: Skilled Non-Manager     

Work Experience:
7+ years as an ETL Data Analyst, 5 years of DataStage, SSIS, SSRS, Mainframe, DB2, SQL Queries, SQL Scripting, Data Mapping, Web Services, MQ, Agile

Industry: Government

DESCRIPTION:

The Data Analyst is responsible for the design of the ETL (extract, transform, and load) processes, data profiling, and data quality processes. The position will contribute to the development of data models and ETL processes. This position is mainly focused on data mappings (source to target) in support of the ETL Developers, Business Intelligence reporting and/or ETL development.

RESPONSIBILITIES:

  • Develop source to target mapping documentation supporting ETL processes
  • Perform complex data analysis across platforms using Entity Relationship Diagrams (ERDs).
  • Work with the ETL Architect to handle, clean, and merge data using ETL (Extract, Transform, and Load) standards and methodologies.
  • Ensure newly generated data is mapped to Data Mart, ODS, and/or Data Warehouse.
  • Identify problems and inaccuracies in databases. In collaboration with the Data Architect, assist in developing decision rules for handling data problems.
  • Apply rules consistently to correct data problems. 
  • Develop and maintain protocols for how to handle, process, and clean data. 
  • Work with Data Architect to document how data problems were identified and corrected.
  • Support the workload and priorities of other Data Analysts which includes change requests, support tickets and ad hoc requests as needed.
  • Develop and maintain the workflow processes for all reporting requests

MANDATORY SKILLS:

  • 5+ years experience in a data warehouse environment with SQL and data analysis experience
  • Post secondary education in Computer Science, Software Engineering or equivalent.
  • Expert hands-on knowledge of SQL.
  • Experience in an Oracle production environment.
  • 5+ years experience using DataStage
  • ETL tools such as SSIS and SSRS.
  • Strong and recent experience supporting the design and development of data models for a data warehouse environment
  • Strong relationship management and collaboration skills.
  • Excellent written and verbal communication skills.
  • Ability to work with a minimal amount of direction while being pro-active in keeping their management informed of project related issues.
  • Ability to establish and maintain effective working relationships.
  • Demonstrated ability to use discretion and make sound decisions.
  • Knowledge of relational databases; design, structure, data associations, and query language.
  • Proficient with Microsoft Office.
Start date
Immediately
Duration
6 months
From
Direct IT Recruiting INC.
Published at
29.08.2013
Project ID:
590681
Contract type
Freelance
To apply to this project you must log in.
Register