Data Engineer (Snowflake)

Job DetailExperience Level Mid LevelDegree Type Bachelor of Science (BS)Employment Full TimeWorking Type HybridJob Reference 0000021325Salary Type AnnuallyIndustry Financial ServicesSelling Points Shape the future of data engineering with cutting-edge Snowflake expertise. Collaborate on impactful projects in a dynamic hybrid work environment. Enjoy competitive benefits and professional growth opportunities.Job DescriptionData Engineer (Snowflake) OverviewAs 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 & DutiesDesign 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 RequirementsBachelor’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.