Director, Data & Analytics Engineering

Location: Alpharetta GA 1 Edison

Time Type: Full time

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, Data & Analytics Engineering in Alpharetta, Georgia to design and develop ETLs, stored procedures, triggers, MQTs and views on the DB2-based Data Warehouse. Analyze system and functional requirements provided by the business. Perform data profiling and analysis on source system data to ensure that source system data can be integrated and represented properly in models. Monitor the performance of queries and data loads and perform tuning as necessary. Provide assistance and guidance during the QA & UAT phases to quickly confirm the validity of potential issues and to determine the root cause and best resolution of verified issues. Responsible for the timely production deployment of scheduling jobs, ETL workflows, and database objects. Assist other Informatica ETL developers with their development of complex ETLs. Telecommuting permitted up to 3 days per week.

What you’ll bring to the role:

-Requires a Bachelor’s degree in Engineering (any), Computer Science, or related field of study.

-Requires five (5) years of experience in the position offered or five (5) years as an Assistant Consultant, Developer, or related occupation in the technology field.

-Requires five (5) years of experience with the following skills:

• ETL – Informatica PowerCenter;
• Programming including Python, SQL, and PL/SQL;
• Data Modelling including Erwin;
• RDBMS including Oracle;
• Big Data including Hadoop, HDFS, Apache Hive, and Apache Spark; and
• BI Reporting including QlikView and Tableau.

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 $159,000 and $159,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.