Data Analytics - Snowflake Technical Engineer, AVP

SSB&T

Where
Quincy, Massachusetts
Pay
$90K to $158K a year

Posted 50 days ago· Checked live at SSB&T 3 days ago

Stale: open 50 daysUp for more than two weeks. It may already be filled.

See how you score for this job

One sentence and your resume. We score it against what SSB&T asks for, line by line.

See my score
Is this job still open?
Yes. We checked it live on SSB&T's own hiring page 3 days ago.
What is the job?
Who we are looking for Why this role is important to us We are looking for a Data Analytics - Snowflake Technical Engineer, AVP to join our Data Platform Engineering team, whose mission is to engineer and deliver self-service, performant and resilient data services platform to enable world class product development.
What does it pay?
$90K to $158K a year, as the posting states.
Our verdict
Stale. Up for more than two weeks. It may already be filled.

What the job is

Who we are looking for Why this role is important to us

We are looking for a Data Analytics - Snowflake Technical Engineer, AVP to join our Data Platform Engineering team, whose mission is to engineer and deliver self-service, performant and resilient data services platform to enable world class product development.

Why this role is important to us

Education and preferred qualifications

  • 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

Salary Range

$90,000 - $157,500 Annual

The range quoted above applies to the role in the primary location specified. If the candidate would ultimately work outside of the primary location above, the applicable range could differ.

Employees are eligible to participate in State Street’s comprehensive benefits program, which includes: our retirement savings plan (401K) with company match; insurance coverage including basic life, medical, dental, vision, long-term disability, and other optional additional coverages; paid-time off including vacation, sick leave, short term disability, and family care responsibilities; access to our Employee Assistance Program; incentive compensation including eligibility for annual performance-based awards (excluding certain sales roles subject to sales incentive plans); and, eligibility for certain tax advantaged savings plans.

For a full overview, visit https://hrportal.ehr.com/statestreet/Home.