Senior Data Engineer, Snowflake

This is a fully remote position, open to applicants in United States.

📋 Description

• Design, develop, and maintain scalable data pipelines and transformation workflows within Snowflake.

• Construct and enhance ELT/ETL processes utilizing SQL, Python, Snowpark, dbt, and Snowflake-native features.

• Upgrade existing pipelines based on Python and stored procedures by employing set-based processing, incremental loading, and reusable engineering patterns.

• Apply Snowflake-native data-processing solutions that utilize Dynamic Tables, Streams, Tasks, and stored procedures.

• Enhance platform performance and cost-effectiveness through query tuning, appropriate warehouse sizing, clustering strategies, workload isolation, and auto-suspend and auto-resume policies.

• Create dependable orchestration, dependency management, monitoring, error handling, retry, and recovery mechanisms.

• Design and maintain dimensional, relational, and domain-oriented data models.

• Implement data-quality checks, observability, testing, lineage, and documentation standards.

• Integrate data from batch and real-time sources using tools such as Fivetran, Kafka, Airflow, or similar technologies.

• Contribute to CI/CD pipelines, infrastructure-as-code practices, and automated deployment processes.

• Collaborate closely with architects and client stakeholders to translate business and technical requirements into production-ready solutions.

• Engage in code reviews, technical design discussions, estimation, and Agile delivery activities.

⛳️ Requirements

• Over 7 years of experience in data engineering, including substantial hands-on experience with Snowflake.

• Advanced SQL proficiency, encompassing complex transformations, query optimization, and stored procedure development.

• Strong background in Python development for data processing, automation, and pipeline creation.

• Practical experience with Snowpark and Snowflake-native functionalities such as Dynamic Tables, Streams, and Tasks.

• Demonstrated experience in designing and supporting scalable ELT/ETL pipelines in production settings.

• In-depth understanding of Snowflake performance and cost optimization, including warehouse sizing, query profiling, clustering, and workload management.

• Experience with data modeling, incremental processing, pipeline orchestration, and dependency management.

• Familiarity with dbt or a similar data transformation framework.

• Knowledge of at least one major cloud platform: AWS, Azure, or GCP.

• Experience with Git, CI/CD, automated testing, and modern software delivery methodologies.

• Strong troubleshooting, analytical, and problem-solving abilities.

• Excellent written and verbal communication skills, with the capability to collaborate directly with both technical and business stakeholders.

🏝️ Benefits

• Comprehensive health insurance plans.

• Generous paid time off policy.

• Opportunities for professional development and growth.

• Flexible working hours and remote work options.