Solution Architect (Data Management Solutions)

Solution Architect (Data Management Solutions)

Job Information
Author ecnationtalk
Date April 16, 2015
Type Full Time
Company Scotiabank
Location Toronto, ON
Category Internet Engineering
Client Scotiabank
Contact Information
To apply for this position please CLICK HERE





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

A Best Workplace

Scotiabank is a premier financial institution and Canada’s most international bank recognized as a Best Workplace®, in Canada, Mexico, El Salvador, Costa Rica, Puerto Rico, Dominican Republic, Panama, Peru, Chile and Latin America by the Great Place to Work® Institute.

A multinational winning team
Scotiabank is Canada’s international bank and a leading financial services provider in North America, Latin America, the Caribbean and Central America, and parts of Asia. We are dedicated to helping our 21 million customers become better off through a broad range of advice, products and services, including personal and commercial banking, wealth management, corporate and investment banking.

Corporate Social Responsibility
Scotiabank helps to build bright futures worldwide through ethical banking practices, environmental awareness and a commitment to communities.

By working together, we build strong relationships and create value for our customers. Scotiabank’s Information Technology and Solutions provides global technology solutions support to each of our core businesses – Domestic Banking, International Banking, Global Banking & Markets and Global Wealth & Insurance. Our technology-based solutions enable Scotiabank to achieve sustained profitable growth and a competitive advantage.


Data Management Solutions provides enterprise wide data collection/consolidation and relevant data services and support for core business lines within the Scotiabank Group. The environment used leverages IBM Information Server and the InfoSphere Product Suites including DataStage, Quality Stage, Metadata Workbench, Business Glossary, and Information Analyzer. Information Server is used in the Department for Extraction, Transformation, Load (ETL) processing as well as Data Quality, Profiling, custom business logics for data dissemination.

Reporting to the Director Development, the Solutions Architect will have solid technical experience in the implementation of technology solutions in the financial industry. The Department supports multiple Risk Departments in the Bank; hence the Solutions Architect must have a good understanding of bank’s business and their risk domains and data associated with measurement of risk.

The Solutions Architect must be resourceful and knowledgeable on industry trend of available technologies that supports data management including data lineage, data governance, data quality measurement and remediation controls. Hence the candidate is required to have track record in providing total solutions for either data warehouse or operational data store and data provider/consumption application model.

To join our team, you must be a leader, proactive, dynamic, with excellent verbal/written communication skill, and be able to work independently and demonstrate initiative. Be able to work under pressure, and adaptive to a fast pace environment and thrive on challenge.


1. Participate in all aspects of a system development life cycle within the technology team (lead requirement analysis, solution design, development best practice, test methodology, implementation strategy, and production support).
2. Lead the evolution of Systems or Software Development Lifecycle (SDLC) best practice that adapts to data management solutions and, but not limited to, Risk Data Aggregation Regulatory Reporting (RDARR) Compliance.
3. Technical documentation, including Solution Architecture and Detail Design and Operational Control documentation.
4. Ownership and strong knowledge of data that resides in the Enterprise Operational Store in our Department.
5. Lead development/design/coding best practice on DataStage ETL job design, InfoServer tool usages, and AIX/DB2 infrastructure.
6. Conduct and lead review sessions on development, integrations, and implementation plans, processes and procedures.
7. Liaison with the bank’s Business Areas, such as Global Risk Management and the bank’s technical areas to address business requirement, technical implementation, data attributes, application design, system integration, security and network/communication issues and project coordination.
8. Support the Delivery Manager on project planning and in engaging project stakeholders.
9. Production support and escalation. Be ready to be available for off-hour escalation for critical decisions and recommendations to support and protect production environment from unplanned outages.
10. Own Solutions Architecture Roadmap and create plans for its execution including presentations for stakeholder buy-in.


* Excellent written/verbal communication & presentation skills.
* Minimum 7 to 10 years of hands-on technical working experience in developing and supporting applications on an operational data platform or Data Warehousing platform, both with Online and Batch processing.
* Knowledge of Financial Data in the Capital Market Product area and Bank’s reference data is essential.
* Currently a Solution Architect on total solutioning for a bank’s Risk Management or Capital Management or Capital Market or Securities Business Lines.
* Strong knowledge with the following technologies: UNIX/AIX, DB2 or Oracle or other major RDBMS, IBM Infosphere or equivalent Data ETL/Data Management platforms, reporting platforms such as Cognos; Unix shell scripting, Perl & MS SQL.
* Strong working experience with infrastructures and data management concept and technologies (security standards, file transfer and security, data confidentiality/security assessment, data privacy/encryption, disaster backup recovery options and setup, database modeling tools, database performance measurement, etc… )
* Familiar with SAS.
* Track record in leadership of project/development life-cycle methodology and software development technologies and concepts.
* Strong troubleshooting and problem solving skills, have vision and innovative approach to computing based solutions and ability to convey these ideas.
* Must be flexible to adapt to a dynamic environment, make quick and sound decisions under pressure.
* Be able to lead and guide discussions internally and externally for business and technical solutions, and for problem resolutions.
* Working experience in data modelling, data analysis, Office of the Superintendent of Financial Institutions’ (OSFI) data control principles, and application of Data Management disciplines are assets.
* Some working knowledge on .NET, MS SQL Server, and data security.


Computer Science Degree or equivalent.

Scotiabank is an equal opportunity employer and welcomes applications from all interested parties. We thank you for your interest, however, only those candidates selected for an interview will be contacted. No agencies please.

To apply for this position please CLICK HERE

Send To Friend Email Print Story

NationTalk Partners & Sponsors Learn More