Data Anyalyst DOI

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.

Operations & Compliance Technology (OCT) comprises of functionally aligned development teams who support critical firm functions such as Legal, Compliance and Operations. OCT develops strategic solutions that support key business processes, including Settlements, Confirmations, Regulatory Reporting, Position Keeping, Anti-Money Laundering and Trade Surveillance.

Disclosure Of Interest (DOI) is a business function that monitors and reports on the Firm's overall ownership percentages in public companies in order to provide the required transparency to the markets & regulators and to help ensure the Firm does not breach industry, company or regulatory limits in countries and jurisdictions in which it conducts business. The technology platform supporting this function is the Global Monitoring And Regulatory Reporting System (GMARRS).

You will have the opportunity to learn about how an investment bank operates and work in a global team from several regions across three continents.
You will meet several ways of how data quality can be measured, controlled and improved while learning how data governance works in a huge organization that must be compliant to rules of several regulator authorities.
Furthermore, you will have the opportunity to learn our integrated environment of industry standard IT tools and self-developed frameworks used in this space.

Primary responsibilities :
- Responsible for data analysis, data profiling and data sourcing
- Support the global team of business analysts and developers with data subject expertise, query building and optimization
- Develop a thorough understanding of the data definitions, domain values, data relationships, business rules, sources and data integration
- Partner with data providers to ensure upstream data requirements are met, participate in data reconciliation and testing
- Coordinate and conduct impact analysis of upstream data changes and/or issues
- Work closely with our clients, write detailed data requirements and use cases
- Define controls and measures for data quality, identify data issues

Skills required:
- Good knowledge of relational databases
- Strong SQL query-writing skills
- Solid analytical, profiling and troubleshooting skills
- Experience in data integration, conversion and migration
- Excellent verbal and written communication skills, ability to work with non-IT clients
- Knowledge of Microsoft Office applications, (Visio, PowerPoint, Excel, Word)

Skills desired:
- Knowledge of Data Quality controls & implementation of DQ rules (preferably using an industry standard tool)
- Knowledge of Unix commands and scripting and/or Autosys scheduler
- Experience with ETL tools (like Informatica) with the ability to develop ETL design specifications
- Data modeling
- Knowledge of financial services data

On top of the skills listed above, we expect you to be a self driven, dedicated individual who works well in a team and thinks and acts strategically, responds well to change and quickly pick up new skills and concepts in an ever moving regulatory landscape.

Morgan Stanley is an equal opportunities employer. We work to provide a supportive and inclusive environment where all individuals can maximise 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.

Desired profile

Skills required:
- Good knowledge of relational databases
- Strong SQL query-writing skills
- Solid analytical, profiling and troubleshooting skills
- Experience in data integration, conversion and migration
- Excellent verbal and written communication skills, ability to work with non-IT clients
- Knowledge of Microsoft Office applications, (Visio, PowerPoint, Excel, Word)

Skills desired:
- Knowledge of Data Quality controls & implementation of DQ rules (preferably using an industry standard tool)
- Knowledge of Unix commands and scripting and/or Autosys scheduler
- Experience with ETL tools (like Informatica) with the ability to develop ETL design specifications
- Data modeling
- Knowledge of financial services data

On top of the skills listed above, we expect you to be a self driven, dedicated individual who works well in a team and thinks and acts strategically, responds well to change and quickly pick up new skills and concepts in an ever moving regulatory landscape.

Morgan Stanley is an equal opportunities employer. We work to provide a supportive and inclusive environment where all individuals can maximise 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.