Director, Lead Software Engineer

Morgan-Stanley; Town of Islip (NY); Hybrid; USD 149,000 - 183,000; Full time

Job summary

Morgan Stanley is seeking a Director, Lead Software Engineer in New York, NY to drive end-to-end design, development and data migration efforts. You will develop ETL components, workflows, SQL and batch jobs while performing data analysis across sources and structures, with Agile Scrum collaboration.

The role requires a Master's in a related field and 3+ years of experience in data engineering, analytics or related roles, with strong skills in Informatica, Oracle SQL, DB2, Python and COBOL.

Qualifications

• Master's degree in a related field required.
• Three years of experience in data engineering or related roles.
• Experience with Informatica, SQL, IBM DB2, COBOL, JCL and agile environments.

Responsibilities

• Drive end-to-end design and development for ETL components and data migrations.
• Develop, test, and deploy ETL workflows, SQL and batch jobs; perform data analysis.
• Collaborate with stakeholders using Agile Scrum; perform root-cause analysis on batch failures.

Education

Master's in Applied Computer Science

Master's in Computer Engineering

Tools

Informatica

Oracle SQL/PLSQL

IBM DB2

DB2 for z/OS

SQL Server

Unix

Python

COBOL

JCL

Job description

Company Profile:Morgan Stanley is a leading global financial services firm providing a wide range of investment banking, securities, investment, 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.In Technology, 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.What you’ll do in the role:Morgan Stanley Services Group Inc. is seeking a Director, Lead Software Engineer in New York, New York to Support requirement gathering, project planning, impact analysis, effort estimation, and risk/issue tracking. Drive end-to-end design and development, including design mapping, survivorship rules, data migration, POCs, runbooks, testing strategy, and support procedures. Develop, test, and deploy ETL components, workflows, SQL, stored procedures, batch jobs and perform data analysis across sources and structures. Support migration of legacy feeds to distributed databases. Collaborate with the stakeholders using Agile scrum methodologies regarding use cases, development sequencing, priorities, and phasing. Troubleshoot all the existing batch failures and perform root cause analysis to resolve errors and strategically revise programs and codes to increase operational efficiency. Telecommuting permitted up to 2 day per week.What you’ll bring to the role:-Requires a Master’s in Applied Computer Science, Computer Engineering, or a related field of study.-Requires three (3) years of experience in the position offered or three (3) years as an Associate, Data Engineer, Data Analyst, or a related occupation.-Requires three (3) years of experience with the following skills:Technology product and delivery management functions;Informatica;Oracle (SQL/PL SQL) 10g/11g;IBM UDB DB2;IBM DB2 for z/OS;SQL SERVER;Unix;Python;DB2;Cobol;JCL;Product management and data-driven analysis in agile environments;coordinating software development solutions to meet business requirements;serving as primary project status contact for business and technology stakeholders;cross-functional collaboration; anddelivering high quality technical user interfaces.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 https://www.morganstanley.com/about-us/global-offices into your browser.Expected base pay rates for the role will be between $166,000 and $166,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 is an equal opportunity employer committed to building and maintaining a workforce that is diverse in experience and background. Our recruiting efforts reflect our strong commitment to a culture of inclusion, where individuals are hired, developed, and advanced based on their skills and talents.Our workforce reflects a broad cross-section of the global communities in which we operate, bringing a variety of backgrounds, talents, perspectives, and experiences.For more information, please visit : https://www.morganstanley.com/people-opportunities/eeo .