Data Modeler_Director P4_Data & Analytics

We're seeking someone to join our team as (Director) Data Modeler who can be key architect of our Data Landscape, responsible for designing, developing and maintaining robust and scalable data models that support our business objectives.

In the Technology division, we leverage innovation to build the connections and capabilities that power our Firm, enabling our clients and colleagues to redefine markets and shape the future of our communities. This is a Data Modeler on the AI platform position at Associate level, which is part of data & analytics Engineering job family that provides specialist data analysis and expertise that drive decision-making and business insights as well as crafting data pipelines, implementing data models, optimizing data processes for improved data accuracy and accessibility, including applying machine learning and AI-based techniques.

Morgan Stanley is an industry leader in financial services, known for mobilizing capital to help governments, corporations, institutions, and individuals around the world achieve their financial goals.

What you'll do in the role:

• Database design and Data Modeling experience
• Strong with SQL with hands-on using Data Modeling tools like Power designer or Erwin
• Experience in any one of the Database like Teradata, SQL Server, Hadoop Hive, Snowflake etc
• Understand and translate business needs into data models supporting strategic solutions.
• Create and maintain conceptual, logical and physical data models along with corresponding metadata.
• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Recommend opportunities for reuse of data models in new environments.
• Perform reverse engineering of physical data models from disparate databases and SQL scripts.

What you'll bring to the role:

• At least 5 years' relevant experience would generally be expected to find the skills required for this role
• Evaluate data models and physical databases for variances and discrepancies.
• Validate business data objects for accuracy and completeness.
• Analyze data-related system integration challenges and propose appropriate solutions.
• Develop data models according to company standards.
• Guide System Analysts, Engineers, Programmers and others on project limitations and capabilities, performance requirements and interfaces.
• Review modifications to existing software to improve efficiency and performance.
• Examine new application design and recommend corrections as required

WHAT YOU CAN EXPECT FROM MORGAN STANLEY:

We are committed to maintaining the first-class service and high standard of excellence that have defined Morgan Stanley for over 89 years. Our values - putting clients first, doing the right thing, leading with exceptional ideas, committing to diversity and inclusion, and giving back - aren't just beliefs, they guide the decisions we make every day to do what's best for our clients, communities and more than 80,000 employees in 1,200 offices across 42 countries. At Morgan Stanley, you'll find an opportunity to work alongside the best and the brightest, in an environment where you are supported and empowered. Our teams are relentless collaborators and creative thinkers, fueled by their diverse backgrounds and experiences. We are proud to support our employees and their families at every point along their work-life journey, offering some of the most attractive and comprehensive employee benefits and perks in the industry. There's also ample opportunity to move about the business for those who show passion and grit in their work.