Overview

Technical Data Analyst

Remote / Hybrid (Ottawa, Ontario, Canada)

federal Government Security clearance or ability of uptain one

Primary Responsibilities

· Understand client requirements and convert the ask into technical terms/user stories.

· Capture data requirements to support creation of multiple streams of data into our client’s data warehouse

· Researching and documenting data mart inputs and outputs. Source to target mapping, business rules applied to ETL.

· Understanding system data elements and existing data structures, as well as, data lineage connecting source to target.

· Identify data dependencies and carry out impact assessments

· Proactively identify opportunities for process, systems, and other efficiency improvements

· Design data integration/ETL jobs using DataStage and its foundation tools in a SQL server and windows environment

· Developing a pla...