Our client, a global Banking/Financial Services company based in New York City, is seeking a consultant specializing in Snowflake Development and Data Warehousing. This position is a hybrid 4 days onsite in Midtown Manhattan. PLEASE NOTE: All Candidates MUST BE ABLE TO WORK AS AEGISTECH'S W2 WITHOUT SPONSORSHIP. NO THIRD PARTIES! • SUMMARY: The Consultant’s role will be to support a new multi-million dollar infrastructure spanning multiple global regions (NY, London, Asia). • The client’s infrastructure uses a combination of technologies, primarily Snowflake and Python, MS SQL Server, and Oracle database is a plus. • You will work closely with various development teams and Business Managers to enhance the data warehouse and reporting elements of the platform. • This role would suit a candidate with experience 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 in large-scale data warehousing implementations is also acceptable. • 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 SKILLS YOU NEED TO GET THE ROLE: • Securities / Capital Market data experience is highly preferred. • 6 + years of experience in both Snowflake and Python. • CI/CD using GitHub and Git Actions, Team City, and SDA. • Data Warehousing design experience and Kimball Methodologies, working within a large database development project team. • Oracle or SQL Server development skills are desired. • An understanding of Veracode scans. • Control M experience for scheduling batches. • Solid communication skills and the ability to simplify technical terminology into business wording. • Ability to prioritize and structure workload for delivery requirements. • Ability to develop strong working relationships with the Business, Finance, Technology, Audit, and Independent Risk groups across the bank. • High level of comfort with on-call/out of hours support with a flexible approach to working hours. • Ability to support reports production cycles. Preference will be given to candidates with experience in the following : • Ability to understand financial products and how they are reported on by the Product Control and Finance departments at an Investment Bank. • Prior experience of supporting internal management reporting (Trading data ) will also be considered as an advantage.