Technical Engineer IV

Title:

Technical Engineer IV Job Location:

1 Seneca Street, Buffalo, NY 14203. Position requires in-office work four (4) days every week.

Job Description:

Design, implement, and maintain enterprise-grade ETL workflows incorporating parameterization, error handling, logging, and automation for scalable and reliable data integration. Develop automation scripts and workflows in Python or any other language for data ingestion, transformations, API integrations, and automation. Design and implement logical and physical data models to support scalable, secure, and high-performing database solutions. Develop and optimize T-SQL code, including complex queries, views, stored procedures, and user-defined functions, with a focus on performance tuning, execution plans, indexing, and best practices. Develop and execute automated unit, integration, and UAT tests for Python-based ETL pipelines and SQL Server data models, implementing robust data validation frameworks to ensure data quality. Design and support Power BI data sets, reports and

Dashboards:

model design, DAX optimization, workspace management, refresh scheduling, and access controls. Elicit and translate business requirements into technical specifications; clarify data definitions, ownership, and operational constraints across cross‑functional teams. Coordinate with vendors and third‑party platforms on integrations, upgrades, incident resolution, and best practices; maintain effective communication channels. Lead small engineering efforts, provide technical guidance, conduct code/design reviews, and mentor junior engineers. Follow SDLC and IT Service Management processes ensure reliable releases, rollbacks, and post‑implementation reviews.

Minimum requirements:

Bachelor's degree (or foreign equivalent) in Computer Science, Computer Engineering, Computer Information Systems, Management Information Systems, or a related technical field plus five (5) years of experience in the job offered or as Technical Engineer, Software Engineer/Developer, Data/Business Intelligence Engineer, or related occupation. Requires five (5) years of experience with the following: Designing and maintaining enterprise-grade data pipelines; building automation scripts, ETL workflows, and API integrations; working with database design, optimization, and advanced T-SQL (queries, stored procedures, indexing, partitioning); Consuming

REST/SOAP

APIs with secure authentication, pagination, and error handling. Requires any amount of experience with the following: Developing complex dashboards and reports, writing advanced DAX queries, and managing workspaces for governance and performance; Working with strong cross-functional communication and requirements gathering with business and technology stakeholders; Working with cloud platforms such as Azure or AWS; Working with Git or similar tools for source code management; Writing test cases for data validation.

Salary:

$148,000 - $ 158,000 Location Buffalo, New York, United States of America Great companies have an enduring sense of purpose. At M&T, our purpose is a simple one: make a difference in people's lives and uplift the communities we serve. M&T Bank Corporation is a financial holding company headquartered in Buffalo, New York. M&T's affiliates offer advice, guidance, expertise and solutions across the entire financial spectrum, combining M&T Bank's traditional banking services with the wealth management and institutional capabilities offered by Wilmington Trust. M&T Bank has a network of over 1,000 branches and 2,200 ATMs that span 12 states from Maine to Virginia and Washington, D.C. For more than 165 years, M&T has strived to take an active role in our communities and build long-lasting relationships with our customers. We are a bank for communities—combining the capabilities of a large bank with the care of a locally focused institution. As an employer of choice, we are proud to offer competitive benefits ranging from medical and retirement to forty hours of paid volunteer time, each year. Our core values - integrity, ownership, collaboration, curiosity, and candor - drive the work we do. We seek to further build upon our record of success by bringing in top talent and fresh skill sets while continuing to support the growth and development of all our team members. View M&T's Human Capital Report to learn more. Ready to join our team? Submit your application today! If you are unable to apply through this site due to technical issues or need an accommodation to apply, please contact us at careersitesupport@mtb.com for assistance. M&T Bank is unwavering when it comes to providing equal employment opportunities to all employees and applicants without regard to race, color, national origin, religion, ethnicity, sex, gender identity, age, disability, citizenship, pregnancy, veteran status, military status, marital status, sexual orientation, genetic information or any other characteristic protected under applicable federal, state or local laws. M&T Bank Corporation has policies and procedures in place to promote a drug free workplace. Career Site Privacy Notice