Devops Engineer/Senior Consultant Specialist
hsbc
Job Description
Roles and Responsibilities…
- Design, develop, and maintain high-performance data pipelines using GCP services such as BigQuery, Dataflow, Pub/Sub, and Composer (Airflow).Write SQL queries, dbt models, or Dataflow pipelines to transform raw data into analytics-ready datasets
- Develop and optimize SQL queries and data transformation scripts for data warehousing and reporting purposes
- Lead proof-of-concepts (POCs) and best practice implementations for modern data architecture, including data lakes and cloud-native data warehouses.
- Ensure data security, lineage, quality, and compliance across GCP data ecosystems through IAM, audit logging, data encryption, and schema management.
- Understanding of security best practices, including IAM, secrets management, and vulnerability scanning.
- Monitor, troubleshoot, and optimize pipeline and warehouse performance using GCP native tools such as Cloud Monitoring, Cloud Logging, and BigQuery Optimizer.
- Automate infrastructure provisioning, configuration, and deployment using tools like Terraform, Ansible, or Cloud Deployment Manager
- Building and managing CI/CD pipelines.
- Design, implement, and manage cloud infrastructure on Google Cloud Platform (GCP).
- Write clean, maintainable, and efficient code following best practices.
Requirements
To be successful in this role, you should meet the following requirements:
Data Engineering:
- 8–12 years of experience in data engineering, with at least 3–5 years hands-on experience specifically in Google Cloud Platform (GCP).
- BigQuery (data modelling, optimization, security); Advanced SQL proficiency with complex data transformation, windowing functions, and analytical querying.
- Ability to design and develop modular, maintainable SQL models using dbt best practices.
- Experience in developing high performing batch pipelines.
- Strong understanding of data architecture patterns: data lakes, cloud-native data warehouses, event-driven architectures.
- Experience with version control systems like Git and branching strategies.
DevOps:
- Strong scripting skills (Bash, Python, etc.)
- Proficiency in building and managing CI/CD pipelines.
- Exposure to monitoring and optimizing cloud resources for performance, cost, and scalability using tools like Stackdriver, Prometheus, or Grafana
- Exposure to deployment tools like Terraform, Ansible, or Cloud Deployment Manager
- Monitor system health, identify potential bottlenecks, and ensure high availability and disaster recovery processes are in place.
- General:
- Experience with Agile delivery methodologies (e.g. Scrum, Kanban)
- Demonstrable track record of dealing well with ambiguity, prioritizing needs, and delivering results in a dynamic environment.
- Conduct regular workshops, demos and stakeholder reviews to showcase data solutions and capture feedback.
- Excellent communication and collaboration skills.
- Collaborate with development teams to streamline the software delivery process and improve system reliability.
- Mentor and upskill junior engineers and analysts on GCP tools, participate in Continuous improvement and transformation towards Agile, DevOps, CI/CD and drivers of improved productivity.
- Ability to translate business objectives into data solutions with a focus on delivering measurable business value.
- Flexible to work in shifts and provide on-call support, owning the smooth operation of applications and systems in a production environment.