PB - Data Engineer - BAS

at  Deutsche Bank

POSITION OVERVIEW

Additional Job Description

A Senior Engineer is responsible for designing and developing entire engineering solutions to accomplish business goals. Key responsibilities of this role include ensuring that solutions are well architected, with maintainability and ease of testing built in from the outset, and that they can be integrated successfully into the end-to-end business process flow. They will have gained significant experience through multiple implementations and have begun to develop both depth and breadth in a number of engineering competencies. They have extensive knowledge of design and architectural patterns. They will provide engineering thought leadership within their teams, and will play a role in mentoring and coaching of less experienced engineers.

• You will be responsible for programming, deploying and maintaining all types of Oracle programming artifacts (e.g., SQL scripts and queries, PL/SQL stored procedures and functions, materialized views) in our Oracle database domains across our Development, UAT and Production
• Provide expertise in the design and effective programming all kinds of Oracle database components – logical and physical schemas, tables, indexes, queries, stored procedures, functions, etc. – in a complex Oracle based software based modeling execution platform
• Assist with the day-to-day monitoring and support of our Dev / UAT / Prod Oracle platforms
• Provide subject matter expertise in Oracle programming (both native and non-native) for implementing effective and optimal programming solutions to all current and future modeling, deployment, and support requirements
• Study new business and IT requests in order to understand user needs and suggest solutions
• Be proactive by proposing enhancements from which the business/IT can benefit
• Have a good understanding of business needs
• Design and implement the necessary system changes in a short feedback loop
• Build quality into our software through extensive and automatic testing and continuous build
• Continuous technical upgrade of the setup and maintain and enhance the existing systems
• Participate in Source Code and Design Reviews
• Provide development and testing support to other engineers
• Transform requirements into Design concepts and Proof of Concepts
• Troubleshoot and debug issues
• Understand and promote software engineering best practices
• Follow the Scrum methodology and participate in the various Scrum meetings as a cross-functional & cross-component team member
• Expected to perform L3 activities by rotation with other team members
• Write clear and detailed technical specifications and documentation

EDUCATION

Technical University Degree

ESSENTIAL TECHNICAL SKILLS

• Previous relevant experience in Oracle database programming and implementation initiatives – SQL, PL/SQL
• Hands on expertise in Oracle native and non-native database programming environments, including SQL, PL/SQL (stored procedures, functions, materialized views, etc.)
• Data structures and schemas
• Data Analysis
• Report development
• ETL tools and methods

OTHER TECHNICAL SKILLS

• At least 5 years of previous experience in Software Development
• Excellent in SQL and PL/SQL development
• Excellent in Oracle 12c / 19c
• Experience in performance tuning
• Experience with ETL development
• Know how in data warehouse development
• Experience of SDLC processes
• Knowledge and experience with continuous integration best practices (SCM, build automation, dependency management)
• Knowledge of Oracle database, SQL and PostgreSQL
• Familiar with version control systems such as GIT, Team City and Artifactory
• Understanding and experience of modern SDLC processes and tooling
• Exposure and understanding of working in an Agile environment

SOFT SKILLS

• Excellent level of English, verbal & written
• Work well both independently and within a team setting, act as mentor for more junior team members
• Responsible attitude, strong autonomy and ambition in achieving your mission
• High reactivity, pro-activeness and autonomy within the team required
• Excellent analytical skills and self-starter with ability to take ownership of tasks and assignments
• Flexible and willing to accept a change in priorities as necessary
• Strong attention to details
• Excellent problem solver
  Our values define the working environment we strive to create – diverse, supportive and welcoming of different views. We embrace a culture reflecting a variety of perspectives, insights and backgrounds to drive innovation. We build talented and diverse teams to drive business results and encourage our people to develop to their full potential. Talk to us about flexible work arrangements and other initiatives we offer.
  We promote good working relationships and encourage high standards of conduct and work performance. We welcome applications from talented people from all cultures, countries, races, genders, sexual orientations, disabilities, beliefs and generations and are committed to providing a working environment free from harassment, discrimination and retaliation.
  Visit Inside Deutsche Bank to discover more about the culture of Deutsche Bank including Diversity, Equity & Inclusion, Leadership, Learning, Future of Work and more besides.
  Our values define the working environment we strive to create – diverse, supportive and welcoming of different views. We embrace a culture reflecting a variety of perspectives, insights and backgrounds to drive innovation. We build talented and diverse teams to drive business results and encourage our people to develop to their full potential. Talk to us about flexible work arrangements and other initiatives we offer.
  We promote good working relationships and encourage high standards of conduct and work performance. We welcome applications from talented people from all cultures, countries, races, genders, sexual orientations, disabilities, beliefs and generations and are committed to providing a working environment free from harassment, discrimination and retaliation.
  Visit Inside Deutsche Bank to discover more about the culture of Deutsche Bank including Diversity, Equity & Inclusion, Leadership, Learning, Future of Work and more besides

• You will be responsible for programming, deploying and maintaining all types of Oracle programming artifacts (e.g., SQL scripts and queries, PL/SQL stored procedures and functions, materialized views) in our Oracle database domains across our Development, UAT and Production
• Provide expertise in the design and effective programming all kinds of Oracle database components – logical and physical schemas, tables, indexes, queries, stored procedures, functions, etc. – in a complex Oracle based software based modeling execution platform
• Assist with the day-to-day monitoring and support of our Dev / UAT / Prod Oracle platforms
• Provide subject matter expertise in Oracle programming (both native and non-native) for implementing effective and optimal programming solutions to all current and future modeling, deployment, and support requirements
• Study new business and IT requests in order to understand user needs and suggest solutions
• Be proactive by proposing enhancements from which the business/IT can benefit
• Have a good understanding of business needs
• Design and implement the necessary system changes in a short feedback loop
• Build quality into our software through extensive and automatic testing and continuous build
• Continuous technical upgrade of the setup and maintain and enhance the existing systems
• Participate in Source Code and Design Reviews
• Provide development and testing support to other engineers
• Transform requirements into Design concepts and Proof of Concepts
• Troubleshoot and debug issues
• Understand and promote software engineering best practices
• Follow the Scrum methodology and participate in the various Scrum meetings as a cross-functional & cross-component team member
• Expected to perform L3 activities by rotation with other team members
• Write clear and detailed technical specifications and documentatio