Assistant Vice President TS

Job Description

JOB TITLE: Assistant Vice President – TS9950113

Location:

Cary, NC.

We are seeking an Assistant Vice President to collaborate with senior stakeholders to provide clear and insightful reports and metrics to support effective project planning.

• Collate and present reports and metrics for project planning.
• Perform user requirement design studies and system analysis.
• Analyze databases using relational databases (SQL Server, Oracle, PostgreSQL, DB2, IBM Netezza).
• Apply advanced SQL query optimization, ETL (Informatica Power Center), metadata analysis, and data profiling techniques.
• Design and develop ETL structures to extract, transform, and load data from multiple sources into data warehouses and other databases.
• Troubleshoot post‑release deployment issues and support data warehouse production projects using SQL, Python, Hadoop ecosystem tools (HDFS, Hive), Databricks, and cloud monitoring solutions.
• Work on enhancements related to business requirements and support delivered jobs in production.
• Identify source and target tables and create data mapping documents.
• Develop Test Case and Test Plan documents to drive User Acceptance Testing (UAT) and Post Implementation (PI) testing on Integrated Data Warehouses.
• Streamline end‑to‑end processes to support large‑scale data intake.
• Utilize Hadoop ecosystem (HDFS, Hive), SQL, Python, ETL, Databricks, Cloud Migration, Metadata Analysis, Cognos, and Power BI.

• Bachelor’s degree in Computer Engineering, Electronic Engineering, or a related field, or equivalent experience.
• Five (5) years of progressively responsible experience performing user requirement design study and systems analysis.
• Proficiency in relational databases (SQL Server, Oracle, PostgreSQL, DB2, IBM Netezza) and advanced SQL query optimization.
• Experience with ETL processes, Informatica Power Center, Hadoop ecosystem, Databricks, Python, and cloud monitoring solutions.
• Strong data profiling, metadata analysis, and data mapping skills.
• Experience developing test plans, test cases, and driving UAT and PI testing.
• Experience with Cognos and Power BI reporting tools.

Salary range: $142,716 – $165,000 per year. Eligible for Deutsche Bank’s Employee Referral Incentive Program.

Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status or other characteristics protected by law.