What are the responsibilities and job description for the BI Analyst position at Community Bank System, Inc.?
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, 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.
Responsibilities
This postions performs analysis of data, dashboard preparation, visulaization based on reporting requirements, data validation, data modeling, and data replication. This position also evaluates functional and techinical specifications to fulfull data requirements for key initiatives/projects. Independently develops test plans, validation requirements and documentation to ensure data integrety for analysis and report requests.
1. Deep understanding and functional knowledge of Power BI to be able to design, develop and implement dashboards across the organization based on Power BI platform
2. Ability to work with large and varied data sets to formulate lists, reports and analysis that will assist management in the measurement, tracking, and performance of key initiatives/ KPIs.
3. Functional ETL experience using non-coding environments or SQL (MS SQL, Oracle, MySQL Server, Teradata or similar) or other ETL tool is desirable
4. Should be having minimum 2 years of experience working with relational database like Oracle/Teradata/MYSQL and file-based data storage systems like Hive/Hadoop
5. Works with various departments to gather data or application requirements.
6. Works with Senior Power BI Lead on designs, and implements solutions for problems and/or opportunities to improve efficiency.
7. Independently develops test plans, validation requirements and documentation to ensure data integrity for analysis and report requests.
8. Understand and utilize programs, tools and databases efficiently to provide data requirements to users timely.
9. Designs and automates processes and queries for maximum efficiency and performance.
10. Troubleshoot and resolve development and functional issues to meet user requirements.
11. Communicates potential issues along with possible solutions and works with the business unit to identify optimal solution.
12. Identify, document and communicates data gaps (i.e. missing or limited data) along with solutions to address the gap management.
13. Maintain compliance with data governance and protocols through all processes.
Qualifications
Basic Qualifications: Bachelor's Degree or Diploma 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 tool. Excellent verbal and written communication skills in technical and user-friendly manner, adapability to changing priorities. Must have the ability to collaborate and work in a team environment.
Experience: Minimum of 3 years proven experience in data analytics. Banking experience preferred.
Salary : $0
