About Morgan Stanley
Since our founding in 1935, Morgan Stanley has consistently delivered first-class business in a first-class way. 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 42 countries. Everything we do at Morgan Stanley is guided by our five core values: Do the Right Thing, Put Clients First, Lead with Exceptional Ideas, Commit to Diversity and Inclusion, and Give Back.
What We Offer
Morgan Stanley offers a dynamic and multifaceted environment which requires individuals to work closely with colleagues across various functions and the Business Unit in onshore regions. You will get to work with extremely talented peers in a meritocratic team-oriented culture.
Description
Morgan Stanley Equity Research is one of the financial industry's dominant thought leaders in equity investing and is a vital link between the Firm's varied business divisions. Our analysts, economists, and strategists have earned this reputation through timely, in-depth analysis of companies, industries, markets, and the world's economies. Our highly regarded equity analysts--who cover over 2,300 stocks globally and are organized by country, region, and global industry--develop key investment ideas and themes that are used by buy-side firms to structure portfolios as well as by the Morgan Stanley sales force in its interaction with investing clients; and provide valuable insights on market-moving events to the firm's traders and their clients. A career in equity research at Morgan Stanley demands a commitment to excellence and a passion for the markets as well as the highest level of integrity.
The Data Management team at Morgan Stanley Research is looking for capable python and SQL coders with a background in data. The individual will be an integral part of a small but growing team supporting all data operations within Equity Research. This team will help design the data onboarding process, infrastructure, and best practices, leveraging data and technology to develop innovative solutions to ensure the highest data quality. The centralized databases the individual builds will power nearly all core Research product.
Responsibilities
·Work with Research analysts to understand data needs and design a recommended onboarding solution, including evaluating available sources for content and quality
·Review data quality to identify limitations and investigate issues
·Develop data extraction and transformation processes to ingest and configure datasets in core databases (SQL, Python)
·Collect and maintain metadata; prepare documentation describing key data features, limitations and methodology
·Coordinate with internal teams and third party contacts to setup, register, and enable access to new datasets (ftp, SnowFlake, S3, APIs)
Qualifications/Skills/Requirements
·Technical Requirements:
·2+ years experience with data analysis in Python
·2+ years experience with SQL
·Advanced Excel
·Optional: q/KDB+
·Experience profiling data to identify anomalies
·Experience accessing, manipulating and working with data in various forms: Excel, relational databases, data warehouses, unstructured data environments, and APIs
·A background in ETL and/or data engineering
·Exposure to financial data, including both fundamental market data and alternative data
·Strong analytical and reasoning skills; able to decompose complex problems and projects into manageable pieces, and comfortable suggesting and presenting solutions
·Excellent verbal and written communication skills presenting results to both technical and non-technical audiences
Morgan Stanley is an equal opportunities employer. We work to provide a supportive and inclusive environment where all individuals can maximize their full potential. Our skilled and creative workforce is comprised of individuals drawn from a broad cross section of the global communities in which we operate and who reflect a variety of backgrounds, talents, perspectives and experiences. Our strong commitment to a culture of inclusion is evident through our constant focus on recruiting, developing and advancing individuals based on their skills and talents