Python & SQL Data Engineer_Associate_Software Engineering

Morgan Stanley

Python & SQL Data Engineer_ Associate_Software Engineering

We’re seeking someone to join our team as Data Engineer as a part of our FRPPE- OpsTech team, to will play a key role in helping transform how Morgan Stanley operates

FRRPE_Tech

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.

Operations Technology

Operations Technology develops and maintains systems in support of Morgan Stanley's global Operations , including (but not limited to) Settlements, Confirmations, Regulatory Reporting, Position Keeping, Corporate Actions processing and other post-trade functions. Operations Technology is a global organization that is client-focused and functionally aligned. Our organization is built to support our clients functional, regional and business-facing requirements while delivering innovative technology and ensuring plant and processing stability. The Firm operates at scale with up to 40 million trades processed on peak volume days and hundreds of billions of dollars of daily settlements with activity ongoing in multiple countries and currencies across the globe. There is a great breadth of financial products that our Operations plant handles across equity and fixed income, from cash products to complex derivatives and loans.\

Software Engineering

This is Associate position that develops and maintains software solutions that support business needs.

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.

At Morgan Stanley India, we support the Firm’s global businesses, with critical presence across Institutional Securities, Wealth Management, and Investment management, as well as in the Firm’s infrastructure functions of Technology, Operations, Finance, Risk Management, Legal and Corporate & Enterprise Services. Morgan Stanley has been rooted in India since 1993, with campuses in both Mumbai and Bengaluru. We empower our multi-faceted and talented teams to advance their careers and make a global impact on the business. For those who show passion and grit in their work, there’s ample opportunity to move across the businesses for those who show passion and grit in their work.

Interested in joining a team that’s eager to create, innovate and make an impact on the world? Read on…

What you’ll do in the role:

Team Profile: Global Settlements technology team has significant presence in Mumbai, New York and Montreal. We are organized into Agile delivery teams closely aligned with Operations product owners, and there is an opportunity to directly see the business benefit of the solutions we develop through our close partnership with our stakeholders and users. We believe in the forward momentum and progress of technology and aim to harness the very best in new technology and systems design to deliver exceptional capabilities to our businesses.

We are seeking an experienced consultant with a strong background in Python and shell scripting, along with proficiency in running SQL queries. As a consultant, you will be responsible for understanding the business requirements of Settlement users and developing new reports. Furthermore, you will collaborate with regulators to provide data provisioning solutions. The role demands ownership of end-to-end delivery of business functionality in an Agile team setting. You will engage directly with users and work closely with technologists across the organization.

What you’ll bring to the role:

• At least 3+ years' relevant experience would generally be expected to find the skills required for this role.
• 3+ years of being a practitioner in data engineering or a related field.
• Strong programming skills in Python, with experience in data manipulation and analysis libraries (e.g., Pandas, NumPy, Dask).
• Proficiency in SQL and experience with relational databases (e.g., Sybase, DB2, Snowflake, PostgreSQL, SQL Server).
• Candidate should have a good knowledge in Apache Spark , Azure , Azure Dbx ,key vault  .
• Experience with message queues and streaming platforms (e.g., Kafka, RabbitMQ).
• Experience with version control systems (e.g., Git).
• Experience using Jupyter notebooks for data exploration, analysis, and visualization.
• Excellent communication and collaboration skills.
• Good problem solving and debugging skills & ability to work independently and as part of a geographically distributed team.

Good to have:

• Candidate should be aware of Snowflake and should have worked on tuning Sf queries
• Good knowledge of database and etl processes .
• Sound understanding of observability, scalability and performance, resiliency.
• Familiarity with ETL/ELT processes and tools (e.g., Informatica PowerCenter, IBM DataStage, Ab Initio) and open-source frameworks for data transformation (e.g., Apache Spark, Apache Airflow).
• Experience with data warehousing concepts and technologies (e.g., dimensional modeling, star    schema, data vault modeling, Kimball methodology, Inmon methodology, data lake design).

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.

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.