Snowflake Database Team Lead

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 scratchThis 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 packageIn 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 ELTETL 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, ERStudio, 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 SklarskiSenior Technical RecruiterPRI TechnologyP: 973.732.5454 x27C: 973.432.9968F:

Created: 2024-10-19