Snowflake Developer -Team Lead

Position Summary:

The Senior Data Engineer will play a Lead role to build the firm's high-performing cloud data platform to meet analytical and BI reporting needs. This role will work as a key member of a data management team to drive development, delivery, and continuous improvement of the enterprise data warehouse architecture in support of our cloud data strategy.

The role requires solid development experience in cloud data warehousing and modern data engineering technologies.

The successful candidate will have experience in building a scalable Snowflake data platform using best practices and data warehouse principles. This person must understand business requirements and work closely with stakeholders to convert business requirements into technical solutions.

This is a hands-on engineering role requiring extensive data engineering and advanced data analytical skills, as well as the ability to provide mentorship and guidance to junior resources.

Required Skills:

1. 3 years of hands-on experience in building large cloud data warehouses using Snowflake; including database architecture design, data transformations, stored procedures, account and security principles, performance management, etc.
2. Experience in data modeling tools (e.g. Erwin, ER/Studio, etc.) and data modeling methodologies such as data vault and dimensional data models.
3. 5 years of strong technical experience in building scalable data pipelines to integrate structured and unstructured data in both cloud and on-premise environments.
4. 8 years of overall experience in data warehousing, advanced database design, SQL, stored procedures, views, performance tuning and optimization, database indexing techniques, and database maintenance.
5. Understanding of data security and cloud security methodologies, and experience in configuration and management of data security to meet compliance and IT security requirements.
6. Experience using Airflow or similar tools for developing scheduling and monitoring batch-oriented workflows.
7. Working knowledge of Microsoft Power BI and Tableau.
8. Experience with SDLC processes, agile development, and source code repositories (e.g. Git or Bitbucket).
9. Experience in AWS services, related data and storage services is a plus.
10. Working knowledge of Salesforce or other CRM systems is a plus.
11. Understanding of micro services architecture and methodology is a plus.
12. Excellent communication, organization, and problem-solving skills.

Additional Information:

Hybrid role with requirement to be in New York office 3 days a we