Data Feed Engineer (ETL) -Vice President
New York, NY

Job Description

Data Feed Engineer (ETL) -Vice President

Job ID: 3184210 Full/Part-Time: Full-time Regular/Temporary: Regular Listed: 2019-05-23 Location: New York, United States of America

Corporate & Investment Bank

The Corporate & Investment Bank (CIB) combines Deutsche Bank's Corporate Finance, Global Markets and Global Transaction Banking businesses. This new business division was created in 2017 with the aim to ensure greater alignment of product and sales efforts, enabling the bank to deliver a better service to clients and a more focused resource allocation.

Corporate Finance is comprised of regional and industry-focused coverage teams that ensure the delivery of the entire range of financial products and services to the bank's corporate clients. The business includes the Mergers & Acquisitions (M&A) team as well as the debt and equity capital markets (DCM and ECM) teams.

Global Markets is dedicated to building long-term, sustainable relationships with the bank's key corporate and institutional clients. It combines a market-leading institutional sales force, world-class research with trading and structuring expertise to provide clients with access to liquidity and customised solutions across a wide range of markets, products and regions.

Global Transaction Banking (GTB) is a leading global provider of cash management, trade finance and securities services, delivering the full range of commercial banking products and services for both corporates and institutions worldwide.

Position Overview

Job Title: Data Feed Engineer

Corporate Title: Vice President

Location: New York, New York

About Deutsche Bank

We are Germany's leading bank with strong positions in Europe and significant presence in the Americas and Asia Pacific. We're driving growth through our strong client franchise, investing heavily in digital technologies, prioritizing long-term success over short-term gains, and serving society with ambition and integrity. We serve our clients' real economic needs in commercial and investment banking, retail banking and transaction banking, and provide ground-breaking products and services in asset and wealth management. That means a career packed with opportunities to grow and the chance to shape the future of our clients.

We are committed to being the best financial services provider in the world, combining passion with precision to deliver superior solutions for our clients. This is made possible by our people: agile minds, able to see beyond the obvious and act effectively in an ever-changing global business landscape. Diverse, international and shaped by a variety of different perspectives, we are driven by a shared sense of purpose. At every level, agile thinking is encouraged and agile minds are rewarded with competitive pay, support and opportunities to excel.

Deutsche Bank is a client-centric global universal bank. One that is leading change and innovation in the industry - championing integrity, sustainable performance and innovation with our clients, and redefining our culture and relationships with each other.

Corporate & Investment Banking

The Corporate & Investment Bank (CIB) combines Deutsche Bank's Corporate Finance, Global Markets and Global Transaction Banking businesses. This new business division was created in 2017 with the aim to ensure greater alignment of product and sales efforts, enabling the Bank to deliver a better service to clients and a more focused resource allocation.

Global Transaction Banking

The Global Transaction Banking (GTB) division is not just a market leader in cash management, trust and agency services, trade finance, and securities services, we are also at the forefront in the provision of strategic thinking and the creation of global solutions.

Our universal expertise and worldwide experience presence in over 190 countries allows us to offer truly integrated and effective solutions. From domestic and cross-border payments, international trade finance, acting as trustees, agents and custodians for our clients, we aim to help our clients optimize every opportunity, minimize risk and achieve their commercial objectives. In today's fast-moving, ever-changing business landscape, companies need more than just outstanding business models to perform - they need strong insight to achieve their business objectives.

What you'll do

As a Data Feed Engineer, you'll work on the design and development of a key capability that will support the GTB (Global Transaction Banking) Data Factory. You'll help design, build, and deploy tools and automated processes to manage the ingestion and refinement of raw data into the data factory. You will analyze and ingest data from various source inside and outside of the Bank, refine and manage that data and prepare it for consumption by analytics applications. The data factory also manages the distribution of data to these analytics applications, as well as to client-facing APIs.

The Data Feed Engineering team is responsible for onboarding data to the data factory. The includes partnering with source owners to obtain data feed, analyzing the data in those feeds, and implementing processes to ingest, refine and land the data in a big data repository. It also includes applying protections to the data, to ensure that sensitive data is handled and stored safely. As an engineer, you'll work on the design, engineering, rollout and monitoring of this data capability, in a dynamic big data environment.

Challenges you'll address include:

* Sourcing - assisting with the identification of data sources and ensuring that data is delivered in a repeatable, sustainable manner
* Analysis - exploring data to determine how it should be transformed and enriched to make it suitable for analytics
* Transformation - building the data pipeline to ingest and transform data in a highly automated manner
* Enrichment - implementing logic to address inconsistencies, errors, and issues in data
* Quality measurement - implementation of rules to measure and monitor data quality and to issue alerts and warnings when quality thresholds are breached
* Protection - applying various protection measures to sensitive data, such as masking, tokenization, encryption, de-identification, or other measures
* Automation and instrumentation - designing and implementing a highly automated and instrumented process that can run with minimal intervention and provides robust performance, throughput, and health metrics

Who you are

You will have a strong and varied background in designing and building innovative software solutions in a data-centric environment. This position will require hands-on experience designing and coding software in a variety of languages and platforms, with an emphasis on ETL and other data transformation technologies. You have a good understanding of big data platforms including HDFS and Hadoop, and will have worked in an analytics environment building data warehouses or data lakes. Your background likely includes multiple programming languages, exposure to relational and big data/noSQL databases, and experience working in an Agile development environment. Prior work experience in a regulated industry is highly desirable.

As a member of our team, you will inspire your colleagues through your words and actions, and you'll have an opportunity to work with them to achieve frequent small victories. You will be a strong collaborator and will gladly share your knowledge and experience with other team members. Likewise, you'll be hungry to learn more and will enjoy working in a dynamic and diverse team. You value transparency and intellectual honesty, and you're excited by the opportunity to help design and implement the next generation of data and analytics capabilities for Deutsche Bank's Global Transaction Banking businesses.

How you'll do it

In addition to the responsibilities outlined above, you will:

* Assist with identification of source systems
* Partner with data quality analysts to run profiling on data sets and determine the transformations required
* Consult with control partners to understand data protection requirements and implement them for sensitive data
* Engineer a high performing data ingestion pipeline using batch and streaming data transformation tools. You will likely use commercial data transformation tools (e.g. Pentaho, Informatica, Stream Sets) as well as custom-developed capabilities
* Implement data quality rules through custom development, in a data transformation tool, or using a specialized DQ tool
* Help design the operating model for the data factory and the big data repositories
* Identify appropriate instrumentation points to monitor the health of the environment
* Design and build monitoring capabilities and their associated reporting dashboards to allow a clear view of the health of the data factory
* Provide early warnings on areas that need attention in order to keep the data factory functioning at a high level
* Automate processes and tools using RPA and other tools
* Develop and apply data protection protocols, including techniques such as data masking, encryption, tokenization, and de-identification
* Lend your technical skills to other teams to support our shared goal of creating a world-class analytics environment

Education:

* An undergraduate degree in a technical field is required
* A graduate degree in a technical field is desired

For candidates applying for positions in the US:

Deutsche Bank is an Equal Opportunity Employer - Veterans/Disabled and other protected categories. Click these links to view the "EEO is the Law" poster and pay transparency statement.