Internship - Data Warehouse & Analytics Consultant

Location: Williamsville, NY

Time Type: Part time

Job Description

Salary: $20

As part of NBT’s Internship Program currently enrolled college students have the opportunity to explore various departments within NBT Bank, including Accounting and Finance, IT, Human Resources, Marketing, and others. Interns will gain practical experience, work on meaningful projects, and learn from experienced professionals in a variety of fields.

We currently have an opportunity that will:

• Provide temporary project-based support for data warehousing and reporting solutions.
• Develop and optimize ETL/ELT pipelines.
• Support data quality, governance, and reporting initiatives.
• Create dashboards and analytical reports.
• Collaborate with business and technical teams to achieve project objectives.

Education and Experience

• Currently enrolled in a Bachelor's degree program in a related field.
• Experience with data engineering, warehousing, BI, or analytics.
• Experience with cloud data platforms preferred.
• Ability to independently manage project deliverables.

Skills and Abilities

• Microsoft Fabric, Airflow, dbt, SQL, Python.
• Data warehouse architecture and dimensional modeling.
• Power BI dashboard development.
• Data governance and quality controls.
• Advanced Excel and stakeholder communication skills.

Tasks Performed:

• 40% Assisting with daily tasks.
• 20% Project support – collaborating on team projects, assisting with ongoing projects by providing research, creating reports, and/or supporting team members. Contributing ideas during brainstorming sessions or team meetings. Preparing presentations by creating slides, reports, or any materials for internal presentations. 
• 20% Learning and Development – shadowing professionals through observation of full-time employees to understand work process. Attend training sessions and participate in workshops and learning new tools and systems. 
• 15% Special Assignments.
• 5% Other duties as assigned. 

Physical Requirements:

• Communicate effectively with internal and/or external customers
• Stationary 75% of time or greater
• Move Objects to Maximum 10 lbs

Why Work at NBT

At NBT we empower people to grow, innovate, and thrive through meaningful work, a supportive culture and opportunities to make a real impact in your community – because your success drives our success. 

Wellbeing 

At NBT, we value and support your wellbeing by offering generous time-off policies, wellness initiatives and flexible work arrangements, so you can thrive both personally and professionally. 

Community Involvement 

NBT believes community involvement fosters our success and the success of those around us. Through volunteer service and charitable partnerships, we empower our employees to make a positive impact beyond the workplace. 

Culture 

NBT believes in creating a workplace where every voice matters and every team member feels empowered to contribute. With supportive leadership, we foster an environment where employees are connected, inspired, and valued. 

Career Development 

Whether you’re just starting your career or serve in a senior leadership role, your growth and development are our priority. NBT provides a wide variety of development programs and tools for you to reach your full potential. 

Total Rewards 

NBT recognizes and rewards your contributions with competitive compensation, comprehensive benefits and performance-based incentives – ensuring you feel valued every step of the way.

Business Stability 

NBT has built a reputation as a stable financial institution by growing our people and our business, evolving our processes and managing risk. We've weathered the market's ups and downs for over 165 years, all while charting a well-defined growth plan. 

Benefits for Full-Time Employees: 

• Generous Paid Time Off: At least 22 days annually, prorated in the year of hire. 

• Parental Leave: Six weeks of paid leave at 100% of your salary. 

• Comprehensive Medical Coverage: Includes employer contributions to HSA for High Deductible Health Plan participants. 

• Dental and Vision Coverage: Ensuring your overall health and well-being. 

• Flexible Spending Accounts: For healthcare and dependent care expenses. 

• Employer-Paid Disability Coverage: Both short-term and long-term, with an option to purchase additional long-term coverage. 

• Life Insurance: Employer-paid basic life insurance, with an option to purchase supplemental coverage. 

• Voluntary Benefits: Including hospital, accident, and critical illness coverage. 

• Retirement Plans: Benefit from a 401(k) plan with employer matching, an optional Roth 401(k), and a pension plan to help secure your future.

• Adoption Assistance: Supporting your growing family. 

• Tuition Reimbursement: Invest in your education and career growth. 

• Employee Assistance Program (EAP): Access to support and resources. 

• Pet Insurance: For all your furry friends.

• Financial and Banking Services: Various banking services benefits and financial planning assistance. 

Benefits for Part-Time Employees Working 20+ Hours/Week: 

• Medical Coverage: Includes employer contributions to HSA for High Deductible Health Plan participants. 

• Dental and Vision Coverage: Ensuring your overall health and well-being.

• Voluntary Benefits: Including hospital, accident, and critical illness coverage.

• Generous Parental Leave: Six weeks of paid leave at 100% of your salary. 

Benefits for All Part-Time Employees: 

• Retirement Plans: Benefit from a 401(k) plan with employer matching, an optional Roth 401(k), and a pension plan for employees who work at least 1,000 hours in a calendar year, all designed to help secure your future

• Paid Sick and Safe Leave: For your health and safety. 

• Employee Assistance Program (EAP): Access to support and resources. 

• Financial and Banking Services: Various banking services benefits and financial planning assistance.

Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor assume sponsorship of an employment Visa at this time.