The Job

Senior Technical Lead

Technology, Data & Digital · Data, AI & Analytics · Data Analysis · Data Engineering · Data Science

Join for updates

In short

As an Analytics Engineer on AWS, you will own the semantic modelling and governed metrics layer, building robust transformations to facilitate analytics. You will ensure trust in metrics, performance at scale, and effective stakeholder enablement, with key responsibilities including modelling, ELT, metrics governance, BI delivery, and quality assurance.

Responsibilities

  • Design star schemas and domain marts, implement tests, documentation, and incremental strategies.
  • Define and version business metrics, implement semantic layer, and ensure consistency across BI.
  • Support building BI datasets and dashboards, implement RLS/column level security, and optimise SPICE, query performance, and UX.
  • Add DQ checks in pipelines, monitor freshness and accuracy, and partner with Core Data Engineer on upstream contracts and SLAs.
  • Utilize Git driven development, perform PR reviews, manage environment promotion, and automate model validation and BI artefact deployment.
  • Tune Redshift sort/dist keys, WLM/concurrency scaling, and Athena partitioning and file formats for efficient queries.
  • Translate requirements, document definitions, run training, and maintain a catalogue of metrics/datasets in Glue Catalog.

Requirements

  • 10+ years in analytics engineering.
  • Expert SQL and solid Python skills.
  • Strong semantic data modelling and documentation experience.
  • Clear understanding of ABAC on Data products.
  • 3+ years in dbt (models/macros/tests/exposures) or Glue Data Governance.
  • 3+ years experience with Redshift/Serverless and/or Athena.
  • Experience with Glue Catalog integration.
  • 3+ years delivering governed data products on cloud.
  • 5+ years working with designing data architecture on medallion architecture.
  • Proficiency in version control and CI/CD (GitHub).
  • YAML/Jinja proficiency.
  • Experience in metric governance and change management.
  • Experience in stakeholder engagement and requirements translation.

Desired Qualifications

  • AWS SMUS/Datazone experience strongly preferred.
  • Experience with dbt Semantic Layer/MetricFlow.
  • Experience with QuickSight Q.
  • Experience with Tableau/Power BI.
  • Experience with Iceberg/Spectrum.
  • Experience with Great Expectations.
  • Familiarity with Lake Formation policies and policy as code approaches.
  • Experience with data mesh/domain ownership and feature store patterns (SageMaker Feature Store).
#Analytics Engineer#AWS#SQL#Python#dbt#Data Modeling#ELT#Metrics Governance#BI#Cloud#CI/CD#Redshift#Athena#Data Architecture
HCLTech Logo

Company

HCLTech

Job Posted

1 month ago

Employment Type

Full Time

WorkMode

On Site

Experience Level

Senior

Locations

Bengaluru, India

Applicants

Be an early applicant