Cleartelligence - Lead Data Engineer - Snowflake DB/Data Build Tool

Description :

Position : Lead Data Engineer

Position Overview :

The Tech Lead Data Management will be responsible for providing technical leadership, solution oversight, and day-to-day coordination for a dedicated client pod consisting of India-based engineers and consultants. This role requires strong expertise in Snowflake, dbt, Fivetran, and modern data engineering practices, along with the ability to guide teams in implementing high-quality, scalable, cloud-based data solutions.

Unlike a formal people-management role, this position focuses on delivery excellence and client alignment rather than career development responsibilities. The Technical Lead will serve as the single point of contact for all India resources supporting the client, ensuring that technical execution, communication, and work quality remain consistent and aligned with client expectations. They will work closely with US-based architects, project managers, and client stakeholders to translate requirements into actionable technical tasks and ensure timely, high-impact delivery.

The ideal candidate is a hands-on technical expert with strong communication and coordination skillsable to mentor resources on best practices, oversee solution design and implementation, and ensure smooth collaboration across geographies without formal people-management duties.

Key Responsibilities :

Client & Project Leadership :

- Act as the single point of coordination for India-based resources supporting a specific US client.

- Partner closely with US-based project managers, architects, and client stakeholders to ensure alignment of workstreams and expectations.

- Support requirement clarification, sprint planning, backlog grooming, and ongoing technical discussions with the client team.

- Provide visibility into India pod progress, risks, dependencies, and delivery timelines.

- Ensure seamless communication and handoff across time zones

Technical Leadership & Solution Execution :

- Lead the design, development, and optimization of Snowflake-based data solutions.

- Oversee ELT development using dbt and ingestion pipelines using Fivetran or similar tools.

- Guide team members on data modeling, performance tuning, SQL best practices, and cloud data platform patterns.

- Conduct technical reviews of queries, dbt models, pipelines, and documentation.

- Troubleshoot technical issues and ensure rapid resolution of delivery blockers.

- Implement and enforce data security, governance, and compliance standards across the client environment.

Delivery Oversight & Quality Assurance :

- Ensure India pod deliverables meet quality standards, established frameworks, and client acceptance criteria.

- Monitor adherence to best practices in data engineering, data governance, and architectural guidelines.

- Coordinate testing, validation, deployment activities, and release support for pipelines and transformations.

- Establish and maintain technical operating procedures, coding standards, and documentation requirements.

Team Coordination & Mentorship (Without People Management) :

- Provide technical mentorship, pairing, and coaching to engineers and analysts within the India client pod.

- Support knowledge transfer and promote consistent delivery practices across the team.

- Help resolve day-to-day questions, unblock technical issues, and guide junior team members on best practices.

- Maintain a collaborative, supportive environment without formal HR responsibilities.

Cross-Functional Collaboration :

- Work closely with US-based leads on architectural decisions and long-term solution roadmaps.

- Participate in internal practice discussions, knowledge-sharing sessions, and reusable artifact development.

- Contribute feedback to the Practice Director and Delivery Leads to support staffing decisions and future planning.

Required Skills & Experience :

Technical Expertise :

- 7 to 10+ years of experience in data engineering, analytics, and enterprise data solutions.

- 5+ years of hands-on experience with Snowflake, including design, optimization, and administration.

- 3+ years of experience with DBT for data transformations and workflow automation.

- 3+ years of experience using Fivetran for automated data ingestion.

- Strong expertise in SQL, ETL/ELT workflows, and cloud-based data modeling.

- Experience integrating Snowflake with BI tools (Power BI, Tableau, Looker, etc.).

- Familiarity with Python, Airflow, or other orchestration tools for advanced data processing.

- Knowledge of AWS, Azure, or GCP cloud ecosystems.

- Experience implementing data governance, metadata management, and security policies.

Leadership & Delivery Skills :

- Proven track record guiding technical teams in a client-facing environment.

- Excellent coordination skills with the ability to manage multiple workstreams concurrently.

- Strong problem-solving, analytical thinking, and troubleshooting capabilities.

- Ability to translate complex business requirements into clear technical tasks.

- Effective verbal and written communication skills for cross-geography collaboration.

Why Join Us?

- Work on cutting-edge cloud data solutions for leading US-based clients.

- Be part of a dynamic and innovative consulting team, collaborating with top industry professionals.

- Gain exposure to high-impact projects that drive real business transformation.

- Enjoy flexible working hours with US time zone overlap.

- Accelerate your career in a leadership role with growth opportunities.