Data Engineer (Snowflake) - Hybrid

Job Description

Job Description

Overview

JOB TITLE : Data Engineer (Snowflake)

LOCATION : Phoenix, AZ (Hybrid)

EMPLOYEE TYPE : Contractor (1099 / C2C)

PAY RATE : $70-75 per hour

Cayuse Commercial Services (CCS) delivers fresh solutions to business challenges in the technology and business services environment. Services available are application development, business process outsourcing, data services, and professional services. Cayuse helps clients to achieve impactful outcomes such as improved efficiency, reduced cost, increased profitability and accelerated time to market.

Responsibilities

We are seeking a highly skilled Snowflake Data Engineer to join our data engineering team. The ideal candidate will have a deep understanding of Snowflake’s data platform and strong expertise in SQL, Python, and data reporting tools such as Tableau. The Snowflake Data Engineer will be responsible for designing, implementing, and optimizing data pipelines, as well as developing analytics capabilities to support business intelligence and decision-making across the organization. This position requires a collaborative, detail-oriented professional with experience in real-time data ingestion, advanced analytics, and managing complex data environments.

Key Responsibilities :

• Data Analysis and Reporting : 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.
• Automated Insights : Prepare and automate detailed real-time reports using Python and SQL, providing actionable insights to stakeholders and enhancing the company’s decision-making processes.
• Pipeline Development : Develop and optimize data pipelines using Snowpipe and SnowSQL for real-time and batch data ingestion, achieving improved data processing efficiency by 20%.
• Data Applications Development : Implement Snowpark to build scalable and high-performance data applications using Python, enhancing data manipulation, analysis, and processing capabilities.
• Data Recovery and Auditing : Leverage Snowflake’s Time Travel features to enable auditing, data recovery, and version control, ensuring data integrity and regulatory compliance.
• Environment Management : Manage Snowflake's Zero Copy Cloning to create cost-effective development, testing, and staging environments without incurring additional storage costs.
• Data Visualization : 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).

Qualifications

Required Qualifications :

Preferred Qualifications :

Cayuse is an Equal Opportunity Employer. All employment decisions are based on merit, qualifications, skills, and abilities. All qualified applicants will receive consideration for employment in accordance with any applicable federal, state, or local law.