Private Client Group Associate

Bankwell; New Canaan (CT); On-site; USD 85,000 - 110,000; Full time

Job summary

Bankwell in Connecticut seeks a strategic Business Analyst for the Private Client Group to partner with the Head of Private Client Group, delivering analytics, BI reporting, and portfolio analysis in a fast-paced banking environment.

You will build dashboards, support forecasting and budgeting, and leverage AI tools to automate reporting, enhancing decision-making while coordinating executive communications and scheduling.

Qualifications

• Bachelor’s degree in Finance, Economics, Accounting, Business Analytics, Data Science, or a related field.
• 2–5 years of experience in commercial banking, financial services, business analytics, or a related support role.
• Advanced Microsoft Excel skills, including pivot tables, Power Query, lookup functions, dashboard development, and financial modeling.
• Proficiency with Power BI, Tableau, or similar business intelligence platforms.
• Demonstrated proficiency with AI and automation tools (e.g., Microsoft Copilot, ChatGPT, or similar), including practical experience applying AI to analytics, reporting, or administrative workflows.
• Strong PowerPoint and presentation development skills.
• Experience Working With CRM Systems And Lending Platforms Preferred.
• Exceptional organizational and project management skills.

Responsibilities

• Develop and maintain commercial lending and deposit dashboards, scorecards and KPI reporting, determine dashboard methodology, data sources, and KPI definitions.
• Analyze loan production, pipeline activity, deposits, portfolio concentrations, credit quality metrics, and profitability trends, exercising judgment in identifying which trends warrant escalation to leadership.
• Prepare executive-level presentations, reports, and management summaries for senior leadership and Board reporting purposes.
• Prepare draft term sheets, including facility descriptions, pricing, covenants, and related structuring language, applying professional judgment to recommend structuring approaches for review by the Head of Private Client Group and Credit.
• Identify trends, opportunities, and risks within the portfolio through data analysis, and recommend a course of action based on that analysis.
• Support forecasting, budgeting, and strategic planning initiatives — including developing underlying assumptions and modeling approaches.
• Create automated reporting solutions to reduce manual processes and improve efficiency, with discretion over tool selection and design.
• Own CRM, pipeline management, and business development reporting.
• Monitor lender productivity, portfolio growth, and client activity metrics.
• Perform ad hoc analysis to support lending decisions, strategic initiatives, and special projects.

Skills

Advanced Excel

Power BI

Tableau

AI tooling

CRM systems

Lending platforms

Education

Bachelor’s degree in Finance, Economics, Accounting, Business Analytics, Data Science, or related field

Tools

Power BI

Tableau

Excel

CRM systems

Lending platforms

Job description

About Bankwell:

Bankwell is a commercial bank with more than $3 billion in assets that serves the banking needs of businesses and individuals. At Bankwell, we pride ourselves on our unique ability to bring you high touch, high quality banking with the expertise and dedication of our experienced team of professionals. When it comes to business, our deep industry knowledge, flexibility and innovative treasury and financing services enable us to find the right solutions for our business and commercial clients. We’re passionate about giving back and are actively involved with many not-for-profit organizations that help shape and improve the lives of others. We’re dedicated to giving our time and talent to support the communities we serve. More about Bankwell can be found at www.mybankwell.com.

Description

About Bankwell: Bankwell is a commercial bank with more than $3 billion in assets that serves the banking needs of businesses and individuals. At Bankwell, we pride ourselves on our unique ability to bring you high touch, high quality banking with the expertise and dedication of our experienced team of professionals. When it comes to business, our deep industry knowledge, flexibility and innovative treasury and financing services enable us to find the right solutions for our business and commercial clients. We’re passionate about giving back and are actively involved with many not-for-profit organizations that help shape and improve the lives of others. We’re dedicated to giving our time and talent to support the communities we serve. More about Bankwell can be found at www.mybankwell.com.

Summary Of Position

The Business Analyst, Private Client Group serves as a strategic partner to the Head of Private Client Group, exercising independent analytical judgment to provide analytical support, business intelligence, portfolio reporting, project coordination, and day-to-day business support. This role is designed for an individual who is highly analytical, detail-oriented, technologically proficient, fluent in the practical application of AI tools, and capable of managing multiple priorities in a fast-paced commercial banking environment.

The primary duty of this position is the exercise of discretion and judgment on matters of significance related to the general business operations of the Private Client Group — including data analytics, business intelligence, portfolio and credit-related analysis, and business planning. Approximately 60–65% of this role's time is dedicated to these analytical and business-intelligence functions. The remaining time is spent on business coordination and executive-support functions (meeting management, communication workflows, and calendar/travel coordination), which are secondary to and performed in direct support of the analytical work above, while leveraging AI to drive efficiency across each of these functions.

Responsibilities Include

Data Analytics & Business Intelligence

• Develop and maintain commercial lending and deposit dashboards, scorecards and KPI reporting, determine dashboard methodology, data sources, and KPI definitions.
• Analyze loan production, pipeline activity, deposits, portfolio concentrations, credit quality metrics, and profitability trends, exercising judgment in identifying which trends warrant escalation to leadership.
• Prepare executive-level presentations, reports, and management summaries for senior leadership and Board reporting purposes.
• Prepare draft term sheets, including facility descriptions, pricing, covenants, and related structuring language, applying professional judgment to recommend structuring approaches for review by the Head of Private Client Group and Credit.
• Identify trends, opportunities, and risks within the portfolio through data analysis, and recommend a course of action based on that analysis.
• Support forecasting, budgeting, and strategic planning initiatives — including developing underlying assumptions and modeling approaches.
• Create automated reporting solutions to reduce manual processes and improve efficiency, with discretion over tool selection and design.
• Own CRM, pipeline management, and business development reporting.
• Monitor lender productivity, portfolio growth, and client activity metrics.
• Perform ad hoc analysis to support lending decisions, strategic initiatives, and special projects.

AI & Automation

• Leverage AI and generative tools (e.g., Microsoft Copilot) to enhance data analysis, reporting, forecasting, and portfolio monitoring, and to draft communications, term sheets, and briefing materials.
• Identify, implement, and champion AI-driven automation opportunities that reduce manual processes across lending operations, reporting, and business support, ensuring alignment with data governance, privacy, and regulatory requirements.

Business Coordination & Executive Support (Secondary Function)

• Coordinate the Head of Private Client Group's calendar, scheduling, travel arrangements, and meeting logistics, exercising discretion in prioritizing competing demands on the Head's time.
• Prioritize and manage incoming communications, including email organization, draft responses, and follow-up tracking, using thoughtful judgment to triage and route matters requiring the Head's attention.
• Organize internal and external meetings, including preparation of agendas, materials, and action-item follow-up.
• Maintain task lists, project timelines, and key deliverable tracking.
• Prepare meeting summaries and briefing documents.
• Serve as a liaison between commercial lending leadership, credit administration, operations, treasury management, and executive management.
• Assist in the preparation of presentations and communication materials.

Private Client Group Administration

• Maintain pipeline and portfolio tracking systems.
• Collaborate on loan committee preparation by gathering, organizing, and validating information, and by flagging data anomalies requiring follow-up.
• Coordinate special projects involving process improvements and technology implementations.
• Support vendor and third-party management activities related to lending systems and reporting platforms.
• Maintain centralized reporting repositories and departmental documentation.
• Assist with examination, audit, and regulatory reporting requests as needed.

Requirements

Qualifications & Skills:

• Bachelor’s degree in Finance, Economics, Accounting, Business Analytics, Data Science, or a related field.
• 2–5 years of experience in commercial banking, financial services, business analytics, or a related support role.
• Advanced Microsoft Excel skills, including pivot tables, Power Query, lookup functions, dashboard development, and financial modeling.
• Proficiency with Power BI, Tableau, or similar business intelligence platforms.
• Demonstrated proficiency with AI and automation tools (e.g., Microsoft Copilot, ChatGPT, or similar), including practical experience applying AI to analytics, reporting, or administrative workflows.
• Strong PowerPoint and presentation development skills.
• Experience Working With CRM Systems And Lending Platforms Preferred.
• Familiarity with commercial lending, credit analysis, term sheet preparation, and banking operations is strongly preferred.
• Exceptional organizational and project management skills.
• Strong verbal and written communication skills.
• Ability to manage confidential information with discretion and professionalism.

Key Competencies

• Analytical thinking
• AI fluency and automation mindset
• Executive presence
• Attention to detail
• Process improvement mindset
• Technology proficiency
• Time management
• Relationship management
• Problem solving
• Initiative and accountability
• Professional communication

FLSA Status: Exempt

This job description is a general description of essential job functions. It is not intended as an employment contract, nor is it intended to describe all duties someone in this position may perform. All employees are expected to perform tasks assigned by supervisory personnel, regardless of job titles or routine job duties.

Bankwell is committed to a policy of Equal Employment Opportunity and will not discriminate against any applicant or employee on the basis of race, color, religion, sex, sexual orientation, national origin or ancestry, age, physical or mental disability, veteran or military status, marital status, or any other legally recognized protected basis under federal, state or local laws.

Applicants with disabilities may be entitled to reasonable accommodation under the terms of Americans with Disabilities Act and certain other state or local laws. Please inform Bankwell’s Human Resources representative if you need assistance completing any forms or to otherwise participate in the application process.

All employees are responsible for complying with banking regulations that apply to Bankwell. This includes, but is not limited to, adhering to the BSA and various consumer protection regulations, and complying with OFAC sanctions. Employees are required to complete compliance training and follow policies and procedures for applicable regulations based on their role. An employee’s failure to comply with banking regulations will be individually reviewed and assessed. The result of non-compliance may impact job performance ratings and may be serious enough to require termination of employment.