Lead consultant

15 hours ago


Bengaluru, Karnataka, India Withum Full time
Job Description

Withum is a place where talent thrives - where who you are matters. Its a place of endless opportunities for growth. A place where entrepreneurial energy plus inclusive teamwork equals exponential results. Withum empowers clients and our professional staff with innovative tools and solutions to address their accounting, tax and overall business management and operational needs. As a US nationally ranked Top 25 firm, we recruit only the best and brightest people with a genuine passion for the business.

We are seeking an experienced Lead Consultant Data Engineering with a strong background in consulting services and hands-on skills in building modern, scalable data platforms and pipelines. This is a client-facing, delivery-focused role. Please note that this position is centered around external client delivery and is not part of an internal IT or product engineering team.

This is a foundational hire. You will be responsible for delivering hands-on client work, support for our proprietary data products, and building the team underneath you.

Withums brand is a reflection of our people, our culture and our strength. Withum has become synonymous with teamwork and client service excellence. The cornerstone of our success can truly be accredited to the dedicated professionals who work here every day, easy to work with a sense of purpose and caring for their co-workers and whose mission is to help our clients grow and thrive. But our commitment goes beyond our clients as we continue to live the Withum Way, promoting personal and professional growth for all team members, clients, and surrounding communities.

How Youll Spend Your Time:

- Architect, implement, and optimize data transformation pipelines, data lakes, and cloud-native warehouses for mid- and upper mid-market clients.
- Deliver hands-on engineering work across client environments building fast, scalable, and well-documented pipelines that support both analytics and AI use cases.
- Lead technical design and execution using tools such as Tableau, Microsoft Fabric, Synapse, Power BI, Snowflake, and Databricks.
- Also have a good hands-on familiarity with SQL Databases.
- Optimize for sub-50GB datasets and local or lightweight cloud execution where appropriate minimizing unnecessary reliance on cluster-based compute.
- Collaborate with subject-matter experts to understand business use cases prior to designing data model.
- Operate as a client-facing consultant: conduct discovery, define solutions, and lead agile project delivery.
- Switch context rapidly across 23 active clients or service streams in a single day.
- Provide support for our proprietary data products as needed.
- Provide advisory and strategic input to clients on data modernization, AI enablement, and FP&A transformation efforts.
- Deliver workshops, demos, and consultative training to business and technical stakeholders.
- Ability to implement coding modifications to pre-existing code/procedures in a manner that results in a validated case study (i.e. if done properly, the result will be xyz and the total amount will reconcile to abc).
- Take full ownership of hiring, onboarding, and mentoring future data engineers and analysts within the India practice.
- During bench time, contribute to building internal data products and tooling powering our own consulting operations (e.g., utilization dashboards, delivery intelligence, practice forecasting).
- Help define and scale delivery methodology, best practices, and reusable internal accelerators for future engagements.
- Ability to communicate openly about conflicting deadlines to ensure prioritization aligns with client expectations, with ample time to reset client expectations as needed.
- Ensure coding is properly commented to help explain logic or purpose behind more complex sections of code.

Requirements:

- 6+ years of hands-on experience in data engineering roles, at least 3+ years in a consulting or client delivery environment.
- Proven ability to context-switch, self-prioritize, and communicate clearly under pressure.
- Demonstrated experience owning full lifecycle delivery, from architecture through implementation and client handoff.
- Strong experience designing and implementing ETL / ELT pipelines, preferably in SQL-first tools (e.g., dbt core, SQLMesh, DuckDB).
- Experience with Microsoft SQL server / SSIS for maintenance and development of ETL processes.
- Real-world experience with SQL Databases, Databricks, Snowflake, and/or Synapse and a healthy skepticism of when to use them.
- Deep understanding of data warehousing, data lakes, data modeling, and incremental processing.
- Proficient in Python for ETL scripting, automation, and integration work.
- Experience with dbt core a comparable tool such as SQLMesh, Dataform, etc, in production environments.
- Strong practices around data testing, version control, documentation, and team-based dev workflows.
- Working knowledge of Power BI, Tableau, Looker, or similar BI tools enough to support downstream teams but not as your primary skillset.
- Experience building platforms for AI/ML workflows or supporting agentic architectures.
- Familiarity with Microsoft Fabric&aposs Lakehouse implementation, Delta Lake, Iceberg, and Parquet.
- Background in DataOps, CI/CD for data pipelines, and metadata management.
- Microsoft certifications (e.g., Azure Data Engineer, Fabric Analytics Engineer) are a plus

Website: www.withum.com

Withum will not discriminate against any employee or applicant for employment because of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or because he or she is a protected veteran.
  • Lead Consultant

    4 weeks ago


    Bengaluru, Karnataka, India GENPACT Full time

    Genpact NYSE G is a global professional services and solutions firm delivering outcomes that shape the future Our 125 000 people across 30 countries are driven by our innate curiosity entrepreneurial agility and desire to create lasting value for clients Powered by our purpose the relentless pursuit of a world that works better for people we serve...

  • Lead consultant

    24 hours ago


    Bengaluru, Karnataka, India Withum Full time

    Withum is a place where talent thrives - where who you are matters. It's a place of endless opportunities for growth. Withum empowers clients and our professional staff with innovative tools and solutions to address their accounting, tax and overall business management and operational needs. We are seeking an experienced Lead Consultant – Data Engineering...

  • Lead Consultant

    4 weeks ago


    Bengaluru, Karnataka, India HCLTech Full time

    Job Description:SAP Security and GRC Lead ConsultantExperience: 7 to 10 yrsLocation: Noida, Chennai, Bangalore, Pune, KolkataJob SummaryThe Lead Consultant in SAP Security GRC Administration will be responsible for overseeing and managing the security and compliance aspects of the SAP system. They will play a crucial role in implementing, maintaining, and...

  • Lead Consultant

    1 week ago


    Bengaluru, Karnataka, India NTT DATA Business Solutions Full time ₹ 9,00,000 - ₹ 12,00,000 per year

     Job Description:Convince us with your potential: BASIS – L3/Lead Consultant Customer centric skills, communication skills, analytical skills, result driven approach and collaborative skills. These skills are essential to essay the role of a BASIS - L3/Lead Consultant . In addition, it's important that you recognize everything in the checklist...

  • Lead consultant

    3 days ago


    Bengaluru, Karnataka, India Withum Full time

    Withum is a place where talent thrives - where who you are matters. It's a place of endless opportunities for growth. A place where entrepreneurial energy plus inclusive teamwork equals exponential results. Withum empowers clients and our professional staff with innovative tools and solutions to address their accounting, tax and overall business management...

  • Lead consultant

    3 days ago


    Bengaluru, Karnataka, India Withum Full time

    Withum is a place where talent thrives - where who you are matters. It's a place of endless opportunities for growth. A place where entrepreneurial energy plus inclusive teamwork equals exponential results. Withum empowers clients and our professional staff with innovative tools and solutions to address their accounting, tax and overall business management...

  • Lead Consultant

    4 weeks ago


    Bengaluru, Karnataka, India HCLTech Full time

    Job Description:SAP S/4HANA Transportation ManagementExperience: 6 to 10 yrsLocation: Noida, Chennai, Bangalore, Pune, KolkataThe Lead Consultant in SAP S/4HANA Transportation Management is responsible for overseeing and leading the implementation, configuration, and maintenance of SAP S/4HANA Transportation Management solutions to optimize transportation...

  • Lead Consultant

    4 weeks ago


    Bengaluru, Karnataka, India HCLTech Full time

    Job Description:SAP S/4HANA Quality Management Experience: 6 to 8 yrsLocation: Noida, Chennai, Bangalore, Pune, KolkataThe Lead Consultant (SAP S/4HANA Quality Management) will be responsible for managing and ensuring the quality of SAP S/4HANA implementations and enhancements. They will be in charge of overseeing all aspects of quality management within the...


  • Bengaluru, Karnataka, India Techs to Suit Inc Full time

    Position - Lead O9 Functional Consultant - Manager Job Location - Bangalore , Work from Office Experience - 12 to 16 Years Gather and translate business requirements into functional specifications for the o9 platform. Lead end-to-end o9 implementation projects, including configuration, integration, and testing. Support integration with ERP systems (Oracle)...


  • Bengaluru, Karnataka, India beBeeFinance Full time ₹ 1,50,00,000 - ₹ 2,50,00,000

    Role: Finance Transformation ExpertExperience: 8-15 years of experience in finance system transformation, including implementing ERPs and process consulting.Key Responsibilities:Provide advisory services to global manufacturing clients on ERP selection, implementation, and process assessment to achieve finance efficiencies.Lead breakthrough domain consulting...