Data Solution Architect and Modeler

Job Description:

Job Title - Data Solution Architect and Modeler, VP

Location - Pune, India

Role Description

As a data solution architect supporting the individual business aligned, strategic or regulatory book of work, you will be working closely with the projects' business stakeholders, business analysts, solution architects, engineers, the lead data solution architect, the principal architect and the Chief Architect to help projects break out business requirements into implementable building blocks and design the solution's target architecture with a core focus on data movement, data persistence, data modelling and consumption. It is the data solution architect's responsibility to align the target data design against the general data architecture principles, apply agreed best practices and patterns and help the engineering teams deliver against the architecture in an event driven, service oriented environment.

What we’ll offer you

As part of our flexible scheme, here are just some of the benefits that you’ll enjoy

• Best in class leave policy
• Gender neutral parental leaves
• 100% reimbursement under childcare assistance benefit (gender neutral)
• Sponsorship for Industry relevant certifications and education
• Employee Assistance Program for you and your family members
• Comprehensive Hospitalization Insurance for you and your dependents
• Accident and Term life Insurance
• Complementary Health screening for 35 yrs. and above

Your key responsibilities

• In projects work with SMEs and stakeholders deriving the individual components of the solution
• Design the target architecture for a new solution or when adding new capabilities to an existing solution
• Assure proper documentation of the High Level Design and Low Level design of the delivered solution
• Quality assure the delivery against the agreed and approved architecture, i.e. provide delivery guidance and governance
• Prepare the High Level Design for review and approval by design authorities for projects to proceed into implementation
• Support creation of the Low Level Design as it is being delivered to support final go live

Your skills and experience

• Very proficient at standard RDBM systems and at data engineering level in T-SQL and/or PL/SQL and/or PL/pgSQL, preferably all
• Very proficient at modeling / implementing different data modelling approaches as well as understanding of respective pros and cons (e.g. Normalized, Denormalized, Star, Snowflake, DataVault 2.0, ...)
• Very good understanding of how RBMS generally work but also specific tuning experience on SQL Server, Oracle or PostgreSQL are welcome
• Very good understanding of non-streaming ETL and ELT approaches for data ingest
• Good understanding of designing and implementing data streaming and data ingest pipelines for heavy throughput while providing different guarantees (At least once, Exactly once)
• Good understanding of designing / architecting solutions in an event driven environment leveraging service oriented principles
• Good understanding at building systems in a decoupled, event driven environment leveraging messaging / streaming, i.e Kafka
• Understanding of Java and the delivery of Spring based services
• Understanding of containerized, distributed systems
• A strong working experience on GCP architecture is a benefit (APIGee, BigQuery, Pub/Sub, Cloud SQL, DataFlow, ...) - appropriate GCP architecture level certification even more so
• Experience leveraging other data management solutions welcome (e.g. Document store, Key/Value etc.)

How we’ll support you

• Training and development to help you excel in your career
• Coaching and support from experts in your team
• A culture of continuous learning to aid progression
• A range of flexible benefits that you can tailor to suit your needs

About us and our teams

Please visit our company website for further information:

[https://www.db.com/company/company.htm>

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.