Database Analyst Level 2 – Ottawa

  • Company:
    BDO Canada LLP
  • Location:
  • Salary:
    negotiable / monthly
  • Job type:
  • Posted:
    17 hours ago
  • Category:

Our Ottawa office is looking for several Intermediate Database Analyst/IM Administrator to join the Consulting team as a client-facing Agile Talent Consultant/Independent Contractor, and own the following responsibilities: Participate in project teams, as required, to support the Business Transformation Architect and Project Authority; Provide consulting expertise, direction and guidance to the Project Authority and project teams on database structures and efficient use of data; Review, analyze and advise database conversion specifications and conversion strategies; Support the Project Authority, project teams and end users to maintain and safeguard databases; Identify requirements for improvements to existing databases by determining users information requirements and system performance and functional requirements; Develop and implement procedures that will ensure the accuracy, completeness and timeliness of stored data; Analyze and evaluate alternative technology solutions to meet business and application requirements; Review, analyze and advise on functional data requirements and supporting technology; Work with client, Regional IT and project team in gathering, analyzing, and documenting business requirements for data migration; Create logical data model of the integration of the source systems; Work with project team to assist with data migration audit, reconciliation and exception reporting; Work with project team to assist with data quality assurance of the migrated data; Support the BTA and Project Authority with related workshops and briefings for senior management, as required; and Provide regular status updates to Project Authority. Requirements Your experience and education Must have over ten (10) years of experience as a Technical Architect and/or an ETL Specialist/Developer and/or a Data Scientist Must have experience providing Technical Architecture or Database Management services on at least three (3) Government of Canada/Crown Corporation IT Transformation projects Must have a solid understanding of relational database design and modelling Must have a working knowledge of enterprise architecture tools Must have an advanced knowledge of data modelling and data migration software tools Must have a relevant University degree or a certification in Database Administration such as the ones issued by Oracle, Microsoft, IBM, MongoDB, Casandra, etc. Must hold a valid Government of Canada Secret security clearance