Job
Description
Design, build, test and deploy Google Cloud data models and transformations in BigQuery, environment . SQL, stored procedures, indexes, clusters, partitions, triggers,Deliver a data warehouse and pipelines which follow abstraction and database refactoring best practice in order to support evolutionary development and continual changeProtect 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 considerationsReview and refine, interpret and implement business and technical requirementsEnsure you are part of the on-going productivity and priorities by refining User Stories, Epics and Backlogs in JiraManage code artefacts and CI/CD using tools like Git, Jenkins, Google Secrets Manager, etc.Estimate, commit and deliver requirements to scope, quality, and time expectationsDeliver non-functional requirements, IT standards and developer and support tools to ensure our applications are a secure, compliant, scalable, reliable and cost effectiveWrite well-commented, maintainable and self-documenting codeFix defects and provide enhancements during the development period and hand-over knowledge, expertise, code and support responsibilities to support teamEssential ExperienceExpert 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 LakesExcellent understanding of GCP Architecting and solution designProven experience / solid knowledge in developing and optimization of SQL/T-SQL procedures in Traditional or Cloud DatabasesCoding and development of DDL and DML database componentsExcellent 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 subjectExcellent communication and interpersonal skills in English. Proficiency in verbal, listening and written English is crucial.