Lead Data Engineer (Snowflake)

Data Ideology is seeking a Lead Data Engineer (Snowflake) for a client-facing, consultative role designing, implementing, and optimizing modern data platforms. The role combines solution architecture and technical delivery leadership, including client discovery, Snowflake modernization and migration, and mentoring engineers.

Responsibilities:

• Design and build scalable, secure, and cost-effective data solutions in Snowflake
• Develop and optimize data pipelines using tools such as dbt, Python, CloverDX, and cloud-native services
• Participate in discovery sessions with clients to gather requirements and translate them into solution designs and project plans
• Collaborate with engagement managers and account teams to help scope work and provide technical input for Statements of Work (SOWs)
• Serve as a Snowflake subject matter expert, guiding best practices in performance tuning, cost optimization, access control, and workload management
• Lead modernization and migration initiatives to move clients from legacy systems into Snowflake
• Integrate Snowflake with BI tools, governance platforms, and AI/ML frameworks
• Contribute to internal accelerators, frameworks, and proofs of concept
• Mentor junior engineers and support knowledge sharing across the team

Requirements:

• 7+ years of experience in data engineering, data warehousing, or data architecture
• 3+ years of hands-on Snowflake experience (performance tuning, data sharing, Snowpark, Snowpipe, etc.)
• Strong SQL and Python skills, with production experience using dbt
• Familiarity with cloud platforms (AWS, Azure, or GCP) and modern data tooling (Airflow, Fivetran, Power BI, Looker, Informatica, etc.)
• Prior experience in a consulting or client-facing delivery role
• Excellent communication skills, with the ability to collaborate across technical and business stakeholders
• SnowPro Certification