Our site uses modern web tools not supported by your browser. For the best experience on our site,
please upgrade to the latest version of your preferred browser using the settings menu.

Our site requires Javascript. Please check that you have Javascript
enabled in your browser settings and are using a browser which supports it.

Close
Hide

Exclude any of the below options from the search results:

Data Architect Job expired

Standard job
Recruiter
JOBG8
Location
Canada
Job term
Permanent
Job hours
Full time

Overall Accountabilities:

The Data Architect will be responsible for providing data architecture and modelling services for Online Transaction Processing (OLTP) system, enterprise Datawarehouse and master data management systems for all IFDS application. The Data Architect will interact with internal stakeholders on multiple projects to facilitate the collection of information requirements as well as the development and management of conceptual, logical and physical data models to support the needs of the business. The Data Architect will also define sound data architecture and modelling standards and practices for the transactional system and Datawarehouse systems.

General Role & Responsibilities:

* Manage the development and communication of data management strategies, principles, standards and best practices

* Develop and maintain both operational and Datawarehouse conceptual, logical and physical data models

* Provide project level design and data modelling support through ERD modelling and data design

* Identify opportunities for data alignment and re-use of data constructs

* Implement principles, policies, standards and guidelines for data management and design

* Manage and maintain the data model library and data inventory

* Partner with Business Analysts and Solution Architect to gather business, data and reporting requirements and translate the business needs into logical data structures

* Review and approve data designs

* Maintain a level of expertise for the strategic modelling tool CA Erwin

* Control data model changes through active involvement throughout the project life cycle, as well as reviewing and approving data designs

* Work with DBA's to ensure optimum data performance

* Support the DBA's and Solution Architects to provide the best solutions to meet current project needs to align with strategic direction

Competencies:

(Behavioral and Functional)

Critical

* Minimum of 5-7 years of data architecture experience

* University degree in Computer Science, Computer Engineering or equivalent degree

* Experience in data modelling and database design on large projects

* Experience with meta data management, data stewardship, data quality, IT governance, Enterprise Data Models, and Enterprise Frameworks

* Experience with operational data store design skills and Datawarehouse fundamentals

* Experience with data mart access models and dimensional modelling skills

* Intimate knowledge of the software development life cycle

* Team player with leadership skills

* Strong analytical and problem solving skills

* Demonstrates sound judgment and initiative

* Attention to detail and ability to work effectively under time constraints

* Ability to exhibit maturity, reliability and stability by adhering to commitments is critical in order to maintain business credibility

* Strong written and verbal skills

Beneficial

* Datamodelling experience in Mutual fund applications and/or any other financial applications

* Understanding columnar DB considered as an asset

* Understanding iFast application would be a definite asset

* Programming experience would be an asset

* Understanding columnar DB considered as an asset

Status
Job expired
Contact
HR
Posted
Reference
5184437

Register

Please enter a personal, not work, email address.

What should I enter?

Password tips

To make your password strong:

  • 8 characters minimum, the longer the better
  • Use upper and lowercase letters, numbers and punctuation
  • Don't use easily guessable words like your name or email or the site name
  • Don't use a password you already use on another system
  • Change your password regularly

By clicking Register you agree to our Terms and Conditions, Privacy Policy and Cookie Policy

Use another account What does this mean?

Log in

I've forgotten my password

No account? It's free to register

Use another account What does this mean?

Forgotten password

Enter your email address, and we'll send you a link to reset your password

If is in our records we will send a link to reset your password to that address.

Having problems?

Please check the spelling of the email address one more time.

If you don't receive the email, check your junk email folder.

If you're still having problems, contact us.

Sorry, there's been a problem sending your password reset request.

Please try again later.

Close

Continue application

This job application must be completed on the recruiter’s website.

Yes, continue applying No thanks