Data Engineer (Snowflake)

Data Engineer (Snowflake) Overview

• As a Data Engineer specializing in Snowflake, you will architect and maintain scalable data solutions for analytics and reporting.
• Collaborate with stakeholders to transform raw data into actionable insights using advanced Snowflake capabilities.
• Contribute to the development of a robust cloud data platform, ensuring data quality and reliability.
• Engage in designing and implementing ELT pipelines for diverse data sources, enhancing operational efficiency.
• Leverage your expertise in SQL and Python to optimize data workflows and performance.
• Participate in cross-functional collaboration to integrate Snowflake with other systems and applications.
• Utilize your knowledge of data modeling methodologies to support financial analytics and reporting.
• Contribute to a dynamic and innovative environment, driving impactful data solutions.

Data Engineer (Snowflake) Key Responsibilities & Duties

• Design and maintain scalable ELT pipelines for diverse data sources, ensuring data integrity and accessibility.
• Develop dimensional and semantic models to support portfolio reporting and analytics.
• Implement automated data validation and reconciliation tests with detailed exception reporting.
• Collaborate with stakeholders to gather requirements and write technical specifications for data solutions.
• Act as a subject-matter expert on Snowflake capabilities, advising on patterns and cost implications.
• Support analysts by exposing well-documented, performant reporting layers for downstream applications.
• Integrate Snowflake with operational systems through collaboration with platform engineers.
• Participate in design reviews, providing technical feasibility and cost input on new initiatives.

Data Engineer (Snowflake) Job Requirements

• Bachelor’s degree in Computer Science, Engineering, Information Systems, or related field.
• Minimum 3 years of data engineering experience, with 2 years focused on Snowflake.
• Proficiency in advanced SQL, Python, and Snowflake features like Streams, Tasks, and secure data sharing.
• Experience with data modeling methodologies and orchestration tools such as Airflow or Prefect.
• Familiarity with cloud infrastructure (AWS or Azure) and infrastructure-as-code tools like Terraform.
• Strong analytical and problem-solving skills with attention to detail and data accuracy.
• Preferred SnowPro Core or Advanced certification and experience with BI tools.
• Ability to work in a hybrid environment, balancing onsite and remote collaboration.