Senior Data Engineer - Associate

Company Profile
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.

Team Profile
Non-Financial Risk Technology provides operational controls and surveillance capabilities to enhance the firm's resilience to threats and fraudulent behavior.

The Fraud Technology department is responsible for designing, developing, and maintaining applications, which helps the firm identify and prevent potential fraudulent transactions. We also provide technology expertise to our fraud analysts in operations.

Role Profile
As a senior data engineer your role will be to create and deliver high quality, resilient data solutions to our Fraud business partners and being a productive member of the development team. You will be working on various existing and new technology stacks which include on-prem relational and big-data technologies & new cloud-based technologies in Azure. You will be expected to share ownership of our projects and contribute to the active development and maintenance of our applications. You will have the opportunity to be exposed to modern software engineering tools and best practices. You will have the opportunity to be exposed to how a large investment bank like Morgan Stanley detects and prevents fraud. You will work in a dynamic agile team that uses Scrum for its workflow. You will be expected to be involved in the full development lifecycle. You will be expected to collaborate with others in the wider team as well as working

Skills Required

• 6+ years of relevant work experience
• Strong with programming in Python to perform
• Batch data engineering on Apache Spark and populate downstream batch data stores (such as data mart) for BI use cases & to generate downstream feeds (ie., flat & wide tables or compressed files) for Data Science use cases
• Real-time service integration to process business events off Kafka and persist in operational MS SQL/MongoDB and/or Neo4j Graph data stores for fraud investigation
• Near real-time stream processing to derive features for ML model inference.
• Strong with SQL Server & Hadoop based implementations
• Strong SQL & Stored Procedure skills
• Exposure to modern operational NewSQL or NoSQL database technologies such as Neo4j, MongoDB, MemSQL etc.,
• Good hands-on experience with at least one of the job scheduling tools like Autosys (Preferred), Control-M etc.
• Experience of working in a Linux environment and can write Python/Shell scripts
• Strong data architecture and modeling experience. Especially, in dimensional modeling for data mart design and development to support BI use cases
• Strong data analytics skills
• Strong oral and written communication skills
• Excellent interpersonal skills and professional approach
• Strong analytical and problem-solving skills
• Ability to learn quickly and pick up new techniques and/or technologies
• Experience in building & maintaining data solutions for Operational, BI & Data Science use cases

Skills Desired

• Experience with Azure (Databricks, Data Factory, Synapse, Azure Data Lake) and/or AWS (AWS S3, AWS Athena, AWS Glue) Data ecosystem & Snowflake Data Cloud
• Experience in building virtual data access layer using Data Virtualization technologies to support BI & Data Science use cases
• Experience of the full software development life cycle
• Experience of working in an Agile team
• Experience of working with version control systems
• Experience with bash scripting
• Experience of working with Continuous Integration systems
• Experience in Fraud detection and prevention business in Financial Services

WHAT YOU CAN EXPECT FROM MORGAN STANLEY:

At Morgan Stanley, we raise, manage and allocate capital for our clients - helping them reach their goals. We do it in a way that's differentiated - and we've done that for 90 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.

To learn more about our offices across the globe, please copy and paste into your browser.

Expected base pay rates for the role will be between $90,000 and $150,000 per year at the commencement of employment. However, base pay if hired will be determined on an individualized basis and is only part of the total compensation package, which, depending on the position, may also include commission earnings, incentive compensation, discretionary bonuses, other short and long-term incentive packages, and other Morgan Stanley sponsored benefit programs.

Morgan Stanley's goal is to build and maintain a workforce that is diverse in experience and background but uniform in reflecting our standards of integrity and excellence. Consequently, our recruiting efforts reflect our desire to attract and retain the best and brightest from all talent pools. We want to be the first choice for prospective employees.

It is the policy of the Firm to ensure equal employment opportunity without discrimination or harassment on the basis of race, color, religion, creed, age, sex, sex stereotype, gender, gender identity or expression, transgender, sexual orientation, national origin, citizenship, disability, marital and civil partnership/union status, pregnancy, veteran or military service status, genetic information, or any other characteristic protected by law.

Morgan Stanley is an equal opportunity employer committed to diversifying its workforce (M/F/Disability/Vet).