Sr Consultant

India
Job Description

Sr Consultant

A.g.nioda, Uttar Pradesh

Job Summary

To lead a group of Junior Analysts. Deliver projects within timelines in collaboration with internal/external stakeholders

  • Design Fabric architectures: OneLake, Lakehouse/Warehouse, medallion layering, workspace strategy, and capacity planning.
  • Build pipelines using Data Factory, Dataflows Gen2, and PySpark notebooks, including incremental and CDC loads.
  • Deliver Power BI semantic models using Direct Lake and optimised DAX.
  • Implement governance and security with Microsoft Purview, OneLake security, and RLS.
  • Set up CI/CD with Git integration and deployment pipelines.
  • Monitor and optimise capacity usage and cost.
  • Lead migrations from Synapse, ADF, or on-prem SQL to Fabric.
  • Mentor engineers and support estimates and solution proposals.

Key Responsibilities

1. Act As A Subject Matter Expert wherever required. Mentor the Junior Analysts to improve their Performance Through Feedback And Coaching. Build Product Expertise On A Large Quantity Of Diverse Products Through Thorough Research And Analysis Of Data From Multiple Channels. Provide Value Add To Business Process / Application Improvement Through Research And Analysis
2. Prepare And Develop Documentation For Tools And Project Processes To Support The Lead Trainer And Team Lead. Define Deliverables And Measures For The Project. Track Metrics At And Engagement And Individual Level And Monitor Timelines / Milestones
3. Prepare Periodic Report. Escalate And Solve Challenges With Respect To Projects In Coordination With Internal/External Stake Holders
4. Oversee A Small Group Of Project Team Who Are Responsible To Optimize Work Allocation To Maximize And Balance The Broad Set Of Goals Defined By The Team Leads

Skill Requirements

  • 10+ years in data platforms, with 3+ years in an architect or lead role.
  • Production delivery experience on Microsoft Fabric.
  • Strong Azure data stack: ADF, Synapse, ADLS Gen2, Azure SQL.
  • Expert SQL and PySpark; dimensional modelling; Delta Lake.
  • Advanced Power BI and DAX.
  • Microsoft Purview and data governance experience.
  • Strong stakeholder communication.

 

Other Requirements

null
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 230,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 September 2026 totaled $14.8 billion.