Cayuse Holdings

Data Engineer – Snowflake

Cayuse Holdings

contract

Posted on:

Location Type: Hybrid

Location: PhoenixArizonaUnited States

Visit company website

Explore more

AI Apply
Apply

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