Snowflake Engineer
What's the role?
Brooksource is working with our Fortune 500 financial services client to find an experienced Snowflake Engineer who is looking to help build out the future of data analytics for their organization. The individuals on this team will be placed within high visibility data product teams related to the businesses’ core functions and on a platform that is relied on heavily by the investment services teams.
What Skills & Experience are Critical for this Role?
· Hands-on experience in implementing efficient data engineering solutions to solve business problems
· Experience in designing/implementing data warehouse solutions and scalable ELT pipelines using Snowflake
· Experience implementing advanced Snowflake concepts like:
· RBAC controls
· Virtual warehouse sizing
· Query profiling/tuning
· Zero-copy cloning
· Time travel
· Dynamic tables
· Cloud: Experience in implementing enterprise-grade analytical solutions on cloud platforms (preferred AWS) with serverless patterns (Lambda, Step functions, SQS, SNS, API Gateway, S3)
· Experience building and managing DBT pipelines in production.
· Proficient in Advanced SQL and relational database management concepts
· Intermediate level experience in Python and related frameworks like Flask, FastAPI with pytest and/or unittest etc.
· Experience coding in a distributed development environment leveraging Git, CI/CD pipelines (Gitlab is a plus), test automation frameworks, etc.
· Experience delivering solutions following Agile Engineering practices
· Strong communication skills with ability to work with cross-functional teams and business partners
Nice-to-Have Experience:
· Experience with data orchestration tools such as Apache Airflow
· Experience implementing data controls to ensure compliance, quality, and privacy.
· Experience in implementing data observability processes to monitor the health of data pipelines in production
· Experience working in Finance, Asset Management domains
· Ability to visualize and document architectures and articulate design choices.
Certifications in AWS, Snowflake