Data Engineer (Snowflake Focus)

Description

At Sequoia Connect, we are a Talent-First Technology Ecosystem that redefines how elite professionals interact with the global digital landscape. We move beyond traditional models to act as a catalyst for the top 1% of global talent, connecting human potential with complex industrial execution. By joining our inner circle, you are not simply taking a position; you are aligning with a strategic partner dedicated to updating your "Human OS" and accelerating your growth through world-class, high-impact projects.

We are currently partnering with a rapidly growing, automation-led powerhouse that serves 31 Fortune 500 companies across the financial, healthcare, and manufacturing sectors. With a global workforce of over 32,000 employees and a presence in 28 countries, our client is a titan of digital transformation. Their "Automate Everything, Cloudify Everything" strategy ensures you will be working at the absolute forefront of AI-driven automation and cloud solutions.

This is your chance to thrive in a "Customer Success, First and Always" environment that prizes continuous learning and radical ownership. You will collaborate within an international network of expertise across 39 delivery centers worldwide, gaining exposure to complex engineering challenges that redefine industrial standards. If you are a driven professional looking for a dynamic, forward-thinking workplace where your growth is the priority, this is where you belong.

We are currently searching for a Data Engineer (Snowflake Focus)

• Data Modeling & ELT: Design, develop, and optimize data models and ELT processes using Snowflake for efficient data processing and analytics.
• Pipeline Development: Design and implement end-to-end ELT pipelines for loading data from various sources into Snowflake using Fivetran.
• Data Transformation: Implement data transformation logic using SQL and dbt ensuring the integrity, accuracy, and consistency of data.
• Performance Optimization: Optimize data loads and transformations for scalability and performance using Snowflake’s micro-partitioning and clustering features.
• API Integrations: Integrate Snowflake with external APIs for seamless data extraction and transfer using Fivetran.
• DevOps Integration (GitHub): Manage source control, automate deployments, and deploy Snowflake scripts, dbt models, and ELT pipelines across different environments.
• App Creation: Create Streamlit apps for user enablement and maintenance tasks.
• Maintenance & Security: Ensure data quality, governance, and security. Troubleshoot issues related to the Snowflake data warehouse and maintain documentation.
• Stakeholder Collaboration: Collaborate with data architects and business stakeholders to understand data requirements.

Qualifications & Requirements

• Core Experience: Proven hands-on experience as a Snowflake Developer / Data Engineer in data warehousing solutions.
• Data Architecture: Strong understanding of Snowflake platform features, including micro-partitioning, file processing from AWS S3, and data quality practices.
• Technical Stack: Expertise in writing and optimizing SQL queries (including CTEs and JavaScript stored procedures within Snowflake). Solid experience working with dbt and Python for data engineering tasks and automation.
• Pipeline Management: Familiarity with designing and managing data pipelines and ELT processes.
• (Preferred)Hands-on experience with AWS services (Lambda, SQS, SNS) and DevOps tools (CloudFormation, Terraform).
• (Preferred)Experience with ETL tools like SnapLogic.
• (Preferred)Familiarity with legacy Microsoft SQL platforms and modernizing them to cloud-based solutions.
• Excellent communication and problem-solving skills to collaborate in cross-functional teams.

Desired

• Familiarity with cloud-native foundations or AI coding assistants.

Languages

• Advanced Oral English: For seamless collaboration with global teams.
• Advanced Spanish.

Work Arrangement

We value flexibility to support your lifestyle. This position is available as:

• Remote

If you meet these qualifications and are pursuing new challenges, start your application on our website to join an award-winning employer. Explore all our job openings | Sequoia Career’s Page: https://www.sequoia-connect.com/careers/

Requirements

• Proven experience with Snowflake, SQL, dbt, Fivetran, Python, and API integrations.
• Proficiency with GitHub for source control and automated deployments.
• Hands-on experience specializing in data modeling and ELT pipelines.