Data Engineering And Visualization SME Senior Consultant Specialist

Job Description

Some careers shine brighter than others.

If you’re looking for a career that will help you stand out, join HSBC and fulfil your potential. Whether you want a career that could take you to the top, or simply take you in an exciting new direction, HSBC offers opportunities, support and rewards that will take you further.

HSBC is one of the largest banking and financial services organisations in the world, with operations in 64 countries and territories. We aim to be where the growth is, enabling businesses to thrive and economies to prosper, and, ultimately, helping people to fulfil their hopes and realise their ambitions.

We are currently seeking an experienced professional to join our team in the role of Senior Consultant Specialist

In this role, you will:

• Design, develop, and maintain high-performance data pipelines using GCP services such as BigQuery, Dataflow, Pub/Sub, and Composer (Airflow).
• Design and develop Looker Dashboards, with apt security provisioning and drill down capabilities.
• Ensure data security, lineage, quality, and compliance across GCP data ecosystems through IAM, audit logging, data encryption, and schema management.
• Monitor, troubleshoot, and optimize pipeline and warehouse performance using GCP native tools such as Cloud Monitoring, Cloud Logging, and BigQuery Optimizer.
• 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 quality, governance, and security best practices across all layers of the data stack.
• Write clean, maintainable, and efficient code following best practices.
  
  

Requirements

To be successful in this role, you should meet the following requirements:

• 9–12 years of experience in data engineering, with at least 3–5 years hands-on experience specifically in Google Cloud Platform (GCP) and BI tools like Looker.
• BigQuery (data modeling, 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.
• Basic to intermediate knowledge of Python for scripting and automation.
• Exposure to ETL and batch scheduling/ orchestration solutions
• Experience with version control systems like Git and branching strategies.
• Hands on experience in Looker with design, development, configuration/ setup, dashboarding and reporting techniques.
• Experience building and maintaining LookML models, Explores, PDTs, and semantic layers.
• Understanding of security provisioning and access controls, performance tuning of dashboard/ reports based on large dataset, building drill down capabilities.
• Proven ability to design scalable, user-friendly dashboards and self-service analytics environments.
• Expertise in optimizing Looker performance: materialized views, query tuning, aggregate tables.
• Strong command over Row-Level Security, Access Filters, and permission sets in Looker to support enterprise-grade data governance.
• 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.
• Flexible to work in shifts and provide on-call support, owning the smooth operation of applications and systems.
  
  

HSBC is committed to building a culture where all employees are valued, respected and opinions count. We take pride in providing a workplace that fosters continuous professional development, flexible working and opportunities to grow within an inclusive and diverse environment. Personal data held by the Bank relating to employment applications will be used in accordance with our Privacy Statement, which is available on our website.

Issued by – HSBC Software Development India

---