Business System Analyst Temporary Intern

At Community Bank System, Inc. (CBSI), we are dedicated to providing our customers with friendly, personalized, high-quality financial services and products. Our retail division, Community Bank, N.A., operates more than 230 customer facilities across Upstate New York, Northeastern Pennsylvania, Vermont and Western Massachusetts. Beyond retail banking, we also offer wealth management, investment management, insurance and risk management, and benefit plan administration.

Just as our employees are committed to helping our customers manage their finances, we're committed to our employees. After all, they make it happen for our customers every day.

To ensure our people can enjoy long and successful careers here at CBSI, we offer competitive compensation, good benefits, and professional development and advancement opportunities. As an equal-opportunity workplace and affirmative-action employer, we celebrate and support a diverse workplace for the benefit of all: our employees, customers and communities.

This position performs analysis of data, dashboard preparation, visualization based on reporting requirements, data validation testing, data modeling, and data replication. This position also evaluates functional and technical specifications to fulfill data requirements for key initiatives/projects. Independently develops test plans, validation requirements and documentation to ensure data integrity for analysis and report requests.

• Collect, clean and organize financial and non-financial data using a variety of tools;
• Ensure data quality through review and validation with source material;
• Analyze both qualitative and quantitative data;
• Ability and temperament to learn and apply new data analytics technologies such as Power BI, Snowflake, Tableau, MS-SQL, data warehousing and data modeling concepts
• Assist with financial, statistical, and econometric analysis;
• Other projects may be assigned on an as-needed basis.
• Ability to maintain compliance with data governance and protocols through all processes.
• As an intern, be able to contribute to the overall strategic direction of the Data & Analytics Department. This position is responsible to provide assistance wherever necessary to help the department and the bank in achieving their goals.

Location:

• This is an onsite position located in Olean, NY

Education, Training and Requirements:

• Pursuing Bachelor's Degree in Computer Science, Information Systems or other related field

Skills:

• Strong analytical and problem solving skills.
• Power BI, MS SQL, Microsoft Office (Excel, Word, Visio, Access), and query tools.
• Excellent verbal and written communication skills in technical and user-friendly manner, adaptability to changing priorities.
• Must have the ability to collaborate and work in a team environment.

Experience:

• Any prior experience in data analysis would be desirable. Related major preferred.