Intern Data Analytics

At Community Financial System, Inc. (CFSI), 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 200 customer facilities across Upstate New York, Northeastern Pennsylvania, Vermont and Western Massachusetts. Beyond retail banking, we also offer commercial banking, 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 CFSI, we offer competitive compensation, great 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.

• Maintain proficient knowledge of, and demonstrate ongoing compliance with all laws and regulations applicable to this position, ensure ongoing adherence to policies, procedures, and internal controls, and meet all training requirements in a timely manner.

Education/Training: 

• Pursuing Bachelor’s Degree in Computer Science, Information Systems or other related field.
• All applicants must be 18 years of age or older.

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.

Hours: 40 hours a week 

Compensation: Commensurate with experience plus potential for annual merit increase. In addition to your competitive salary, you will be rewarded benefits including: 11 paid holidays, paid vacation, Medical, Vision & Dental insurance, 401K with generous match, Pension, Tuition Reimbursement, Banking discounts and the list goes on!

Physical Requirements:

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee may be required to stand, walk or sit. Use hands and fingers, handle or feel, reach with hands or arms, and speak and hear. The employee may occasionally be required to lift and or move up to 25 pounds. Specific vision abilities required by this job include close vision, and the ability to focus.

The Company is an Affirmative Action, Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, sexual orientation and gender identity), national origin, citizenship status, age, disability, genetic information, veteran status, or any other characteristic protected by applicable federal, state or local law.

The Company will make reasonable accommodations for qualified individuals with a disability. If you have a physical or mental impairment and would like to request an accommodation with respect to the application process, please contact the Human Resources Department.