Snowflake Developer

Job Title: Snowflake Developer

Location: New York, NY (Onsite)

Duties:

Main purpose of the role:

The successful candidate's primary role as part of the BI TEC team will be to support a new multi-million dollar infrastructure which spans multiple regions (NY, LON & Asia). The infrastructure uses a combination of technologies, primarily Snowflake and Python. MS SQL Server and Oracle database is a plus. The candidate will work closely with various development teams and Business managers to enhance the data warehouse and reporting elements of the platform. Strong core PL/SQL knowledge along with a solid understanding of data warehousing design principles is required. Control M knowledge for batch processing is strongly desired. The role would suit a candidate with experience of working within a regulatory reporting development. Previous experience working within Risk, Finance or Product Control areas is desirable although a strong track record of comparable experience on large scale data warehousing implementations is also acceptable.

Skills:

Required

• 6+ years of exp in Snowflake
• 6+ years of exp in Python
• Oracle or SQL Server development skills desired
• CI/CD using Github and Git Actions, Team City, SDA
• Data Warehousing Design Experience and Kimball Methodologies
• Understanding of Veracode scans
• Control M experience for scheduling batches
• Experience of working within a large database development project team
• Capital market data experience is preferred

Preference will be given to candidates with experience in the following:

• The ability to understand financial products and how they are reported on by Product Control and Finance dept within an investment bank
• Prior experience of supporting internal management reporting (Trading data) will also be considered as an advantage

Personal Requirements:

• Good communication skills, and the ability to simplify technical jargon into business speech
• Agile and flexible approach to delivery
• Excellent interpersonal skills to ensure clarity of communication to users and Technology colleagues
• Prioritise and structure own workload according to delivery requirements
• A fast learner with the ability to understand, retain and apply new information quickly
• Ability to stretch oneself based on the situation on the group to support reports production cycle
• Be comfortable with on-call/out of hours support and have a flexible approach to working hours
• Develop a strong working relationship with the Businesses, Finance, Technology, Audit, Independent risk across the organization