Snowflake Developer

Job DescriptionThe candidate will work closely with various development teams and Business managers to enhance the data warehouse and reporting elements of the platform. Must have worked on Snowflake and used Python to some extent. Good technical knowledge of the SQL Server stack with strong core PL/SQL along with a solid understanding of data warehousing design principles. SSIS skills are desired but not essential. The candidate would be on Production support and have to manage the control M batch and fix issues that might occur.

The role would suit a candidate with at least 5 years experience of working within the capital market domain.

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.

Responsibilities: Define solutions paying particular attention to ensuring technical requirements have been factored inWork with the overnight batch processes using scheduling software, Control-MWork with wider Technology teams to ensure development and testing is coordinated and best practices are followedHelp define test cases and work closely with users assisting them with testing bug fixes or new features and functionsCollaborate with end users and help with BAUDevelop efficient ELT routines using Snowflake.Need to understand Oracle PL/SQL to migrate to SnowflakeReport to the Technology team lead and keep management abreast of the status and progress of in-flight issuesEnsure due diligence has been carried out on all software changes, paying particular attention to detail on unit, component, and systems integration testingPackage up artifacts using industry-standard tools such as Subversion, SDA & TeamCityWork with BAU teams to ensure project changes are released to live in a coordinated mannerComply with the standard release cycle and deployment controlsUnderstanding of products related to Securities trading / Capital Markets.Support requirements and design of future reporting needs (regulatory and internal).Will be responsible for production support.Must adhere to all internal IT policies and controls while handling sensitive financial production data Skills & Experience: Solid Snowflake and Python SkillsSnowflake Technology experience, orPython experience with Snowflake CertificationSolid SQL Server Development skills with version 2019 or laterOracle Development skills with 11g or laterExperience of writing ETL Packages using SSIS is desired but not mandatoryData Warehousing Design Experience and Kimball MethodologiesExperience working within a large database development project teamHands-on Snowflake experience on live projects is a mustThe preferred candidate would have Snowflake Certification.Preferable experience with Java and Java Frameworks.Experience implementing and maintaining RESTful APIs.Preferable experience in designing data models and structures to store various kinds of data in different formats.Knowledge of Python, Kubernetes, AWS, Azure, or any cloud provider. Snowflake technology experience or Snowflake Certification is a MUST,or Python experience with Snowflake Certification.

Key Skills

• Python
• REST APIs