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.