Share this Job

Title:  Senior Data Analyst - Scarborough

 

 

 

Requisition ID: 68025

 

Join the Global Community of Scotiabankers to help customers become better off.

 

 

OVERVIEW

 

Data Architecture Services (DAS) manages the collective data asset for the Canadian Bank.  The database analyst advisory must develop and promote strategies, roadmaps, architectural guidelines, standards and best practices for the evolving enterprise information management practice ,Analysis of source systems data (structured and un-structured) and business requirements ,Ensure compliance to Enterprise Data Office guidelines, best practices, Enterprise Security guidelines and policies .

 

 

WHAT WE ARE LOOKING FOR?

We are looking for someone who will work closely with application owners and business users to analyses source systems data, structured and un-structured, and business requirements.

 

  • Design and develop conceptual, logical and physical data models for the operational and analytical databases.
  • Maintain technical and business metadata in IGC.
  • Build source to target mappings, transformation and architecture artefacts.
  • Ensure compliance to Enterprise Data Office guidelines, best practices, Enterprise security guidelines and policies.
  • Work closely with the technical, application architects, developers and DBAs to implement the solution architecture and database implementation.
  • Document data flows, identify appropriate data sources and manage redundancy.
  • Manage data integrity and data quality.
  • Design data structures and document data meanings, definitions and intended use, work with various departments/leaders and data stewards to make the “metadata” available.
  • Define and document the data architecture for operational databases, reporting and provisioning platforms, including the physical components and their functionality.
  • Provide recommendations into the selection, use and positioning of hardware, storage, and software products to support data architecture requirements. Support Data Office guidelines and processes.
  • Provide leadership in researching and architecting emerging technology solutions to meet business objectives.

.

 

ARE YOU THE RIGHT PERSON FOR THE ROLE?

You Have;

 

  • Relational and dimensional data modeling and database design.
  • Ability to translate business needs into technical solutions. Strong analytical skills.
  • Knowledge of database administration, database performance tuning, source & target data structures, ETL processes & products.
  • Knowledge of data architectural approaches, patterns and emerging technologies.
  • Experience creating architecture and strategy documentation.
  • Strong SQL and Erwin skills.
  • Experience with XML, JSON, Hive (Hadoop), Cloud platforms.
  • Strong communication skills.
  • Nice to have: Experience working in agile environment.

 

WHAT’S IN IT FOR YOU?

 

  • The opportunity to join a forward-thinking company surrounded by a collaborative team of innovative thinkers.
  • A great opportunity to leave your “stamp” as we are undergoing multiple exciting and forward thinking initiatives.
  • A rewarding career path with diverse opportunities for professional development.
  • Internal development to support your growth and enhance your skills.
  • A competitive compensation and benefits package.
  • An organization committed to making a difference in our communities– for you and our customers.
  • We have an inclusive and collaborative working environment that encourages creativity, curiosity, and celebrates success!

 

 

Location(s):  Canada : Ontario : Scarborough 

As Canada's International Bank, we are a diverse and global team. We speak more than 100 languages with backgrounds from more than 120 countries. We value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. If you require accommodation (including, but not limited to, an accessible interview site, alternate format documents, ASL Interpreter, or Assistive Technology) during the recruitment and selection process, please let our Recruitment team know. If you require technical assistance please click here. Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at Scotiabank; however, only those candidates who are selected for an interview will be contacted.


Job Segment: Database, Data Analyst, Developer, SQL, XML, Technology, Data