Job Description

The Global Wealth and Asset Management (GWAM) division is seeking a Data Modeler to support an Investment Data Lake initiative, reporting to the Director of Information Architecture. The role involves designing and implementing data models to enhance data capabilities, enabling better analytics and business processes.

Key Responsibilities

• Translate business needs into conceptual, logical, and physical data models.

• Collaborate with business analysts, developers, and stakeholders to define system requirements.

• Work with Application Development teams to implement data strategies and flows.

• Optimize and maintain data models to ensure high quality, consistency, and reduced redundancy.

• Establish naming conventions, coding practices, and metadata standards.

• Perform reverse engineering of existing databases/SQL scripts.

• Validate data objects for accuracy and completeness.

• Guide teams on data model limitations, performance, and integration.

• Own data definitions, lineage, and documentation.

• Support OLAP, reporting, and analytics initiatives.

Must-Have Skills

1. 5-8 years in IT, with 4+ years in Data Modeling.

2. Expertise in Big Data (Hadoop, Databricks), BI, and Data Warehousing.

3. Strong Data Analysis & Modeling skills (hands-on experience required).

4. Proficiency in Azure, SQL, and RDBMS.

5. Experience with Power Designer or Erwin (data modeling tools).

6. Familiarity with Capital Markets data.

7. Strong communication (verbal & written).

8. Detail-oriented, proactive, and collaborative.

Nice-to-Have Skills

1. Wealth Management / Capital Markets industry experience.

2. Hortonworks/Cloudera Hadoop platform knowledge.