EXL

Lead Assistant Manager

EXL  •  Gurugram, IN (Onsite)  •  10 days ago
Apply
Save Job
Mark Applied Mark Interviewed Mark Offered
Hide Job Report Job
AI can make mistakes so check important info. Chat history is never stored.

Job Description

We are looking for a skilled Data Engineer with strong DBT experience to design, develop, and optimize scalable data transformation pipelines on modern cloud data platforms. The ideal candidate should have hands-on expertise in DBT (Data Build Tool), SQL, cloud data warehouses, and ELT processes.

The role will involve building analytics-ready datasets, implementing data quality frameworks, and collaborating with data architects, analysts, and business stakeholders to deliver reliable and scalable data products.

Key Responsibilities

Data Engineering & ELT Development

  • Design and develop ELT pipelines using DBT.
  • Build reusable, scalable, and maintainable data transformation models.
  • Develop staging, intermediate, and mart layers following DBT best practices.
  • Implement modular SQL transformations and macros.
  • Create and maintain source-to-target mappings.

Data Modeling

  • Design dimensional models, fact tables, and star schemas.
  • Build business-friendly semantic layers for reporting and analytics.
  • Support enterprise data warehouse initiatives.

Data Quality & Testing

  • Implement DBT tests for:
    • Uniqueness
    • Referential integrity
    • Null validation
    • Custom business rules
  • Monitor and improve overall data quality.
  • Perform root cause analysis for data issues.

Cloud Data Platform Development

  • Work with cloud platforms such as:
    • Snowflake
    • Databricks
    • BigQuery
    • Azure Synapse
    • Redshift
  • Optimize query performance and manage compute costs.

CI/CD & DevOps

  • Integrate DBT projects with Git and CI/CD pipelines.
  • Automate deployments across Development, QA, and Production environments.
  • Maintain documentation and lineage using DBT documentation features.

Collaboration

  • Work closely with Data Architects, Analysts, and Business Teams.
  • Participate in Agile ceremonies and sprint planning.
  • Translate business requirements into scalable data solutions.

Required Skills

Core Technical Skills

  • DBT (Data Build Tool)
  • Advanced SQL
  • Data Warehousing Concepts
  • Data Modeling
  • ETL / ELT Development

Cloud Platforms

  • Snowflake
  • Databricks
  • Google BigQuery
  • Azure Synapse Analytics
  • AWS Redshift

Programming

  • Python
  • SQL
  • Shell Scripting (Preferred)

Data Engineering Tools

  • Airflow
  • Azure Data Factory
  • Databricks Workflows
  • GitHub / GitLab

Data Quality & Governance

  • Data Lineage
  • Data Catalog
  • Data Validation Frameworks
  • Metadata Management

Desired Experience

  • Experience building DBT models on Snowflake or BigQuery.
  • Experience implementing data validation checks and automated testing through DBT.
  • Experience creating analytics-ready datasets and semantic models.
  • Exposure to Medallion Architecture, Lakehouse, and Modern Data Platforms.

Qualifications

  • Bachelor's degree in Computer Science, Engineering, Information Technology, or related field.
  • 4–8 years of Data Engineering experience.
  • Minimum 2+ years of hands-on DBT development experience.

Preferred Certifications

  • SnowPro Certification
  • Databricks Data Engineer Associate/Professional
  • Google Professional Data Engineer
  • Microsoft Azure Data Engineer Associate

Nice-to-Have Skills

  • DBT Cloud
  • Jinja Macros
  • Terraform
  • Kafka
  • Spark/PySpark
  • Data Vault 2.0

AI-assisted development tools (GitHub Copilot, Microsoft Copilot)

EXL

About EXL

Choosing a digital partner is about more than capabilities — it’s about collaboration and character.

Unrealistic overhauls and off-the-shelf products ignore what matters most — your unique needs, culture, goals, and your legacy data and technology environments.

At EXL, our collaboration is built on ongoing listening and learning to adapt our methodologies. We’re your business evolution partner—tailoring solutions that make the most of data to make better business decisions and drive more intelligence into your increasingly digital operations.

Whether your goals are scaling the use of AI and digital, redesign operating models, or driving better and faster decisions, we’re here to partner with you to help you gain—and maintain—competitive advantage with efficient, sustainable models at scale.

Our expertise in transformation, data science, and change management helps make your business more efficient and effective, improve customer relationships and enhance revenue growth. Instead of focusing on multi-year, resource- and time-intensive platform designs or migrations, we look deeper at your entire value chain to integrate strategies with impact.

We use our specialization in analytics, digital interventions, and operations management—alongside deep industry expertise — to deliver solutions that help you outperform the competition.

At EXL, it’s all about outcomes—your outcomes—and delivering success on your terms. Share your goals with us and together, we’ll optimize how you leverage data to drive your business forward.

For more information, visit www.exlservice.com.

Industry
Consulting & Advisory
Company Size
10,000+ employees
Headquarters
New York, NY
Year Founded
Unknown
Website
exlservice.com
Social Media