Lead Data Engineer (Snowflake)

Allata is a global consulting and technology services firm with offices in the US, India, and Argentina. We help organizations accelerate growth, drive innovation, and solve complex challenges by combining strategy, design, and advanced technology. Our expertise covers defining business vision, optimizing processes, and creating engaging digital experiences. We architect and modernize secure, scalable solutions using cloud platforms and top engineering practices.

Allata also empowers clients to unlock data value through analytics and visualization and leverages artificial intelligence to automate processes and enhance decision-making. Our agile, cross-functional teams work closely with clients, either integrating with their teams or providing independent guidance-to deliver measurable results and build lasting partnerships.

We're looking for a hands-on Lead Data Engineer to own and evolve our clients' Snowflake data platform. You'll lead and mentor a squad of data engineers, shape the technical roadmap, and deliver high-quality, cost-efficient, and secure data solutions. This role blends architecture, delivery leadership, and coding-ideal for someone who can set standards, coach others, and still dive deep when needed.

Role & Responsibilities :

• Define and evolve Snowflake platform architecture, standards, and best practices.
• Translate business goals into a pragmatic technical roadmap and delivery plan.
• Lead and mentor data engineers; establish quality bars, review code, and guide execution.
• Manage delivery using Agile rituals; align priorities across data, analytics / BI, and application teams.
• Design, build, and optimize ELT pipelines on Snowflake with an ELT-first approach (dbt preferred).
• Implement modern data ingestion using tools such as Fivetran, ADF, Glue, or Matillion.
• Set up orchestration and CI / CD for data using Airflow or Dagster and Git-based pipelines.
• Ensure data quality, observability, monitoring, alerting, documentation, and runbooks.
• Apply performance tuning and cost optimization in Snowflake, including query profiling and warehouse sizing.
• Implement security and governance in Snowflake (RBAC, masking, row access policies, auditing, data sharing).
• Facilitate discovery with stakeholders, clarify requirements, and communicate trade-offs and recommendations.

Hard Skills - Must have :

Nice to have / It's a plus :

Soft Skills :

At Allata, we value differences.

Allata is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

Allata makes employment decisions without regard to race, color, creed, religion, age, ancestry, national origin, veteran status, sex, sexual orientation, gender, gender identity, gender expression, marital status, disability or any other legally protected category.

This policy applies to all terms and conditions of employment, including but not limited to, recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.