Internship - Data Warehouse & Analytics Consultant at NBT Bank | Williamsville, New York | Rezi

Internship - Data Warehouse & Analytics Consultant at NBT Bank

Internship - Data Warehouse & Analytics Consultant

NBT Bank · Williamsville, New York

Today

Internship - Data Warehouse & Analytics Consultant

NBT Bank · Williamsville, New York

11 hours ago
Resume preview

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

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.

Responsibilities

  • 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.
  • Assisting with daily tasks.
  • 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.
  • 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.
  • Special Assignments.
  • Other duties as assigned.

Requirements

  • 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.
  • Applicants must be authorized to work for any employer in the U.S.
  • Unable to sponsor assume sponsorship of an employment Visa at this time.

Skills

  • Microsoft Fabric
  • Airflow
  • dbt
  • SQL
  • Python
  • Data warehouse architecture
  • Dimensional modeling
  • Power BI dashboard development
  • Data governance
  • Data quality controls
  • Advanced Excel
  • Stakeholder communication skills
  • Communicate effectively with internal and/or external customers

Work Type

  • Temporary
  • Internship

Experience Level

  • Intern

Education Level

  • Bachelor's degree program

Salary/Compensations

  • $20

Benefits

  • Generous time-off policies
  • Wellness initiatives
  • Flexible work arrangements
  • 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.
  • 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.
  • 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.

About the Company

  • 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.
  • 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.
  • 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.
  • 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.
  • NBT recognizes and rewards your contributions with competitive compensation, comprehensive benefits and performance-based incentives – ensuring you feel valued every step of the way.
  • 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.