Sr. Data Analyst

We are looking for a Senior Data Analyst / Administrator for the federal government in Ottawa.

Responsibilities

• Analyze and propose alternative data management solutions to meet business requirements;

• Participate in the development of policies, functional designs and guidelines in support of the Siebel CRM data architecture activities;

• Ensure business requirements and initiatives are assessed against all current Enterprise Architecture components;

• Develop and/or maintain application migration strategies to migrate Siebel data to/from legacy databases to meet business and system requirements;

• Provide technical direction and support to the development and business teams by answering questions regarding the Siebel and the Legacy Data Models, how other databases are mapping into the models, and the implementation and use of seed Data;

• Conduct Data Model walkthroughs and analysis of legacy data structures and data content while addressing rules and constraints imposed by the Siebel CRM database;

• Develop implementation procedures for the creation, modification and deletion of Seed Data;

• Design and maintain Seed Data change control processes and conducting Seed Data content analysis to ensure the accuracy and completeness of the data;

• Maintain Seed Data administration tools (e.g. Tool for comparison of Seed Data content between environments);

• Work with Database Administration staff to ensure that Enterprise Integration Manager (EIM) and application loading mechanism are appropriate and effective;

• Review Change Requests and identify Seed Data requirements and impacts; and

Requirements

• At least 10+ years experience as a Database Analyst/ IM Administrator working within an IM/IT environment.

• At least 5 years of experience, within the last 7 years (as of bid closing date), providing both strategic and tactical solutions for developing and maintaining the Data Architecture for a complex Siebel specific project involving multi-platform set of technologies requiring integration.

• Experience managing the development, implementation and migration of Seed Data in a Siebel CRM product.

• Experience in the design and development of data extraction, transformation, loading and data exchange processes using Siebel EIM and database tools.

We thank you for your application, however, only those candidates selected for an interview will be contacted. Candidates must be Canadian Citizen or hold a Permanent Residence Status. If you are interested in applying, create a candidate profile and send us your Resume and Cover Letter.