Lead Data Engineer (Snowflake)

Data Ideology
At DI, we provide Data & Analytics expertise to drive measurable business outcomes, often solving complex business problems for our clients.  Our data analytics advisory services enable our customers to transform data into insights by driving a culture of empowerment and ownership of results.  Our team consists of highly motivated individuals who are passionate about learning, understanding, collaborating, and who are intellectually curious.  For more information about Data Ideology, visit www.dataideology.com.
Lead Data Engineer (Snowflake)
Data Ideology is seeking a Lead Data Engineer (Snowflake) to join our growing team in a client-facing, consultative role that blends solution design with hands-on delivery. You will work directly with clients and our internal teams to design, implement, and optimize modern data platforms in Snowflake.
This role is ideal for experienced data engineers who want to expand their impact by engaging with clients early in the process to understand requirements, shape solutions, and then lead the delivery of high-quality implementations. While you will occasionally support the scoping of new projects, this is not a sales role — your primary focus will be on technical execution, solution architecture, and delivery leadership.
Responsibilities
To perform in this position successfully, an individual must be able to perform each essential duty satisfactorily.  Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.  Other duties may be assigned to meet business needs.

• 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.

• 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.
• Preferred - SnowPro Certification

• Remote work from home.
• Hours of work and days are generally Monday through Friday. Specific business hours will depend on client needs.

• Must be able to remain in a stationary position 50% of the time.
• The person in this position must occasionally move about inside the office to access file cabinets, library stacks, office machinery, etc.
• Constantly operates a computer and other office productivity machinery, such as a calculator, copy machine, and printer.
• The person in this position frequently communicates with clients and coworkers.  Must be able to exchange accurate information in these situations.

• Eligible for Medical, Dental, Vision, 401(k), training and certification reimbursement, and flexible time off in accordance with company policies.