> Markdown version of [/jobs/ext/4455951-data-analytics-snowflake-technical-engineer](https://www.wearedevelopers.com/jobs/ext/4455951-data-analytics-snowflake-technical-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Analytics - Snowflake Technical Engineer - **Company:** State Street - **Location:** Quincy, MA, United States - **Experience:** Expert - **Salary:** $90,000.0 - $157,500.0 - **Contract:** Permanent contract - **Skills:** Query Performance, Sql Data Warehouse, Amazon Web Services, Amazon S3, Data Analysis, Microsoft Azure, Cloud Computing, Code Review, Cyber Security, Databases, Continuous Delivery, Continuous Integration, Data Architecture, Extract Transform Load (ETL), Data Transformation, Data Migration, Data Security, Data Structures, Data Stores, Data Warehousing, Relational Databases, DevOps, Dimensional Modeling, High-Level Architecture, Integrated Development Environments, Python (Programming Language), Metadata, NoSQL, Platform as a Service (PAAS), Performance Tuning, Systems Development Life Cycle, Role-Based Access Control, Cloud Services, Ansible, Standard Sql, Software Deployment, Software Engineering, SQL Stored Procedures, SQL Databases, Data Streaming, Software Repository, Data Processing, Scripting, Data Storage Technologies, Snowflake, Git, Data Analytics, Star Schema, Build Process, Data Management, Azure Service Fabric, Terraform, Multiplatform, Data Pipelines, Databricks - **Published:** October 1, 2026 - **Apply:** https://www.careerbuilder.com/job-details/data-analytics-snowflake-technical-engineer-avp-quincy-ma--2eb995f3-a114-4d82-a7ed-79097f881d44 ## About the Role * Candidate must have experience working with Snowflake and 5+ years of experience in Data Analytics, & Integration projects. * Must have prior experience with end to end implementation of Snowflake cloud data warehouse - on AWS & Azure, optionally on GCP. * Skills & experience must include deep expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel, cost governance, and be able to provide guidance on how to use these features * Should be well versed in in Snowflake - data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts * Experience in development and management of CI/CD pipelines using GIT repositories and DevOps for Infrastructure-as-Code deployments (terraform, ansible, python, etc.) * Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, other bigdata migration techniques using scripting (python, etc.) or industry standards tools (golden gate etc.) * Experience in Data Migration from RDBMS to Snowflake cloud data warehouse * Deep understanding of relational and optionally some of the industry standard NoSQL data stores, methods and approaches (star and snowflake, dimensional modelling etc.) * Experience with data security and data access controls and design - be able to implement best practices based on organization policies & requirements, at the same time making it simple for users. * Experience with AWS and Azure PaaS, data storage and management technologies such as S3 and ADLS * Build processes supporting data transformation, data structures, metadata, dependency and workload management * Must be Proficient in reviewing complex SQL code to tune, troubleshoot & resolve performance challenges in the environment or applications. * Provide resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surface. Should be able to go wider across infrastructure, platform, & application domains to resolve issues. * Strong written communication skills. Is effective and persuasive in both written and oral communication. * Is able to lead devops/automation resources in delivering self-service capabilities * Strong critical thinking and problem solving skills. Ability to be open to discussion of potential options. * Demonstrates solid knowledge of the overall software development life cycle including development, testing and deployment of all application modules * Ability to work independently in a fast-paced development environment * Good to be Certified Snowflake cloud data warehouse Architect. * Understanding and working knowledge of Databricks, Access Control, Administrative Skills, Amazon Simple Storage Service (S3), Amazon Web Services (AWS), Analysis Skills, Automation, Best Practices, Business Growth, Cloud Computing, Code Reviews, Communication Skills, Compensation and Benefits, Continuous Deployment/Delivery, Continuous Integration, Copy Editing, Customer/Client Research, Data Analysis, Data Management, Data Migration, Data Modeling, Data Processing, Data Storage, Data Structures, Data Warehousing, Database Extract Transform and Load (ETL), DevOps, Dimensional Modeling, Documentation, Emerging Technology, Enterprise Protection, Environmental Issues, GCP (Good Clinical Practices), Genetics, Git, High Level Architecture (HLA), Identify Issues, Incentive Programs, Industry Standards, Information/Data Security (InfoSec), Leadership, Metadata, Microsoft Windows Azure, Military, Multiplatform/Cross-Platform, Needs Assessment, NoSQL, Onboarding, Options Market, People Management, Performance Tuning/Optimization, Persuasion Skills, Platform as a Service (PaaS), Presentation/Verbal Skills, Problem Solving Skills, Procedure Implementation, Product Development, Production Management, Profit & Loss, Project Estimates, Python Programming/Scripting Language, Regulatory Compliance, Relational Databases (RDBMS), Risk Management, SQL (Structured Query Language), Sales, Sales Pipeline, Scripting (Scripting Languages), Service Delivery, Snowflake Schema, Software Development, Software Development Lifecycle (SDLC), Star Schema, Stored Procedures, Tax Planning, Technical Writing, Technical/Engineering Design, Test Plan/Schedule, Use Cases, Warehousing, Writing Skills ## Description We are looking for an experienced Snowflake technical engineer who will be responsible for planning, designing, developing and maintaining the data architecture, data models and best practices standards for various Data Analytics & Integration projects in Snowflake. What you will be responsible for You will be responsible to incorporate new features and ensure all subject areas are modelled to integrate with existing structures. You will be expected to create & continuously enhance documentation of the deployments & best practices pertaining to implementation of data architectures, data flows and data models in the platform. You will work within a global team to develop and maintain automation that enable self-service & management capabilities of the platform as part of the operating model. This role requires a broad range of skills and the ability to step into different roles depending on the size and scope of the projects. What we value These skills will help you succeed in this role * The candidate must exhibit ability to successfully complete multiple, complex technical projects and create high-level design and architecture of the solution - includes design & deployment infrastructure diagrams. * Be a self-starter and take ownership of technical solutions from design and architecture perspective for projects, help navigate complex use-cases to provide guidance on fit-for-platform * Deliver using an Onshore/Offshore model in a matrix org structure * Gather end user requirements and writing technical documentation * Provide innovative solutions based on new technologies and latest product features. * Work closely with application development team to understand the business, capture requirements, identify pain areas, accordingly, propose an ideal solution to grow business. * Managing pipelines using Terraform scripts to deploy resources * Provide engineering analysis and support for creating Snowflake accounts and onboarding new projects - ensuring enterprise security/compliance standards are strictly enforced. * Provide Administrative support closely working with vendor for any environment issues. * Understand the needs of automation and put forth options for solutions. * Work with production management and cloud teams to analyze and provide solutions for database related automation and solution