Snowflake Data Engineer
Data Ideology
- Pittsburgh, PA
- Permanent
- Full-time
- Design and build robust, scalable, and secure data architectures in Snowflake, aligned with industry and client best practices.
- Implement ETL/ELT pipelines using tools such as DBT, Python, CloverDX, and cloud-native services.
- Conduct technical discovery sessions and assessments to understand client requirements and translate them into solution designs.
- Collaborate with pre-sales and account teams to scope work, define solutions, and estimate effort for Statements of Work (SOWs).
- Serve as a Snowflake SME, advising on architecture, performance tuning, cost optimization, security, and workload design.
- Partner with clients to modernize legacy data platforms and migrate to Snowflake-based data ecosystems.
- Integrate with data visualization, governance, and AI/ML frameworks to support advanced analytics and business intelligence use cases.
- Contribute to reusable assets such as templates, frameworks, reference architectures, and POCs.
- Lead technical delivery for client engagements, supporting both implementation and ongoing solution refinement.
- Mentor junior engineers and participate in internal knowledge-sharing and technical upskilling initiatives.
Education and Experience:
- 7+ years of experience in data engineering, data warehousing, or data architecture roles.
- 3+ years of hands-on Snowflake experience including advanced features such as performance tuning, access control, data sharing, Snowpark, or Snowpipe.
- Strong experience with SQL, Python, and DBT in production environments.
- Proficiency in cloud infrastructure such as AWS, Azure, or GCP and modern data tooling such as Airflow, Fivetran, Power BI, Looker, or Informatica.
- Demonstrated success in client-facing delivery roles or solution architecture in consulting or services environments.
- Deep understanding of cloud-native architectures, data modeling, and data pipeline orchestration.
- Experience with streaming data, unstructured data, or real-time analytics is a plus.
- Excellent verbal and written communication skills and the ability to present to both technical and executive stakeholders.
- Proven ability to influence client architecture decisions and lead data modernization initiatives.
- SnowPro Core Certification (Required).
- One or more SnowPro Advanced Certifications such as Data Engineer, Architect, Snowpark, or Data Analyst.
- Additional cloud or data platform certifications such as AWS, Azure, dbt, or Databricks are a plus.
- 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.
- Flexible Time Off Policy
- Eligibility for Health Benefits
- Retirement Plan with Company Match
- Training and Certification Reimbursement
- Utilization Based Incentive Program
- Commission Incentive Program
- Referral Bonuses
- Work from Home