Impress employers and recruiters.
Choose from hundreds of resume examples.
Impress employers and recruiters.
Choose from hundreds of resume examples.
Target Resume Now
Tailor your resume to this Lead Data Engineer role.
Rezi rewrites your resume against M&T Bank's job description. Free.
Tailor your resume to this Lead Data Engineer role.
Rezi rewrites your resume against M&T Bank's job description. Free.
Don't guess if your resume is good enough.
See how it scores against the Lead Data Engineer posting at M&T Bank — free, in seconds.
Don't guess if your resume is good enough.
See how it scores against the Lead Data Engineer posting at M&T Bank — free, in seconds.
About the Role
Designs, develops, implements, and operates complex data pipelines, data products, and data management solutions on modern cloud platforms. Applies software engineering, data modeling, and distributed processing practices to deliver scalable, secure, and cost-efficient solutions. Resolves engineering problems, contributes to technical direction, and mentors other engineers while collaborating across teams.
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, selecting appropriate warehouse, lakehouse, or hybrid patterns.
- Design analytical storage solutions using relational databases, cloud object storage, columnar formats, and open table formats like Apache Iceberg.
- Implement batch, micro-batch, change data capture (CDC), event-driven, and streaming patterns using technologies like Apache Kafka.
- Integrate data from various sources including relational and mainframe systems, APIs, event streams, SaaS platforms, files, and object storage with security and operational controls.
- Apply normalized, dimensional, denormalized, and data-product-oriented modeling approaches based on requirements.
- Optimize Snowflake, Databricks/Spark, and SQL workloads for performance, scalability, reliability, and cost.
- 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 root-cause analysis for production incidents.
- Apply source control, peer review, automated testing, CI/CD, environment promotion, and infrastructure/configuration automation.
- Create reusable libraries, templates, implementation patterns, and reference solutions.
- Evaluate design alternatives and document tradeoffs involving security, privacy, resiliency, maintainability, performance, cost, and operational complexity.
- Contribute to technical standards, identify technical debt, and recommend modernization or remediation approaches.
- Mentor engineers through design reviews, code reviews, pairing, and technical problem-solving.
- Partner with product owners, architects, governance, cybersecurity, platform, and consuming teams to translate requirements into solutions.
- Develop technical epics and stories, estimate work, surface dependencies and risks, and support iterative delivery through Agile practices.
- Provide technical leadership and mentorship without direct people-management responsibility.
- Understand and adhere to the Company’s risk and regulatory standards, policies, and controls.
- Design, implement, maintain, and enhance internal controls to mitigate risk.
- Maintain internal control standards, including timely implementation of audit points and issues raised by regulators.
- Promote an environment that supports belonging and reflects the Company brand.
- Complete other related duties as assigned.
Requirements
- 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 years’ education and/or relevant work experience, including a minimum of 5 years’ system analysis and/or application development work experience.
- Expert proficiency in a minimum of 1 relevant programming language and professional proficiency in a minimum of 1 additional relevant programming language.
- Advanced SQL skills, including complex transformations, analytical queries, and workload optimization.
- Experience with Python or another general-purpose programming language used for production data engineering.
- Hands-on engineering experience with Snowflake and/or Databricks.
- Experience with modern ELT/ETL and transformation practices, including dbt or a comparable framework.
- Experience with data modeling for warehouse, lakehouse, and data-product use cases.
- Experience with distributed data processing using Apache Spark/PySpark or a comparable framework.
- Experience with Git-based development, automated testing, code review, and CI/CD.
- Experience with batch and streaming architectures, orchestration, and production operations.
- Knowledge of cloud computing and object-storage concepts, preferably in Microsoft Azure.
- Experience working with structured and semi-structured data using formats such as Parquet, JSON, Avro, CSV, and XML.
- Demonstrated ability to independently design and deliver complex data solutions spanning ingestion, processing, persistence, quality, and consumption.
- Demonstrated ability to troubleshoot complex distributed-processing, data-quality, and production reliability issues.
- Demonstrated ability to balance performance, cost, scalability, resiliency, security, and maintainability in technical decisions.
- Demonstrated ability to review and improve technical designs and code developed by other engineers.
- Demonstrated ability to communicate complex designs and tradeoffs to engineering, architecture, product, and business audiences.
Skills
- Python
- SQL
- Snowflake
- Databricks
- dbt
- Apache Spark
- PySpark
- Git
- CI/CD
- Apache Kafka
- Microsoft Azure
- Parquet
- JSON
- Avro
- CSV
- XML
- Apache Iceberg
- Apache Airflow
- Azure Data Factory
- Databricks Workflows
- Terraform
Location
- Buffalo, New York, United States of America
Work Type
- Onsite
Experience Level
- Minimum of 7 years' systems analysis and/or application development work experience (Associate's degree)
- Minimum of 5 years' systems analysis and/or application development work experience (Bachelor's degree)
- Combined minimum of 9 years' education and/or relevant work experience, including a minimum of 5 years’ system analysis and/or application development work experience (No degree)
Education Level
- Associate's degree
- Bachelor's degree
- Master's degree in Computer Science, Engineering, Data Engineering, Information Systems, or a related technical field (Preferred)
Salary/Compensations
- $116,400.00 - $194,000.00 Annual (USD)
About the Company
- M&T Bank is committed to fair, competitive, and market-informed pay for our employees.