Director, Data & Analytics Engineering
About The Position
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.
Requirements
- 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.
Responsibilities
- 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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Director
Number of Employees
5,001-10,000 employees
