BI & Data Analytics Engineer

Morgan Stanley

  • New York City, NY
  • $120,000-165,000 per year
  • Permanent
  • Full-time
  • 2 days ago
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 position at 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.Since 1935, Morgan Stanley is known as a global leader in financial services, always evolving and innovating to better serve our clients and our communities in more than 40 countries around the world.This is a Lead Business Intelligence & Data Analytics Engineering position at Director level, which is part of the job family responsible for developing and maintaining innovative software solutions. The candidate will partner with Business and Technology teams to provide timely actionable analysis/insights to measure, grow, and supervise business areas, products, and services in Morgan Stanley Wealth Management.Position OverviewAIDT under Wealth 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 not limited to Enterprise Data Warehouse (EDW) and Datalake (DL), cross-business-unit Information Management, Business Intelligence, AI/ML and more. AIDT team synthesizes and provisions a multitude of business-critical metrics and underlying detailed information in all Core areas of MSWM.As an integral part of AIDT, Data Visualization team is tasked with providing insightful and actionable business intelligence solutions for various business unit under wealth management. Examples of essential data domains and metrics include Assets, Revenue, Account Demographics, Financial Advisor (FA) information, Securities and Cash Transactions, Risk, Stock Plan, Retirement, Financial Wellness, and other key areas. The candidate will work on either one or many visualization projects, and the role requires 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:-Develop and build enterprise level Full Stack applications using BI and ETL technologies.-Design and develop scalable data model to create intuitive reports and dashboards.-Design and Development of ETL/Hadoop, including stored procedures, queries, performance tuning, archiving, etc., using python, SQL and ETL tools.-Development of new transformation processes to load data from source to target, or performance tuning of existing ETL code (mappings, sessions) and Hadoop Platform.-Build data pipelines and efficient automation scripts (using Python)-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.-Analysis of existing designs and interfaces and applying design modifications or enhancements.-Providing insights and analysis findings for ad-hoc issues.What you'll bring to the role:-5+ Years of Development creating End to End Full Stack BI Solution, using BI Tools (Power BI, Tableau, Business Objects) and ETL Development (Informatica)
-5+ years of experience with the technical analysis and design, development and implementation of Data Lake and Data Warehouse solutions.-5+ years of experience in Hadoop, PySpark and Big data technologies.-5+ years relational database experience.-Strong UNIX Shell scripting and Python experience to support data warehousing solutions.-Power BI Development and Azure-Relational databases DB2, Sybase, and Teradata.-DDL and DML writing skills are essential as well as being able to write complex SQLs for data analysis.-Create high quality and optimized stored procedures and queries.-Experience data modeling and transformation of large-scale data sources using SQL, Hadoop, Spark, Hive, Snowflake, Databricks, Teradata or other Big Data technologies.-Knowledge of version control systems, such as GIT/BitBucket--Data warehousing concepts (Facts, Dimensions, star and snowflake design, etc.)Experience with scheduling tools (ex: Tivoli, Autosys)-Database Performance and Tuning-Unix and Python ScriptingGood to have skills:-Ability to architect an ETL solution and data conversion strategy.-Strong understanding of Data warehousing domain.-Hadoop processing Performance Optimization.-Familiarity with Python, Perl, R, data manipulation and analysis.-Knowledge about TWS Scheduler would an added advantage.-Being in Frameworks Team able to assist L1 - L2 Ops Support Team and assist/advise them on Production Job failures and should be able to assist Non-Prod Ops Support Team and assist them in Non-Prod Environment's Job failures.-Experience in Agile methodology.-Experience working directly with business stakeholders to translate between data and business needs.-Excellent Team Player.We have a track record of innovation and passion for unlocking new opportunities, we help our clients raise, manage and allocate capital. We do this by offering a wide range of investment banking, securities, wealth management and asset management services.All that we do at Morgan Stanley is driven by our five core values: do the right thing, put clients first, lead with exceptional ideas, commit to diversity and inclusion, and give back. These aren’t just beliefs, they guide the decisions we make every day, ensuring we do what's best for our clients, communities and more than 80,000 employees around the world. And at the core of our success are the people who drive it - relentless collaborators and creative thinkers who are fueled by diverse thinking and experiences.Wherever you are in our 1,200 global offices, you’ll have the opportunity to work alongside the best and the brightest in an environment where you are empowered to achieve your full potential. 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.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).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.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 $120,000 and $165,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 programsMorgan 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).

Morgan Stanley