Did you know that M&T Bank made Forbes Magazine’s “400 Best Big Companies” list for the 10th time this year, that we’ve been in business for over 150 years and are one of the nation’s top 20 bank holding companies with close to $66 billion in assets? M&T Bank is a great place to be because we’re established, strong, and even in these turbulent financial times, we remain stable and profitable. We value work-life balance and carry out our mission of making M&T Bank the best place our employees have ever worked. Due to our consistent growth and prosperity, we are looking to fill a key Data Operations Analyst role within the Marketing/Communications division of M&T Bank. RESPONSIBILITIES: The Customer Insights Data Operations Analyst is responsible for supporting the Customer Insights DataMart team and system. This position provides an excellent opportunity to apply technical skills in data management, project management and solutions development. Based in the marketing and communications area, this role is very dynamic and touches every area of the bank.In this role, the analyst works with Marketing Technology, Customer Data Analysis, Campaign Management and Marketing Segments & Services teams to deliver on requests for various forms of standard and custom data sets. To deliver on these requests, the analyst uses various database tools and applications to extract, transform and load (ETL) data, as well as the programming of automated processes for transferring files to and from vendors and internal partners in support of marketing campaigns, non-marketing related communications and campaign measurement. Support of direct marketing campaigns includes the production of customer lists for delivery to direct mail houses, lead management tool , email, telephone banking, interactive voice response (IVR), and other one-to-one channels.This position reports to the Marketing Technologies/DataMart Manager. As a part of this team, the analyst works with an analytics / business intelligence database that is built weekly and monthly. The Data Operations Analyst participates in the support, maintenance and monitoring of the datamart environment. Duties include server monitoring, application administration, data staging, analysis and validation.Business analyst work is a part of this role as well, and includes the development of business requirements, functional and technical specifications to meet change management standards.BASIC QUALIFICATIONS: Bachelor’s degree or above in MIS, CIS or Business or have 4+ years experience in a related environmentAbility to translate business needs and criteria into an accurate and complex analytics and data management tool Experience and expertise in working with complex databases, query languages (SQL), file transfer and data manipulation Solid experience with Relational Database Management Systems, Application Development, Data Staging, ETL tools, and other data management toolsAdvanced level Access and Excel required (macro/pivot/VBA) Must have solid experience with parsing text strings, appending data files through matching and acting on pseudo code style instructions and process design flow charts Must have a strong attention to detail, be focused, and thrive in a fast paced, high pressure, and deadline driven environment Must have excellent written and verbal communication skills IDEAL QUALIFICATIONS: Advanced Data Structure experience using database queries to create exacting datasets, import/export data, validate datasets, analyze data for trends or abnormalities, and present data in easy to understand tables Experience developing system and process automation preferred Prior work experience within financial service firm data area, experience with marketing technologies, database administration, database programming, report design and development preferred
Apply to this job
Saturday, February 20, 2010