
Data Engineer – Snowflake
Cayuse Holdings
contract
Posted on:
Location Type: Hybrid
Location: Phoenix • Arizona • United States
Visit company websiteExplore more
Salary
💰 $70 - $75 per hour
About the role
- Utilize SQL window functions to perform advanced data calculations, such as running totals, moving averages, and rankings, enabling deeper insights into sales trends and performance metrics.
- Prepare and automate detailed real-time reports using Python and SQL, providing actionable insights to stakeholders and enhancing the company’s decision-making processes.
- Develop and optimize data pipelines using Snowpipe and SnowSQL for real-time and batch data ingestion, achieving improved data processing efficiency by 20%.
- Implement Snowpark to build scalable and high-performance data applications using Python, enhancing data manipulation, analysis, and processing capabilities.
- Leverage Snowflake’s Time Travel features to enable auditing, data recovery, and version control, ensuring data integrity and regulatory compliance.
- Manage Snowflake's Zero Copy Cloning to create cost-effective development, testing, and staging environments without incurring additional storage costs.
- Collaborate with product managers to develop dynamic dashboards on Tableau, enabling tracking of key supply chain metrics and effectively identifying Key Risk Indicators (KRIs) and Key Performance Indicators (KPIs).
Requirements
- Bachelor's degree in Computer Science, Data Engineering, Information Systems, or a related field.
- Proven experience working with Snowflake Data Cloud and its key functionalities, including Snowpark, Snowpipe, and Time Travel.
- Proficiency in programming with Python for data processing and analytics.
- Advanced SQL skills, including working with window functions for complex calculations and analysis.
- Experience developing interactive dashboards with Tableau or similar visualization tools.
- Strong understanding of data engineering best practices, including data integrity, compliance, and real-time data ingestion techniques.
- Familiarity with cloud data architecture and concepts such as Zero Copy Cloning and scalable application development.
- Certification in Snowflake or related cloud data platforms (e.g., AWS, Azure, GCP) - preferred.
- Experience in supply chain analytics or supporting business systems in a large-scale environment - preferred.
- Strong collaboration skills and ability to work cross-functionally with product managers, analysts, and other engineering teams - preferred.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
SQLPythonSnowflakeSnowparkSnowpipeTime TravelTableaudata engineering best practicesdata processingreal-time data ingestion
Soft Skills
collaborationcross-functional teamwork
Certifications
Snowflake certificationAWS certificationAzure certificationGCP certification