Senior Snowflake Data Engineer - Remote & Client-Facing

Data Ideology, LLC; Pittsburgh (Allegheny County); Remote; USD 120,000 - 180,000; Full time

Benefits offered by this job

Medical, Dental, Vision

401(k)

Training and certification reimburse

Flexible time off

Job summary

Data Ideology is seeking a Sr. Snowflake Data Engineer to join our client-facing team and design, implement, and optimize modern data platforms in Snowflake.

You will work directly with clients and our internal teams to deliver high-quality implementations while shaping solution architecture and project plans. This role focuses on technical execution, delivery leadership, and mentorship, with opportunities to influence multiple engagements and drive best practices across data engineering

Qualifications

• 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

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.

Skills

SQL

Python

Communication

Cloud platforms

Tools

Snowflake

dbt

CloverDX

Airflow

Fivetran

Power BI

Looker

Informatica

Snowpark

Snowpipe

Job description

Data Ideology is seeking a Sr. Snowflake Data Engineer to join our client-facing team and design, implement, and optimize modern data platforms in Snowflake.

You will work directly with clients and our internal teams to deliver high-quality implementations while shaping solution architecture and project plans. This role focuses on technical execution, delivery leadership, and mentorship, with opportunities to influence multiple engagements and drive best practices across data engineering