Data Architect

Key Skills

Java Programming, Risk Analytics, Python Programming, SQL, XML-JSON, RDBMS, Data science techniques, ETL/ELT technologies, Tableau, Snowflake, Data Analytics, Talend, Informatica, Data Architecture, Terabyte scale datasets, Data Warehousing

Job Description

Morgan Stanley is a leading global financial services firm providing a wide range of investment banking, securities, investment management and wealth management services. The Firm's employees serve clients worldwide including corporations, governments and individuals from more than 1,200 offices in 43 countries.

As a market leader, the talent and passion of our people is critical to our success. Together, we share a common set of values rooted in integrity, excellence and strong team ethic. Morgan Stanley can provide a superior foundation for building a professional career - a place for people to learn, to achieve and grow. A philosophy that balances personal lifestyles, perspectives and needs is an important part of our culture.

Technology

Technology works as a strategic partner with Morgan Stanley business units and the world's leading technology companies to redefine how we do business in ever more global, complex, and dynamic financial markets. Morgan Stanley's sizeable investment in technology results in quantitative trading systems, cutting-edge modelling and simulation software, comprehensive risk and security systems, and robust client-relationship capabilities, plus the worldwide infrastructure that forms the backbone of these systems and tools. Our insights, our applications and infrastructure give a competitive edge to clients' businesses?and to our own.

Legal, Compliance, and Governance (LCG) Technology leverages data from across the firm and outside data providers to power applications and data analytics solutions for the Legal, Compliance, and Risk Management functions across the firm.

Position Description

As a Data Architect within the Governance, Risk, and Compliance Technology department you will be responsible for the management of data that is sourced into shared data platforms that are used across Operational Risk, Compliance, Internal Audit and Technology Risk functions within the firm. This includes analysis of requested data feeds and datasets, the rationalization of the data (future and current) that we source and store, the efficient modeling of data as per business and analytics requirements, and the implementation of data validation / data quality controls. You will also be responsible for contributing towards the development and execution of our Data Management strategy, which is largely focused on the migration to and the usage of cloud-based technologies. Lastly, you will be leading a global team of ETL developers, data analysts, and analytics developers.?

Responsibilities include:

• Designing and implementing effective data models and structures that meet our user requirements and analytics needs
• Analyzing our current data stores and determining how to efficiently store data through consolidation, de-duplication, and other data management techniques
• Working closely with our data providers as we source data and maintaining relationships with them throughout the data lifecycle
• Leading a mixed team of ETL Developers, Data Analytics Developers, and Data Analysts to accurately analyze user requirements, to profile incoming data, to source / ingest data, to develop queries, reports, dashboards, and other visualizations, and to document relevant metadata within our data catalog and system dictionary
• Helping ensure that the LCG usage of data adheres to our Firmwide Data Policy, and that proper governance is enforced

Qualifications

Skills Required:

• 10-15 years of Data Architecture / Data Warehousing experience
• 10+ years of experience producing data models to support OLTP and OLAP platforms
• Experience with common ETL / ELT tools (i.e. Informatica, Talend, etc)
• Experience with various data source types (RDBMS, XML, JSON, etc.)
• Strong understanding of dashboarding and reporting tools like Tableau and Cognos
• Experience with Data Cataloging tools and concepts (e.g. Collibra, Alation, etc.)
• Strong oral and written communication skills

Skills Desired:

• Experience with Cloud based platforms such as Snowflake and Databricks
• Experience with Data Federation or Virtualization technologies
• Experience with common Data Science and Data Analytics use-cases and platforms
• Experience with Semantic and Graph data
• Morgan Stanley is an equal opportunity employer. We work to provide a supportive and inclusive environment where all individuals can maximize their full potential.