AVP, Business Intelligence & Data Analytics

Main Street Bank•Marlborough, MA

3d•$120,000 - $170,000•Hybrid

About The Position

The Assistant Vice President, Business Intelligence & Data Analytics is a hands-on individual contributor responsible for developing the Bank’s enterprise reporting, business intelligence, customer intelligence, and data analytics capabilities. The role turns data into reliable, accessible, and actionable insight to support strategic decision-making, operational performance, customer growth, project portfolio oversight, and organizational accountability. Working across business lines and support functions and in partnership with Technology teams, the position establishes consistent KPIs, executive dashboards, scorecards, and analytical reporting. After successful completion of training and demonstration of proven abilities, the position is eligible for a hybrid work arrangement. Availability is expected during core business hours, with an agreed number of days per week or month onsite. The role exercises substantial independent judgment, leads complex teams and processes with minimal oversight, and handles non-routine work. It influences cross-functional resource and project decisions and provides executive leadership and the Board with visibility into performance, risk, capacity, and strategic alignment. The role reports to the Chief Operating Officer and partners with Finance, Technology, Risk/Compliance, Retail, Commercial, Lending, Operations, Marketing, Human Resources, and other business and support functions. The position requires discretion when handling sensitive and confidential information and compliance with Bank policies, Bank Secrecy Act regulations, regulatory standards, and internal and operational risk controls. Regular and consistent attendance is required. Occasional local travel may be required, and schedules may include early mornings, evenings, or weekends to meet the Bank’s needs.

Requirements

Bachelor’s degree in business analytics, data analytics, finance, economics, statistics, information systems, or a related field, or equivalent technical training and work experience.
Five or more years of progressive experience in business intelligence, data analytics, financial analysis, enterprise reporting, or a related discipline.
Advanced experience developing dashboards, scorecards, and management reporting using Power BI or a comparable business intelligence platform.
Hands-on proficiency in SQL query development, Power BI, DAX, Power Query, data modeling, and advanced Excel, with the ability to independently develop reporting solutions from raw source data through final presentation.
Demonstrated ability to manage complex processes and influence cross-functional stakeholders.
Ability to communicate and present information effectively, respond to questions, define problems, collect data, establish facts, draw valid conclusions, and interpret reports and Bank policies and procedures.
Ability to manage multiple complex priorities and competing agendas and work independently with substantial judgment.
Ability to comply with Bank confidentiality, access, records, regulatory, compliance, and operational risk requirements.
Ability to meet the physical and work environment demands described in the posting, including occasional lifting or moving of up to 10 pounds and occasional bending and local travel.
Ability to work schedules that meet the needs of the Bank, which may include early morning, evening, or weekend hours.

Nice To Haves

Experience with Salesforce, including reporting, dashboards, data analysis, or CRM administration.
Experience supporting executive dashboards, strategic planning, project portfolio reporting, or Board-level reporting.
Experience with data warehouses, data governance, master data, or reporting automation initiatives.
Experience with Python or R, Microsoft Fabric/Power BI dataflows and Power Automate, ETL/ELT tools, and version control.

Responsibilities

Develop and maintain executive dashboards, management scorecards, recurring reports, and self-service reporting covering strategic, financial, customer, lending, deposit, operational, project, and productivity performance.
Develop and monitor enterprise performance metrics, identify trends, opportunities, and emerging risks, and provide actionable insights to executive leadership and business owners.
Analyze customer relationships, product usage, channel activity, lending and deposit trends, profitability, and other indicators to identify growth opportunities, emerging concerns, and business drivers.
Work with business departments to translate reporting requirements into measurable KPIs, develop their calculations, and implement them in dashboards and reporting solutions.
Support the enterprise project portfolio with dashboards and analysis of status, milestones, budgets, risks, dependencies, resource capacity, and benefits realization.
Reduce reliance on manually assembled spreadsheets by designing, building, testing, and maintaining repeatable, controlled, scalable automated reporting processes.
Develop and maintain reporting solutions using Power BI, SQL, Excel, and other available tools, including extracting, transforming, integrating, and validating data from multiple banking systems.
Translate complex data into clear findings, visualizations, business implications, and practical recommendations for executive leadership, committees, and business managers.
Validate, reconcile, cleanse, and troubleshoot data; investigate inconsistencies; maintain reporting documentation; and ensure analytical practices comply with Bank confidentiality, access, records, and regulatory requirements.
Assist internal, external, and regulatory auditors by gathering requested materials for assigned engagements.
Use tools and systems to self-manage and organize work, anticipate and resolve obstacles, manage deadlines, and create action plans when work is not on track.
Use discretion with sensitive and confidential information and follow Bank policies, procedures, core values, and service standards.
Maintain knowledge of and comply with Bank Secrecy Act regulations, compliance procedures, internal and operational risk controls, and applicable regulatory standards; attend required training and complete required online courses.
Maintain regular and consistent attendance and perform other similar or related duties as assigned.