Data Engineer

Company: Morgan Stanley
Location: New York
Posted on: May 17, 2022

Job Description:

Position DescriptionIn Research and ESG Technology we are rapidly transforming the way business is done. We seek an experienced SQL, Python and data platform developer to join our global agile team and embark on this transformation journey. The individual will help the team design and develop a powerful data platform that empowers efficient, innovative and competitive research and product development for our Investment Teams.Primary Responsibilities? Migrate data platform and ingestion workflow from MS SQL Server database to Snowflake.? Develop efficient solutions/processes to expedite new dataset ingestion.? Develop comprehensive data quality checks for the data platform, including alerts, notifications and automation for exception handling.? Troubleshoot and correct technical production issues on the data platform.? Manage code releases and promote development work to the Production environment.? Fine tune performance of complex queries against large datasets.? Develop/refine workflow automation jobs.? Assist business teams with complex query development working with stakeholders to understand their analysis requirements and build efficient queries accordingly.? Build result sets and analysis models to specification using Python.? Collaborate with UI teams on UI integration for the data platform. Qualifications? Strong MS SQL development skills with 10 years of experience developing applications and data process workflows.? Extensive ETL experience.? 5 years of in-depth experience working with Investment Management Data/Processes.? Experience working with large datasets.? Deep knowledge of workflow automation tools including workflow development/scripting.? Strong understanding of relational database design, data warehousing and operational data stores. Ability to model new datasets effectively within existing environments.? Highly effective time management skills and the ability to work independently and deliver in a fast paced environment.? Excellent communication skills including the ability to communicate effectively in both formal and informal contexts in a manner tailored for the audience.Desired Skills? Python development skills? Knowledge of, and experience working with ESG datasets? Experience with Snowflake? Experience working on an Agile team? Experience using Jira as a workload management tool? Experience using GitHub for release management **Job:** **Development* **Title:** *Data Engineer* **Location:** *New York-New York* **Requisition ID:** *3213718*

Keywords: Morgan Stanley, New York , Data Engineer, Engineering , New York, New York