Hiring.Camp

Lead Solution Engineer – Snowflake, Azure

Mtb

·

Today

Salary
$128k – $214k/yr
Location
Wilmington, DE, United States of America
Workplace
Hybrid
Type
Full-time
Department
Engineering
Seniority
Lead
Experience
7+ years
Education
Bachelor
Visa
Sponsored
Source
Workday

Description

This role is four days onsite, with the flexibility to work from home one day per week M&T Work Model - 4 Days In-Office | 1 Day Work From Home 

 

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. 

 

Overview:

Designs, develops, implements and operates highly complex data pipelines, data products and data management solutions across modern cloud, warehouse and lakehouse platforms. Applies strong software-engineering, data-modeling and distributed-processing practices to deliver solutions that are scalable, secure, resilient, observable and cost efficient. Independently resolves ambiguous engineering problems, contributes to technical direction and reusable standards, and mentors other engineers while partnering across product, architecture, governance, cybersecurity and platform teams.


Tech Stack

  • Snowflake
  • Databricks
  • Apache Spark / PySpark
  • Advanced SQL
  • Python
  • dbt or comparable ELT/transformation framework
  • Git / CI/CD
  • Cloud computing, preferably Microsoft Azure
  • ETL/ELT and data pipelines
  • Batch + streaming architectures
  • Automic or another scheduling tool

Primary Responsibilities:

  • Lead the detailed engineering design, development, testing, deployment and production support of complex data pipelines and reusable data products.
  • Develop maintainable data-processing and transformation solutions using advanced SQL and programming languages such as Python.
  • Engineer solutions using Snowflake, Databricks, dbt and comparable modern data platforms; select appropriate warehouse, lakehouse or hybrid patterns based on workload needs.
  • Design analytical storage solutions using relational databases, cloud object storage, columnar formats and open table formats such as Apache Iceberg.
  • Implement batch, micro-batch, change data capture (CDC), event-driven and streaming patterns using technologies such as Apache Kafka or comparable platforms.
  • Integrate data from relational and mainframe systems, APIs, event streams, SaaS platforms, files and object storage with appropriate security and operational controls.
  • Apply normalized, dimensional, denormalized and data-product-oriented modeling approaches based on access, performance and lifecycle requirements.
  • Optimize Snowflake, Databricks/Spark and SQL workloads for performance, scalability, reliability and cost, including partitioning, parallelism, data movement and compute utilization.
  • Build data quality, reconciliation, metadata, lineage, observability, alerting and service-level controls into production solutions.
  • Design for restartability, idempotency, retry, replay, recovery and failure isolation; lead diagnosis and root-cause analysis for complex production incidents.
  • Apply source control, peer review, automated testing, CI/CD, environment promotion and infrastructure/configuration automation to data engineering delivery.
  • Create reusable libraries, templates, implementation patterns and reference solutions that improve consistency and engineering velocity.
  • Evaluate design alternatives and clearly document tradeoffs involving security, privacy, resiliency, maintainability, performance, cost and operational complexity.
  • Contribute to technical standards, identify technical debt and recommend pragmatic modernization or remediation approaches.
  • Mentor engineers through design reviews, code reviews, pairing and technical problem solving; influence engineering practices across the team and adjacent teams
  • Partner with product owners, architects, governance, cybersecurity, platform and consuming teams to translate business and data requirements into scalable solutions.
  • Develop technical epics and stories, estimate complex work, surface dependencies and risks, and support iterative delivery through Agile practices.

Scope of Responsibilities:  


Supervisory/Managerial Responsibilities:

No supervisory responsibilities.


Education and Experience Required:

  • Associate’s degree and a minimum of 7 years’ systems analysis and/or application development work experience or Bachelor's degree and a minimum of 5 years' systems analysis and/or application development work experience. In lieu of a degree, a combined minimum of 9 year’s education and/or relevant work experience, including a minimum of 5 years’ system analysis and/or application development work experience.
  • Advanced SQL, including complex transformations, analytical queries and workload optimization.
  • Python or another general-purpose programming language used for production data engineering.
  • Hands-on engineering experience with Snowflake and Databricks.·   Modern ELT/ETL and transformation practices, including dbt or a comparable framework.
  • Data modeling for warehouse, lakehouse and data-product use cases.
  • Distributed data processing using Apache Spark/PySpark or a comparable framework.
  • Git-based development, automated testing, code review and CI/CD.·   Batch and streaming architectures, orchestration and production operations.
  • Cloud computing and object-storage concepts, preferably in Microsoft Azure.
  • Structured and semi-structured data using formats such as Parquet, JSON, Avro, CSV and XML.
  • Hands-on experience in Automic or other scheduling tool
  • Experience with Apache Kafka, CDC and event-driven architectures.

Education and Experience Preferred:

  • Advanced production experience with Snowflake, Databricks, Apache Spark/PySpark and dbt.
  • Experience implementing Apache Iceberg or another open table format, including schema evolution, partitioning, snapshots and table maintenance.
  • Experience with orchestration technologies such as Apache Airflow, Azure Data Factory, Databricks Workflows or dbt orchestration.
  • Experience with Infrastructure as Code and configuration automation, including Terraform or comparable tooling.
  • Experience with data catalogs, metadata management, lineage, data observability and automated data-quality frameworks.
  • Experience building governed enterprise data products or domain-oriented data solutions.
  • Experience working in a highly regulated environment such as financial services.

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: M&T Benefits Overview 

 

M&T Bank is committed to fair, competitive, and market-informed pay for our employees. The pay range for this position is $128,100.00 - $213,500.00 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

Skills

PythonAzureTerraformCI/CDSQLSparkAirflowSnowflakeDatabricksData EngineeringETLGitCybersecurityAgiledbtApache Kafka

Similar Jobs

30

Lead - Solution Engineer

Freshworks CRM·Boston, Massachusetts·Hybrid

2d ago

Lead - Solution Engineer

Freshworks CRM·Guarulhos, São Paulo·Remote

2d ago

Lead - Solution Engineer

Freshworks CRM·Berlin, State of Berlin·Onsite

1w ago

Lead - Solution Engineer

Freshworks CRM·Berlin, State of Berlin·Remote

1w ago

Lead - Solution Engineer

Freshworks CRM·Chennai, Tamil Nadu·Onsite

1w ago

Lead - Solution Engineer

Freshworks CRM·Bengaluru, Karnataka·Onsite

1w ago

Lead Solution Engineer

Salesforce·Mexico City, Mexico·Onsite

1mo ago

Lead Solution Engineer

SURVEYSPARROW PRIVATE LIMITED·Chennai, Tamil Nadu

2mo ago

Solution Engineer Lead

Gh R·Charlotte, North Carolina·Onsite

2mo ago

Lead - Solution Engineer

Freshworks CRM·Bengaluru, Karnataka

2mo ago

Lead - Solution Engineer

Freshworks CRM·Chennai, Tamil Nadu

2mo ago

Lead - Solution Engineer

Freshworks CRM·Bengaluru, Karnataka

2mo ago

Lead - Solution Engineer

Freshworks CRM·Chennai, Tamil Nadu

2mo ago

Lead - Solution Engineer

Freshworks CRM·San Mateo, California·Hybrid

3mo ago

Lead - Solution Engineer

Freshworks CRM·Boston, Massachusetts·Hybrid

4mo ago

Lead - Solution Engineer

Freshworks CRM·San Mateo, California·Hybrid

4mo ago

Lead - Solution Engineer

Freshworks CRM·London, England

4mo ago

Lead - Solution Engineer

Freshworks CRM·Boston, Massachusetts·Hybrid

4mo ago

Lead Solution Engineer – Tableau, Healthcare & Life Sciences (Strategic Demo & Industry Innovation)

Salesforce·Illinois, US·Remote

1d ago

Lead Solution Engineer - Financial Services

Salesforce·Denver, Colorado +2·Remote

3d ago

Analytics Specialist SE (Commercial FINS & Canada) - Senior/Lead Solution Engineer

Salesforce·Canada·Remote

1w ago

Lead Solution Engineer Tableau

Salesforce·Chicago, Illinois +1·Remote

1w ago

Sr. (Lead) Solution Engineer I (II)

PJM employees work collaboratively to·Audubon, New Jersey·Remote, Hybrid

1w ago

Cyber Cloud Solution Engineer Lead/Staff

Aep·US·Remote

1w ago

Lead Solution Engineer (CBU/福岡)

Salesforce·Japan·Onsite

2w ago

Lead Solution Engineer- NonProfit

Salesforce·London, England·Onsite

4w ago

Lead Solution Engineer, ECS, Public Sector

Salesforce·Toronto, Ontario·Onsite, Remote

1mo ago

Lead Solution Engineer - Mulesoft

Salesforce·Quezon City, National Capital Region·Onsite

2mo ago

CPQ Lead Solution Engineer - Salesforce Conga CPQ/PROS

Thomson Reuters·Eagan, Minnesota +1·Hybrid

2mo ago

Lead Solution Engineer - Fusion, Oracle Health & Life Sciences

Oracle·UK

3mo ago