Business Intelligence Analyst

Rockland Trust Company•Rockland, MA

About The Position

Rockland Trust is seeking a Business Intelligence (BI) Summer Intern to gain hands-on experience with data, analytics, and reporting tools that support decision-making across the organization. The intern will work with experienced BI professionals to develop dashboards, analyze business information, support reporting solutions, and contribute to projects that help teams serve customers, improve operations, and identify growth opportunities. The intern will also collaborate with fellow interns on a summer project addressing a real business challenge, develop recommendations, and present findings to Bank leadership. The experience is intended to build technical, analytical, and professional skills in business intelligence, data visualization, reporting, and technology-driven decision-making. The position offers practical exposure to Power BI and reporting tools, data models and ETL concepts, data quality and testing, business process analysis, SQL and database fundamentals, project management, stakeholder communication, and data storytelling. Interns receive mentorship and opportunities to network with professionals across the Bank.

Requirements

Currently pursuing a degree in Computer Science, Information Technology, Data Science, Business Analytics, Management Information Systems, or a related field.
Basic understanding of programming concepts such as Python, SQL, or JavaScript.
Familiarity with Power BI, Tableau, or other data visualization tools.
Basic knowledge of data analysis and reporting concepts.
Strong interest in business intelligence, analytics, and data visualization.
Strong problem-solving skills and attention to detail.
Strong written and verbal communication skills.
Ability to translate information into clear and actionable insights.
Ability to work independently and collaboratively within a team environment.
Strong organizational and time-management skills.
Curiosity, initiative, and a passion for learning.
Ability to prioritize multiple tasks and meet deadlines.
Commitment to producing accurate, high-quality work.
Openness to feedback and continuous improvement.

Nice To Haves

Rising junior or senior status is preferred.
Previous internship, academic project, or work experience involving programming, data analytics, or reporting.
Exposure to relational databases and SQL.
Coursework or certifications in Power BI, Tableau, data analytics, or related technologies.
Experience building dashboards or conducting data analysis projects.

Responsibilities

Collaborate with senior BI developers to design, build, and enhance dashboards, reports, and visualizations using Power BI.
Assist with developing and maintaining data models, ETL processes, and reporting solutions.
Apply best practices related to data integration, transformation, and reporting.
Support projects that improve business teams' access to and understanding of key performance data.
Participate in testing and validation to ensure reporting accuracy and functionality.
Assist with troubleshooting, debugging, and resolving issues in dashboards and reports.
Help monitor data quality and support continuous improvement initiatives.
Document data flows, reporting requirements, and BI processes.
Help map business processes and identify opportunities to improve reporting capabilities.
Support efforts to enhance data accessibility and reporting efficiency.
Monitor data pipelines and scheduled reports to help ensure consistent delivery of business insights.
Help identify and resolve issues affecting dashboards, reports, or reporting processes.
Help maintain existing BI solutions and support users and stakeholders.
Collaborate with fellow interns on summer projects addressing a real business challenge.
Research and analyze the business challenge, develop recommendations, and present findings to Bank leadership.