Data Modeler/Architect

Our client offers the stability of a company that has a 135 year history and is part of a leader in global banking and financial services and one of the 6 strongest banks in the world. Currently this company has an offering for an experienced Data Modeler/Architect capable of working in a large enterprise environment.

This candidate will be responsible for the development and on-going support of a new data warehouse environment which will be used to support much of the client's Business Intelligence (BI) and analytic system requirements. Analyzes and develops conceptual, logical and physical data models, and corresponding meta data definitions for the enterprise environment and all associated data marts, data stores, etc.

JOB DESCRIPTION

- Understand the Project Proposal and assist the team in analysing how the new system or functionality can be integrated in the environment, identifying existing systems, concepts, possible data sources and issues.
- Develop, validate and communicate modelling solutions, including both relational and dimensional models.
- Analyze data-related systems integration opportunities and challenges.
- Ensure solution designs address performance requirements and reusability, availability, integrity and security challenges, and business functional requirements.
- Develop, maintain and enforce data architecture-related standards.
- Partner directly with the data architect, clients, ETL developers, other technical data warehouse team members and database administrators to design and develop high performing databases and maintain consistent data element definitions.
- Coordinate the Data definitions:
- Build a glossary (terms and KPIs).
- Create conceptual data models that need to be validated with Business Users for current projects as well as other impacted projects.
- Define source systems considering correct data, frequency and history.
- Create an Enterprise Data model (logical and physical).
- Support Data Quality team.

QUALIFICATIONS

- BS degree in Exact Area: Systems Analysis, Computer Science, Software Engineering, or Information Systems
- 7+ years' experience in a DATA ARCHITECT role with deep knowledge of Enterprise Data Architecture concepts
- Expertise in Relational Data Models (conceptual, logical and physical data models), Dimensional Data Models, Data Dictionary and Metadata
- Strong System Integrations and Business Intelligence project experience
- Familiarity with Retail and Commercial banking, Mortgage and Dealer lending concepts desired
- Experience with Development Methodologies, Databases Platforms (Teradata, Oracle/SQL Server), including SQL Commands and Project Manager concepts
- Expertise in Data Modeling tools (ERWin/Model Manager)
- Superior relationship management, consultative, presentation, and communications skills