Data Modeler

Jd for your reference:

• Design build test and deploy Google Cloud data models and transformations in BigQuery environment eg 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 ongoing productivity and priorities by refining User Stories Epics and Backlogs in Jira
• Manage code artefacts and CICD using tools like Git Jenkins Google Secrets Manager etc
• Estimate commit and deliver requirements to scope quality and time expectations
• Deliver nonfunctional requirements IT standards and developer and support tools to ensure our applications are a secure compliant scalable reliable and cost effective
• Write wellcommented maintainable and selfdocumenting code
• Fix defects and provide enhancements during the development period and handover knowledge expertise code and support responsibilities to support team

Essential Experience

• HandsOn 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 Onprem or Cloud Databases Warehouses and Lakes
• Excellent understanding of GCP Architecting and solution design
• Proven experience solid knowledge in developing and optimization of SQLTSQL 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 methodologyprocedural knowledge AgileScrum DevOps and ITIL principles
• BSMS 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 multitasking 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

Skills

Mandatory Skills : GCP BigQuery