Snowflake Database Team Lead

Job highlights
Identified by Google from the original job post
Qualifications
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 cloud 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
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
Experience in data modeling tools (e.g. Erwin, ER/Studio, etc.) and data modeling methodologies such as data vault and dimensional data models
Strong technical experience in building scalable data pipelines to integrate structured and unstructured data in both cloud and on-premise environments
Solid overall experience in data warehousing, advanced database design, SQL, stored procedures, views, performance tuning and optimization, database indexing techniques, and database maintenance
Understanding of data security and cloud security methodologies, and experience in configuration and management of data security to meet compliance and IT security requirements
Experience using Airflow or similar tools for developing scheduling and monitoring batch-oriented workflows
Working knowledge of Microsoft Power BI and Tableau
Experience with SDLC processes, agile development, and source code repositories (e.g
Git or Bitbucket)
Excellent communication, organization, and problem-solving skills
Significant experience data engineering and data warehouse engineering in cloud environment
Experience with Snowflake needed
Bachelor’s degree in computer science, data science, or related field
Responsibilities
In this role you will work with the Global Data Manager to build high-performing cloud data platforms to meet our 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
Translate business requirements into data model design and technical solutions
Mentor and guide the work of junior database developers and analysts
Develop high-performing, secure ELT/ETL processes to transform and integrate source data from internal and external systems to the cloud data warehouse
Maintain data warehouse and data pipeline processes, including troubleshooting issues, performance tuning, and implementing data quality improvements
Develop a framework for data validation rules and reports to ensure data quality and control
Automate standard code deployment and production release processes, adhering to change management processes
Create high-quality technical documentation, including data mapping, data processes, and operational support guides
Provide guidance on effective use of the data warehouse platform and facilitate BI reporting and data science model development
Troubleshoot process and data issues, investigate user questions, and identify solutions to resolve issues
Work in a fast-paced, dynamic environment and perform effectively in an agile development environment
Job description
I have a full time opportunity for a Snowflake Database Team Lead (VP) who is proficient in Snowflake development and building a data warehouse from the scratch

This role is 3 days onsite, 2 days remote with one of our leading financial firms in Midtown Manhattan.

This is a VP level opportunity with a very generous base salary and employee benefits package

In this role you will work with the Global Data Manager to build high-performing cloud data platforms to meet our 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 cloud 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.

Responsibilities:
• Translate business requirements into data model design and technical solutions.
• Mentor and guide the work of junior database developers and analysts.
• Develop high-performing, secure ELT/ETL processes to transform and integrate source data from internal and external systems to the cloud data warehouse.
• Maintain data warehouse and data pipeline processes, including troubleshooting issues, performance tuning, and implementing data quality improvements.
• Develop a framework for data validation rules and reports to ensure data quality and control.
• Automate standard code deployment and production release processes, adhering to change management processes.
• Create high-quality technical documentation, including data mapping, data processes, and operational support guides.
• Provide guidance on effective use of the data warehouse platform and facilitate BI reporting and data science model development.
• Troubleshoot process and data issues, investigate user questions, and identify solutions to resolve issues.
• Work in a fast-paced, dynamic environment and perform effectively in an agile development environment.

Qualifications:
• 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.
• Experience in data modeling tools (e.g. Erwin, ER/Studio, etc.) and data modeling methodologies such as data vault and dimensional data models.
• Strong technical experience in building scalable data pipelines to integrate structured and unstructured data in both cloud and on-premise environments.
• Solid overall experience in data warehousing, advanced database design, SQL, stored procedures, views, performance tuning and optimization, database indexing techniques, and database maintenance.
• Understanding of data security and cloud security methodologies, and experience in configuration and management of data security to meet compliance and IT security requirements.
• Experience using Airflow or similar tools for developing scheduling and monitoring batch-oriented workflows.
• Working knowledge of Microsoft Power BI and Tableau.
• Experience with SDLC processes, agile development, and source code repositories (e.g. Git or Bitbucket).
• Excellent communication, organization, and problem-solving skills.
• Significant experience data engineering and data warehouse engineering in cloud environment.
• Experience with Snowflake needed.
• Experience with agile development is a plus.
• Domain expertise with financial services is a plus.
• Bachelor’s degree in computer science, data science, or related field.

Lori Sklarski

Senior Technical Recruiter

PRI Technology

P: +73.732.5454 x27

C: +73.432.++68

F: +73.732.5456

Lori.sklarski@pritechnology.com

www.pritechnology.com