Sr. Data Engineer (Snowflake)

Data Ideology; Pittsburgh (Allegheny County); On-site; USD 100,000 - 130,000; Full time

Benefits offered by this job

Flexible Time Off Policy

Health Benefits

Retirement Plan

Training and Certification Reimbursement

Utilization Based Incentive Program

Commission Incentive Program

Referral Bonuses

Work from Home

Job summary

A data analytics consultancy is seeking a Sr. Data Engineer with expertise in Snowflake to design and implement data solutions. The ideal candidate has over 7 years of experience in data engineering and strong skills in SQL and Python. This role focuses on technical execution and solution architecture, requiring collaboration with clients to deliver high-quality implementations. Benefits include flexible time off, health benefits, and remote work options.

Qualifications

• 7+ years of experience in data engineering, data warehousing, or data architecture.
• 3+ years of hands-on Snowflake experience.
• Strong SQL and Python skills, with production experience using dbt.
• Familiarity with cloud platforms and modern data tooling.
• Excellent communication skills, with the ability to collaborate effectively.

Responsibilities

• Design and build scalable, secure data solutions in Snowflake.
• Develop and optimize data pipelines using various tools.
• Participate in requirements gathering and translate into designs.
• Guide best practices in Snowflake performance and management.
• Mentor junior engineers and support knowledge sharing.

Skills

Data engineering

Data warehousing

Snowflake

SQL

Python

Collaboration

Communication

Education

7+ years of experience in data engineering

Consulting or client-facing delivery experience

Tools

dbt

AWS

Azure

GCP

Airflow

Fivetran

Power BI

Looker

Informatica

Job description

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.

Sr. Data Engineer - (Snowflake)

Data Ideology is seeking a Sr. Snowflake Data Engineer 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

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

Supervisory Responsibilities: None

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

Work Environment

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

Physical Demands

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

Benefits

• Flexible Time Off Policy
• Eligibility for Health Benefits
• Retirement Plan
• Training and Certification Reimbursement
• Utilization Based Incentive Program
• Commission Incentive Program
• Referral Bonuses
• Work from Home

Data Ideology is an EEO Employer