Mortgage Credit Manager jobs in New Britain, CT

If you’re looking for a meaningful career, you’ll find it here at Webster. Founded in 1935, our focus has always been to put people first--doing whatever we can to help individuals, families, businesses and our colleagues achieve their financial goals. As a leading commercial bank, we remain passionate about serving our clients and supporting our communities. Integrity, Collaboration, Accountability, Agility, Respect, Excellence are Webster’s values, these set us apart as a bank and as an employer.  

Come join our team where you can expand your career potential, benefit from our robust development opportunities, and enjoy meaningful work!

The Manager, Credit Analytics will support the analytical and reporting needs of the Credit Risk organization. The key focus of the role is to support the design and development of Credit Risk’s next generation data infrastructure and reporting.

Day to day work includes developing framework and architecture of Credit data and reports to allow for high-quality, streamlined, and enhanced reporting capabilities. Work with IT and senior leadership to assess and meet data requirements to allow for meaningful real-time data to be readily available. Create and maintain Qlik Sense dashboards and other reporting solutions to proactively identify portfolio insights for the Chief Credit Officer and other Senior leaders. This role will also be responsible for identifying and implementing process improvements, including automation to increase the efficiency of the Credit Reporting and Analytics team.

Key Responsibilities:

• Support development and maintenance of Credit data repositories, including data modeling, creating views and writing complex SQL queries for data consumption.

• Partner with stakeholders to understand data and reporting requirements and serve as an executor on designing and building high-quality data solutions.

• Develop compelling, action-oriented and user-friendly dashboards, tools, and presentations, including ad-hoc reporting, for Executive Management and Quarterly Earnings materials.

• Use complex SQL and advanced Qlik Sense scripting to extract, transform, and simplify large data sets and deliver meaningful insights and metrics to business leaders to drive strategic decision making.

• Drive adoption and engagement of Qlik user base by providing training and ensuring tool and report functionalities are being maximized.

• Enhance legacy, Microsoft Excel based reporting and tools through VBA implementation and other automation tools.

• Advance department efficiency and effectiveness through supporting process automation project and data solutions.

• Improve and drive data quality strategy by ensuring best practices for data repositories and solutions used by LOBs and key partners, including Credit, Commercial, Consumer, and Finance. 

• Drive continuous improvement of Credit data repositories, tools, and processes to ensure completeness, accuracy, and timeliness of reporting.

• Become subject matter expert of enterprise data sources and platforms used by the Credit organization and partner departments, to enable data users and analysts to effectively utilize Credit data for reporting purposes.

Education, Experience and Skills:

• 4 years of relevant experience in Business Intelligence and/or Data Analytics (financial services background is a plus).

• Bachelor’s Degree in Computer Science, Data Science, Mathematics, Statistics or related field; Masters preferred.

• Experience building and maintaining reports using at least one of following data visualization platforms: Qlik, Tableau, Power BI, certifications a plus.

• Advanced hands-on experience with SQL and manipulating large data sets in a relational database, preferably using at least one of the following RDBMSs: Snowflake, Oracle, SQL Server, certifications a plus.

• Experience in database management, data warehousing and solid understanding of data modeling and database structures.

• Experience using VBA, Python, SAS or other programming languages to automate data retrieval, manipulation, and analysis.

• In-depth knowledge of ETL/ELT (Extract, Transform, Load) concepts and experience with tools such as Alteryx, Qlik Sense (scripting), or Tableau Prep.

• Experience with advanced Excel functionalities (ex. Macros, Index/Match, Named Ranges, Array Formulas, Power Query, Power Pivot, Data Modeler).

• Knowledge of Software Development Life Cycle (SDLC) and Agile concepts and practices a plus.

• Strong analytical and problem-solving skills, and experience multitasking and managing multiple projects and short timelines.

• Excellent oral and written communication skills, and comfort interacting with senior leaders.

The estimated salary range for this position is $110,000USD to $125,000USD. Actual salary may vary up or down depending on job-related factors which may include knowledge, skills, experience, and location. In addition, this position is eligible for incentive compensation.

#LI-EF1

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.