Lead Data Engineer - Parametric

ABOUT MORGAN STANLEY
Morgan Stanley is a leading global financial services firm providing a wide range of investment banking, securities, wealth management and investment management services. With offices in more than 41 countries, the Firm's employees serve clients worldwide including corporations, governments, institutions and individuals. For further information about Morgan Stanley, please visit www.morganstanley.com.

ABOUT PARAMETRIC
Parametric is part of Morgan Stanley Investment Management, the asset management division of Morgan Stanley. We partner with advisors, institutions, and consultants to build portfolios focused on what's important to them and their clients. A leader in custom solutions for more than 30 years, we help investors access efficient market exposures, solve implementation challenges, and design multi-asset portfolios that respond to their evolving needs. We also offer systematic alpha and alternative strategies to complement clients' core holdings.

This role is part of Parametric's hybrid working model, which includes working in the office 3 days a week and choosing to work remotely or in the office the remaining days of the week.

ABOUT THE TEAM
The Data Management Office ensures that data pipelines are scalable, repeatable, secure, and can serve multiple users. We help facilitate getting data from a variety of different sources, getting it in the right formats, assuring that it adhere to data quality standards, and assuring that downstream users can get that data quickly.

ABOUT THE ROLE
The Lead Data Engineer will serve as a technical lead on new and ongoing development projects, designing, developing, and maintaining services and APIs to support various business needs. In this role you will be responsible for guiding and mentoring a team of data engineers helping them to achieve their highest potential while collectively advancing the goals and projects of the engineering team.

The Lead Data Engineer is responsible for the design, structure, and maintenance of data projects ensuring the accuracy and accessibility of data relevant to an organization or a project. In this role the Lead Data Engineer needs to be able to take business requirements and design and architecture end to end that fully supports the business needs. The Lead Data engineer needs to be an expert in writing and optimizing SQL queries. They need to be able to document ideas and proposals which will include creating ER diagrams and architectural documents that document the transformation of data throughout its lifecycle.

A successful Lead Data Engineer must possess superior analytical skills and be detail-oriented. This role requires the ability to communicate effectively as part of a larger team within the information technology department. Additionally, you will need to explain complex technical concepts to non-technical staff. Since development of data models and logical workflows is common, a Lead Data Engineer must also exhibit advanced visualization skills, as well as creative problem-solving.

Primary Responsibilities

• Works with team members to design and implement data solutions in alignment with the project schedule.
• Codes, tests, and documents new or modified data systems to create robust and scalable data platform for our applications.
• Works with developers to make sure that all data solutions are consistent.
• Expands and grows data platform capabilities to solve new data problems and challenges.
• Creates data flow diagrams for all of business systems.
• Implements security and recovery tools and techniques as required.
• Help to create and maintain a data catalog for each project.
• Interprets data results to business customers.
• Design of the logical model and implements the physical database to support business needs.
• Conducts logical and physical database design.
• Designs key and indexing schemes and designs partitioning.
• Develops, tests, implements, and maintains database management applications.
• Constructs and implements operational data stores and data marts.
• Ensures database changes are reviewed and approved according to database design standards and principles.
• Resolves conflicts between models, ensuring that data models are consistent with the ecosystem model (e.g., entity names, relationships and definitions).
• Models best practices in data management.
• Leads or participates in creating, refining, managing and enforcing data management policies, procedures, conventions and standards.
• Evaluates and provides feedback on future technologies and new releases/upgrades.

• Contributes to the establishment of business continuity & disaster recovery requirements, methods and procedures for data systems and databases.