Sr. Data Engineer (Snowflake)

Data Ideology; Pittsburgh (Allegheny County); Remote; 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 leading data analytics firm is seeking a Sr. Data Engineer specializing in Snowflake to design and optimize modern data platforms. The ideal candidate will have over 7 years of experience in data engineering and 3 years of hands-on experience with Snowflake, and will engage directly with clients to shape solutions. This remote role offers flexibility, a strong focus on technical execution, and opportunities for professional development. Benefits include flexible time off, health benefits, and training reimbursement.

Qualifications

• 7+ years of experience in data engineering, data warehousing, or data architecture.
• 3+ years of hands-on Snowflake experience, including performance tuning and data sharing.
• Strong SQL and Python skills, with production experience using dbt.
• Prior experience in a consulting or client-facing delivery role.

Responsibilities

• Design and build scalable, secure, and cost-effective data solutions in Snowflake.
• Collaborate with engagement managers to help scope work and provide technical input for SOWs.
• Lead modernization and migration initiatives to move clients from legacy systems into Snowflake.

Skills

Data engineering

SQL

Python

Snowflake

dbt

Cloud platforms (AWS, Azure, GCP)

Consulting experience

Communication skills

Tools

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