Senior Data Lead - Azure Data Factory (ADF), Databricks
India
Job Description
Senior Data Lead - Azure Data Factory (ADF), Databricks
Noida, Uttar Pradesh

Job Summary

. Senior AtScale Developer (2)

Role Overview

We are looking for a Senior AtScale Developer responsible for developing, configuring, testing, optimizing, and supporting enterprise semantic models using AtScale.

The candidate should have strong hands-on experience in AtScale development, SQL, dimensional modeling, BI integration, and performance optimization, along with experience working with modern cloud data platforms.

Key Responsibilities

  • Design, develop, configure, and maintain AtScale semantic models.
  • Build dimensions, measures, hierarchies, calculated metrics, relationships, and business KPIs based on business requirements.
  • Translate reporting and analytical requirements into reusable semantic models.
  • Integrate AtScale models with underlying cloud data platforms such as Databricks, Snowflake, BigQuery, or Microsoft Fabric/Azure.
  • Enable semantic model consumption through Power BI, Tableau, Excel, Looker, and other analytical tools.
  • Develop and optimize SQL required for semantic-model implementation and troubleshooting.
  • Analyze query performance and optimize models to improve BI/reporting response times.
  • Work with data engineers to resolve issues in source models, fact/dimension structures, transformations, or data quality.
  • Conduct unit testing, integration testing, regression testing, and performance testing of semantic models.
  • Validate measures and business calculations against source data and agreed business definitions.
  • Troubleshoot production issues related to semantic models, data, queries, security, or BI consumption.
  • Support deployment and release activities across development, test, and production environments.
  • Maintain technical documentation covering semantic models, calculations, dependencies, and deployment configurations.
  • Work with architects and BI developers to ensure consistent implementation of enterprise semantic standards.
  • Participate in code/model reviews and contribute to reusable development standards and best practices.

Required Skills

  • Strong hands-on AtScale development experience.
  • Strong understanding of semantic modeling and multidimensional concepts.
  • Hands-on experience building:
    • Dimensions
    • Measures
    • Hierarchies
    • Relationships
    • Calculated metrics
    • Business KPIs
  • Advanced SQL skills.
  • Strong understanding of dimensional data modeling, including fact/dimension and star-schema designs.
  • Experience with Databricks, Snowflake, BigQuery, Microsoft Fabric/Azure, or comparable cloud platforms.
  • Experience integrating semantic models with BI tools such as Power BI or Tableau.
  • Experience troubleshooting query and analytical performance.
  • Understanding of SDLC, source control, testing, and deployment practices.

Preferred Skills

  • Experience working with large datasets and enterprise analytical workloads.
  • Databricks/Snowflake certifications or equivalent cloud/data certifications.
  • Knowledge of lakehouse architectures and Delta Lake.
  • Experience with metadata management and data governance.
  • Exposure to CI/CD and automated deployment.
  • Experience in Healthcare and Life Sciences environments is beneficial.

Experience

  • 7+ years of Data & Analytics / BI development experience.
  • 2+ years preferred of hands-on AtScale or comparable enterprise semantic-layer development.
  • Demonstrated experience delivering semantic models for enterprise BI/reporting use cases.

 

Key Responsibilities

. Senior AtScale Developer (2)

Role Overview

We are looking for a Senior AtScale Developer responsible for developing, configuring, testing, optimizing, and supporting enterprise semantic models using AtScale.

The candidate should have strong hands-on experience in AtScale development, SQL, dimensional modeling, BI integration, and performance optimization, along with experience working with modern cloud data platforms.

Key Responsibilities

  • Design, develop, configure, and maintain AtScale semantic models.
  • Build dimensions, measures, hierarchies, calculated metrics, relationships, and business KPIs based on business requirements.
  • Translate reporting and analytical requirements into reusable semantic models.
  • Integrate AtScale models with underlying cloud data platforms such as Databricks, Snowflake, BigQuery, or Microsoft Fabric/Azure.
  • Enable semantic model consumption through Power BI, Tableau, Excel, Looker, and other analytical tools.
  • Develop and optimize SQL required for semantic-model implementation and troubleshooting.
  • Analyze query performance and optimize models to improve BI/reporting response times.
  • Work with data engineers to resolve issues in source models, fact/dimension structures, transformations, or data quality.
  • Conduct unit testing, integration testing, regression testing, and performance testing of semantic models.
  • Validate measures and business calculations against source data and agreed business definitions.
  • Troubleshoot production issues related to semantic models, data, queries, security, or BI consumption.
  • Support deployment and release activities across development, test, and production environments.
  • Maintain technical documentation covering semantic models, calculations, dependencies, and deployment configurations.
  • Work with architects and BI developers to ensure consistent implementation of enterprise semantic standards.
  • Participate in code/model reviews and contribute to reusable development standards and best practices.

Required Skills

  • Strong hands-on AtScale development experience.
  • Strong understanding of semantic modeling and multidimensional concepts.
  • Hands-on experience building:
    • Dimensions
    • Measures
    • Hierarchies
    • Relationships
    • Calculated metrics
    • Business KPIs
  • Advanced SQL skills.
  • Strong understanding of dimensional data modeling, including fact/dimension and star-schema designs.
  • Experience with Databricks, Snowflake, BigQuery, Microsoft Fabric/Azure, or comparable cloud platforms.
  • Experience integrating semantic models with BI tools such as Power BI or Tableau.
  • Experience troubleshooting query and analytical performance.
  • Understanding of SDLC, source control, testing, and deployment practices.

Preferred Skills

  • Experience working with large datasets and enterprise analytical workloads.
  • Databricks/Snowflake certifications or equivalent cloud/data certifications.
  • Knowledge of lakehouse architectures and Delta Lake.
  • Experience with metadata management and data governance.
  • Exposure to CI/CD and automated deployment.
  • Experience in Healthcare and Life Sciences environments is beneficial.

Experience

  • 7+ years of Data & Analytics / BI development experience.
  • 2+ years preferred of hands-on AtScale or comparable enterprise semantic-layer development.
  • Demonstrated experience delivering semantic models for enterprise BI/reporting use cases.

 

Skill Requirements

. Senior AtScale Developer (2)

Role Overview

We are looking for a Senior AtScale Developer responsible for developing, configuring, testing, optimizing, and supporting enterprise semantic models using AtScale.

The candidate should have strong hands-on experience in AtScale development, SQL, dimensional modeling, BI integration, and performance optimization, along with experience working with modern cloud data platforms.

Key Responsibilities

  • Design, develop, configure, and maintain AtScale semantic models.
  • Build dimensions, measures, hierarchies, calculated metrics, relationships, and business KPIs based on business requirements.
  • Translate reporting and analytical requirements into reusable semantic models.
  • Integrate AtScale models with underlying cloud data platforms such as Databricks, Snowflake, BigQuery, or Microsoft Fabric/Azure.
  • Enable semantic model consumption through Power BI, Tableau, Excel, Looker, and other analytical tools.
  • Develop and optimize SQL required for semantic-model implementation and troubleshooting.
  • Analyze query performance and optimize models to improve BI/reporting response times.
  • Work with data engineers to resolve issues in source models, fact/dimension structures, transformations, or data quality.
  • Conduct unit testing, integration testing, regression testing, and performance testing of semantic models.
  • Validate measures and business calculations against source data and agreed business definitions.
  • Troubleshoot production issues related to semantic models, data, queries, security, or BI consumption.
  • Support deployment and release activities across development, test, and production environments.
  • Maintain technical documentation covering semantic models, calculations, dependencies, and deployment configurations.
  • Work with architects and BI developers to ensure consistent implementation of enterprise semantic standards.
  • Participate in code/model reviews and contribute to reusable development standards and best practices.

Required Skills

  • Strong hands-on AtScale development experience.
  • Strong understanding of semantic modeling and multidimensional concepts.
  • Hands-on experience building:
    • Dimensions
    • Measures
    • Hierarchies
    • Relationships
    • Calculated metrics
    • Business KPIs
  • Advanced SQL skills.
  • Strong understanding of dimensional data modeling, including fact/dimension and star-schema designs.
  • Experience with Databricks, Snowflake, BigQuery, Microsoft Fabric/Azure, or comparable cloud platforms.
  • Experience integrating semantic models with BI tools such as Power BI or Tableau.
  • Experience troubleshooting query and analytical performance.
  • Understanding of SDLC, source control, testing, and deployment practices.

Preferred Skills

  • Experience working with large datasets and enterprise analytical workloads.
  • Databricks/Snowflake certifications or equivalent cloud/data certifications.
  • Knowledge of lakehouse architectures and Delta Lake.
  • Experience with metadata management and data governance.
  • Exposure to CI/CD and automated deployment.
  • Experience in Healthcare and Life Sciences environments is beneficial.

Experience

  • 7+ years of Data & Analytics / BI development experience.
  • 2+ years preferred of hands-on AtScale or comparable enterprise semantic-layer development.
  • Demonstrated experience delivering semantic models for enterprise BI/reporting use cases.

 

Other Requirements

Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 223,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending June 2026 totaled $14.8 billion.