Job Title:  Technology and Transformation -EAD-GCP-Date warehouse-Consultant

Data warehouse engineer :

Job Duties

• Design, build, test and deploy Google Cloud data models and transformations in BigQuery, environment (e.g. SQL, stored procedures, indexes, clusters, partitions, triggers, etc.)
• Deliver a data warehouse and pipelines which follow abstraction and ‘database refactoring’ best practice in order to support evolutionary development and continual change
• Protect the solution with appropriate Authorization and Authentication models, data encryption and other security components – this will include consumer registration and storage of identification and change management considerations
• Review and refine, interpret and implement business and technical requirements
• Ensure you are part of the on-going productivity and priorities by refining User Stories, Epics and Backlogs in Jira
• Manage code artefacts and CI/CD using tools like Git, Jenkins, Google Secrets Manager, etc.
• Estimate, commit and deliver requirements to scope, quality, and time expectations
• Deliver non-functional requirements, IT standards and developer and support tools to ensure our applications are a secure, compliant, scalable, reliable and cost effective
• Write well-commented, maintainable and self-documenting code
• Fix defects and provide enhancements during the development period and hand-over knowledge, expertise, code and support responsibilities to support team

Essential Experience

• Hands-On experience of minimum 2 projects based on GCP Big Query
• Expert in database design, development and administration – understanding of relational and dimensional data models (and preferably Data Vault)
• Expertise in On-prem or Cloud Databases, Warehouses and Lakes
• Excellent understanding of GCP Architecting and solution design
• Proven experience / solid knowledge in developing and optimization of SQL/T-SQL procedures in Traditional or Cloud Databases
• Coding and development of DDL and DML database components
• Excellent knowledge of devops tools like Ansible , Jenkins, Github ,Puppet, Chef etc.
• IT methodology/procedural knowledge; Agile/Scrum, DevOps and ITIL principles.
• BS/MS degree in Computer Science, Engineering or a related subject
• Excellent communication and interpersonal skills in English. Proficiency in verbal, listening and written English is crucial.
• Enthusiastic willingness to rapidly and independently learn and develop technical and soft skills as needs require.
• Strong organisational and multi-tasking skills.
• Good team player who embraces team work and mutual support.
• Interested in working in a fast paced environment

Ideal Experience (following skills/experiences would be an added advantage)

• Experience with application monitoring & Production Support
• Broad experience with IT development and collaboration tools.
• An understanding of IT Security and Application Development best practice.
• Understanding of and interest in various investment products and life cycle and the nature of the investment banking business.
• Working in a global team with different cultures