M&T Bank

Snowflake Data Engineer


PayCompetitive
LocationWilmington/Delaware
Employment typeFull-Time

This job is now closed

  • Job Description

      Req#: R65501

      The Bank sponsors individuals for TN and H-1B transfers on a case by case basis. Please note that this position is not open to anyone on an F-1 student visa including those eligible for CPT/OPT or the Stem OPT extension.

      This role follows a hybrid work schedule; offering the flexibility to work remotely two days a week, while providing the opportunity for onsite and in person collaboration the other three days.

      Overview:

      We are seeking a talented Snowflake Data Engineer to join our dynamic team and play a key role in building new data products within our enterprise data warehouse.

      Primary Responsibilities:

      • Build Data Pipelines to ingest and transform data in Snowflake in public cloud like Azure/AWS/GCP
      • Develop and maintain ELT/ETL processes to move data from various sources to the enterprise data warehouse.
      • Collaborate with team members to ensure efficient and accurate data migration.
      • Utilize internal Python frameworks to support ETL processes.
      • Manage data scheduling using CA Automic.
      • Operate and maintain ETL processes on Linux servers.
      • DevOps experience on setting up CI/CD pipelines for project in GIT, Experience with Artifactory like JFrogg
      • Monitor, diagnose and address any issues or failures with jobs in production.

      Tech Stack:

      • SQL
      • Snowflake
      • Python
      • Azure Cloud
      • Bash/shell scripting
      • Automic

      Education and Experience Required:

      Minimum of an Associate’s degree and 5 years’ systems analysis/application development experience, or in lieu of a degree, a combined minimum of 7 years’ higher education and/or work experience, including a minimum of 5 years’ systems analysis/application development experience

      Hands on experience with Snowflake

      Experience with Azure/AWS/GCP

      Proven experience in ETL development and data migration

      Proficiency in Python with experience in using internal frameworks

      Strong SQL skills with the ability to write complex queries

      Familiarity with data warehousing concepts and technologies

      Education and Experience Preferred:

      Experience with scheduling tool like CA Automic/Control-M or similar

      Experience with bash or shell scripting

      We support our team members with generous benefits.

      • Competitive compensation
      • Health, welfare, and retirement benefits
      • 401(k) match at 5%
      • Work-life balance and flexible work arrangements
      • Banking Officers start with 25 days PTO plus 12 paid holidays
      • 40 hours paid volunteer hours per year
      • Much more. For details, see: Employee Benefits | M&T Bank (mtb.com)

      M&T Bank is committed to fair, competitive, and market-informed pay for our employees. The pay range for this position is $102,939.06 - $171,565.10 Annual (USD). The successful candidate’s particular combination of knowledge, skills, and experience will inform their specific compensation.

      Location

      Wilmington, Delaware, United States of America
  • About the company

      M&T Bank Corporation is an American bank holding company headquartered in Buffalo, New York.