Technical Engineer IV
M&T Bank · Buffalo, New York, US
Title: Technical Engineer IV Job Location: 1 Seneca Street, Buffalo, NY 14203. Position requires in-office work four (4) days every week.
Job description
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 tec...