Data Warehouse / ETL Engineer Position Available In Fulton, Georgia

Data Warehouse / ETL Engineer
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. This is a Data & Analytics Engineering III position at the Director level, which is part of the job family responsible for providing specialist data analysis and expertise that drive decision-making and business insights as well as crafting data pipelines, implementing data models, and optimizing data processes for improved data accuracy and accessibility, including applying machine learning and AI-based techniques. 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.
Interested in joining a team that’s eager to create, innovate and make an impact on the world? Read on.
Wealth Management and Investment Management Technology (WMIMT) is responsible for the design, development, delivery, and support of the technical platform behind the products and services used by the Business. Morgan Stanley Wealth Management (WM) is a product of the acquisition of Smith Barney from Citigroup, which was completed in June ’13. Its core client base is individual investors, small- to medium-size businesses and institutions, and high net worth families and individuals.
AIDT under Management Technology provides consistent, trusted, and integrated business information across all platforms and delivery channels within Morgan Stanley Wealth Management (MSWM) businesses. AIDT areas of expertise include but are not limited to Enterprise Data Warehouse (EDW) and Datalake (DL), cross-business-unit Information Management, Business Intelligence and more. AIDT team synthesizes and provisions a multitude of business-critical metrics and underlying detailed information in all Core areas of MSWM. Examples of essential data domains and metrics include Assets, Revenue, Account Demographics, Financial Advisor (FA) information, Securities and Cash Transactions, and so on.
As an integral part of AIDT, Data Integration & Delivery team is tasked with providing insightful and accurate business intelligence on Strategic Client Reporting (SCR), Account Performance metrics, Investment Insights, Trade Surveillance, Anti-Money Laundering and many other aspects of Wealth Management business. The role requires credibility, confidence and active participation with leadership teams, business units and technology groups across the project lifecycle. Specific assignments will depend on the size and complexity of the project.
What you’ll do in the role:
As an ETL / Hadoop developer, the candidate will design and develop Informatica ETL and Hadoop applications.
Undertaking end-to-end project delivery (from inception to post-implementation support), including review and finalization of business requirements, creation of functional specifications and/or system designs, and ensuring that end-solution meets business needs and expectations.
Development of new transformation processes to load data from source to target, or performance tuning of existing ETL code (mappings, sessions) and Hadoop Platform.
Analysis of existing designs and interfaces and applying design modifications or enhancements
Coding and documenting data processing scripts and stored procedures.
Providing business insights and analysis findings for ad-hoc data requests
Unit Testing software components and complete solutions (including debugging and troubleshooting) and preparing migration documentation.
Providing reporting-line transparency through periodic updates on project or task status.
What you’ll bring to the role:
Bachelor’s / Master’s degree in engineering, preferably Computer Science / Engineering
8+ years of experience with the technical analysis and design, development, and implementation of data warehousing / Data Lake solutions.
8+ years of Strong SQL programming and stored procedure development skills.
8+ years of experience developing in Informatica data management in the cloud or Informatica Power Center and DataStage.
6+ years in Python, Control M orchestration and Bit Bucket and Jenkins and CICD
6+ years in Hive/Impala/Spark, Unix, Python,
6+ years Python script development
6+ years relational database design in DB2, Hadoop, Snowflake and Teradata.
6+ years in Strong UNIX Shell scripting experience to support data warehousing solutions.
4+ years as an ETL developer in Snowflake
Some experience in AWS Glue and S3
Process oriented, focused on standardization, streamlining, and implementation of best practices delivery approach.
Excellent problem solving and analytical skills.
Excellent verbal and written communication skills.
Experience in optimizing large data loads.
Should be a good collaborator
Desired skills:
Exposure to an Agile Development environment would be a plus.
Knowledge about TWS Scheduler would an added advantage.
Strong understanding of Data warehousing domain.
Ability to architect an ETL solution and data conversion strategy.
Good understanding of dimensional modelling

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’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).
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Report this job

Dice Id:

80180578

Position Id:

d3ecd802884dd934d40b07119b3e8668