Senior Data Engineer & Consultant (Databricks / Snowflake)

Join Our Team at Lean Solutions Group (LSG)!

Lean Solutions Group (LSG) is a next-generation solutions provider combining AI-driven automation, industry expertise, and tech-powered talent. Built in the demanding Supply Chain sector, our model now supports 600+ clients across multiple industries, powered by 10,000+ employees in five countries. We help businesses achieve immediate efficiency, long-term resilience, and scalable growth by integrating intelligent technology, optimized processes, and high-performance teams.

At LSG, we believe in your talent and your potential. Join a multicultural, people-first environment where you can grow, sharpen your skills, and unlock new career opportunities. Here, every day brings fresh challenges, collaboration, and purpose.

Our Mission: Transform business challenges into lasting success through purpose-built teams, technology, and expertise.

Our Vision: A world where people, empowered by technology, turn any challenge into a catalyst for growth.

Role Overview We are seeking a Senior Data Engineer & Consultant who thrives on solving tough architectural problems and writing clean, production-grade code. You will serve as the technical bridge between enterprise client leadership and distributed data teams—designing modern lakehouses, optimizing high-throughput ELT pipelines, and modernizing legacy data estates. This role combines deep hands-on development with client-facing technical strategy across AWS, GCP, Databricks, and Snowflake environments.

What You Will Do

• Pipeline Engineering: Architect, code, and deploy resilient, high-throughput batch and streaming ETL/ELT pipelines using Python, SQL, and modern orchestration tools.
• Architecture Modernization: Audit legacy client environments and build modern, scalable data platforms (Data Lakes, Lakehouses, Warehouses) tailored to enterprise scalability demands.
• Client Advisory: Partner directly with enterprise stakeholders to translate business requirements into technical roadmaps, performance benchmarks, and cost-optimized infrastructure.
• Performance Tuning: Diagnose bottlenecks, optimize queries, and configure auto-scaling across Databricks and Snowflake environments to control compute costs and latency.
• Data Reliability & Governance: Implement automated testing, CI/CD for data pipelines, monitoring, and strict data security protocols (RBAC, encryption, masking).

What You Bring

• 4+ Years Experience: Proven track record in production Data Engineering, Data Architecture, or Technical Data Consulting for enterprise systems.
• Platform Expertise: Deep hands-on experience implementing and optimizing Databricks (Delta Lake, PySpark) or Snowflake.
• Cloud Architecture: Demonstrated experience building data infrastructure natively within AWS (S3, Redshift, Glue) or GCP (BigQuery, GCS).
• Core Technical Stack: Advanced proficiency in Python and complex SQL query optimization and performance tuning.
• Consulting & Communication: Fluent English communication with a strong ability to translate complex technical concepts to business leaders in remote environments.

Preferred Qualifications

• Modern Tooling: Hands-on experience with dbt, Apache Airflow, or Dagster.
• DataOps: Familiarity with infrastructure-as-code and CI/CD deployment pipelines (Git, Terraform, Docker).
• Certifications: Databricks Certified Data Engineer, Snowflake SnowPro, or AWS/GCP Data Specialty certifications.