Duplicate Data Engineer - Assistant Vice President

Job Description:

Job Title Data Engineer

Corporate Title Assistant Vice President

Location Cary, NC

Who we are

In short – an essential part of Deutsche Bank’s technology solution, developing applications for key business areas.

Our Technologists drive Cloud, Cyber and business technology strategy while transforming it within a robust, hands-on engineering culture. Learning is a key element of our people strategy, and we have a variety of options for you to develop professionally. Our approach to the future of work champions flexibility and is rooted in the understanding that there have been dramatic shifts in the ways we work.

Having first established a presence in the Americas in the 19th century, Deutsche Bank opened its US technology center in Cary, North Carolina in 2009. Learn more about us here.

Overview

eDiscovery Services is the function within the Bank and Chief Operating Officer (COO) Division which is responsible for identifying, preserving, collecting and transferring electronically stored information to internal requestors and external third parties. As a Data Engineer in eDiscovery Services, you shall support the Defensible Disposal program and contribute to the migration of data from legacy on-premises data sources to cloud hosted archiving technologies. Through collaboration with the functional stakeholders, you shall ensure the Banks legal and regulatory obligations towards data preservation and legal hold are defensibly managed and maintained throughout the course of data migration and disposal.

What We Offer You

• A diverse and inclusive environment that embraces change, innovation, and collaboration

• A hybrid working model with up to 60% work from home, allowing for in-office / work from home flexibility, generous vacation, personal and volunteer days, a commitment to Corporate Social Responsibility

• Employee Resource Groups support an inclusive workplace for everyone and promote community engagement

• Access to a strong network of Communities of Practice connecting you to colleagues with shared interests and values

• Competitive compensation packages including health and wellbeing benefits, retirement savings plans, parental leave, and family building benefits, educational resources, matching gift and volunteer programs

What You’ll Do

• Manage Structured Query Language (SQL) databases to store, organize and query data to assist in the scoping of data collections and preservations to support the Bank required for legal and regulatory requirements

• Conduct detailed metadata analysis to identify data and records required for preservation throughout the course of disposal and migration from on-premises data sources to cloud hosted technologies

• Assist in the design and development of effective data workflows to automate and streamline tasks required throughout the identification, collection and preservation processes

• Provide streamlined script updates and refactor Python code for gained efficiency and defensibility

• Collaborate with team members (to understand and capture requirements, design and implement solutions and provide production support in Hadoop environment), collaborate with senior stakeholders to provide clear and insightful reports and metrics to support effective project planning

• Utilize SQL queries, data profiling tools, and data cleaning techniques to increase accuracy and completeness of data

Skills You’ll Need

• Experience with Information Technology (IT), ediscovery and electronically stored information

• Experience in a data analyst or relevant role

• Understanding of both Python and SQL syntax, data types, variables, and programming concepts

• Experience of working with large datasets in a Hadoop environment using HDFS, Spark, Impala and Hive

• Understanding of data gathering, inspecting, cleansing, transforming, and ETL processes in Hadoop libraries

Skills That Will Help You Excel

• Proven ability to work well in a fast-paced environment to deliver meet deadlines and milestones for projects assigned in a professional manner

• Ability to articulate clear and concise updates on the status of project tasks to senior stakeholders across various functions / departments

• Meticulous attention to detail and critical thinking skills that allow you to close