Community Bank System Inc. (NYSE:CBU) is a full-service financial institution with more than 225 customer locations across New York, Pennsylvania, Vermont and Massachusetts, where we’re known as Community Bank, N.A.

With over $16.2 billion in assets, we have the resources to finance a wide range of personal, business banking and commercial business needs. Since 2012, Community Bank has consistently been named in the top 15 on Forbes’ list of Best Banks in America, twice reaching the No. 3 spot.

Established in 1866, Community Bank empowers our more than 3,000 employees across 21 states to be decision makers at the local level, leveraging the strong personal relationships we have with our customers with their financial expertise to drive the best results. This gives our team the confidence to make those decisions, and our customers the comfort in knowing the person they work with every day is the person they need to talk to.

We consistently invest in our communities through financial support, fundraisers and volunteer efforts, giving our employees the support to help make a difference. Whether it’s donating to local non-profit organizations or financing the businesses that give a community its identity, working together to make life better is what Community Bank is all about. Member FDIC. Equal Housing Lender.

Our Diversity Council of more than 100 employees was created to make sure no one feels unheard, unseen or uninvited. Through that effort, we’ll foster a culture that doesn’t just accept diversity, but values it.

This position is responsible for using data analytics from various available data sources, including but not limited to internal systems, to provide information regarding customers, markets, competitors, etc. that will measure performance and support business/marketing decisions.

Ability to work independently on strategic, high-level analytics projects along with various departments and stakeholders. Responsibilities include, but are not limited to, gathering data or application requirements. Independently designs and implement solutions for problems and/or opportunities to improve efficiency.

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.

• Data integration with various applications/platforms
• • Maintain data quality
• • Work cross functionally with various banking teams to support, gather requirements and ensure we adhere to best practices
• Oversee data pipelines, data modeling and data documentation for various DA work streams
• Assist with other key initiatives and other related DA projects
• Ability to understand and maintain a view of the big picture while creating detailed, operation level processes, workflows, and requirements.
• Create reports on marketing and sales activities for real-time visualization of cross-channel performance to identify ROI by channels and programs.
• Provide ROI analysis for all marketing campaigns and sales initiatives
• Ability to extract insights from data and drive informed decision-making within the organization. Role will involve utilizing AI/ML algorithms to analyze large datasets, develop predictive models, and create data-driven solutions to address business challenges and opportunities.
• 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 and generation of strategic marketing KPIs.
• Deep understanding and functional knowledge of various development tools and SQL flavors. Ability to design, develop and implement various analytics related projects across the organization.
• Should be having minimum 5 years of experience working with relational database like Oracle/Teradata/MYSQL/MS-SQL
• Maintain compliance with data governance and protocols through all processes.

Qualifications

Education/Training: Bachelor's Degree in Computer Science, Information Systems, Marketing, Business, Accounting or other related field.

Skills

• 2+ years as data engineer or data analyst.
• Experience with Snowflake and DBT.
• Strong working knowledge of Python, SQL, and Git.
• Familiarity with data modeling and data warehousing concepts, preferably with experience using modeling tools like dbt or DataIku.
• Working knowledge with cloud data warehousing, preferably in Snowflake, Azure or similar cloud infrastructure.
• ELT tools, preferably Astronomer and Apache Airflow.
• Experience with BI tools, preferably Power BI.
• 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.
• Any prior experience/knowledge of AI/ML practices will be given high preference, primarily responsible for leveraging advanced analytics techniques,particularly in artificial intelligence (AI) and machine learning (ML).
• All applicants must be 18 years of age or older.

Experience: Minimum 3-5 years of proven experience in data analysis.

Banking Experience Preferred.