Jobs › Companies › NBT Bank › Data Warehouse & Analytics Consultant

About this Data Warehouse & Analytics Consultant role at NBT Bank

NBT Bank · Onsite · Williamsville, NY
Pay Range: $18.50 - $21.18

NBT Bank is seeking a Temporary Data Warehouse & Analytics Consultant to provide project-based support for data warehousing, analytics, reporting, and data governance initiatives. This temporary role will contribute to the design, development, and enhancement of enterprise data solutions that support business decision-making.

Education and Experience:

  • Associate's or Bachelor's degree in Computer Science, Information Systems, Data Analytics, Business Analytics, or related field, or equivalent experience. 
  • Experience with data engineering, data warehousing, BI, or analytics projects. 
  • Experience with cloud data platforms preferred. 
  • Ability to independently manage project deliverables and timelines.

Skills and Abilities:

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

Tasks Performed:

  • 35% - Design and Implement Data Warehouse Structures and Centralized Reporting Environments: Partner with business stakeholders and technical teams to gather reporting and analytics requirements. Design dimensional models, fact tables, and reporting structures that support enterprise reporting needs. Build centralized data repositories that integrate information from multiple systems and provide trusted, consistent data for business decision making. Evaluate current architecture and recommend enhancements for scalability, performance, and usability. 
  • 25% - Build, Test, and Deploy ETL/ELT Pipelines: Develop and optimize automated data integration processes using cloud-based technologies and modern data engineering tools. Create extraction, transformation, and loading processes for structured and unstructured data sources. Monitor pipeline performance, troubleshoot issues, and implement improvements to ensure reliability, efficiency, and data integrity. 
  • 15% - Develop Technical Documentation and Data Mapping Specifications: Create and maintain source-to-target mappings, transformation logic documentation, process flows, and technical specifications. Document business rules, data definitions, and reporting methodologies that support governance, audit, and ongoing maintenance requirements. 
  • 10% - Create Power BI Dashboards and KPI Reporting: Design and develop interactive dashboards, scorecards, and executive reporting solutions. Collaborate with stakeholders to identify key performance indicators and present information through intuitive data visualizations that support strategic and operational decision making. 
  • 10% - Perform Validation, Reconciliation, and Quality Assurance Activities: Execute testing, reconciliation, and validation activities to ensure data accuracy, completeness, and consistency across reporting environments. Investigate data quality issues, recommend corrective actions, and support user acceptance testing activities. 
  • 5% - Participate in Project Meetings and Knowledge Sharing & other duties as assigned: Participate in project planning, status meetings, and stakeholder reviews. Present progress updates, communicate technical concepts to non-technical audiences, contribute process improvement recommendations, and support organizational knowledge-sharing initiatives. 

Physical Requirements:

  • Communicate effectively with internal and/or external customers
  • Stationary 75% of the time or greater
  • Move objects up to a maximum of 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 or assume sponsorship of an employment Visa at this time.

Ready to apply to NBT Bank?
Apply to NBT Bank

How this Consultant salary compares

This role pays $41,267/yr — below the typical range for Consultant roles.

$41,184 median $99,000 $170,000

Typical range $62,400–$138,075/yr, from 5,649 comparable Consultant listings on JobsRadar (pay annualized to USD). See Consultant salary insights →

About NBT Bank

NBT Bank is an equal opportunity employer and fully supports a diversified environment. We do not discriminate against any applicant or employee because of race, color, religion, sex, national origin, age, disability, sexual orientation, marital status or veteran status, recently separated veterans, genetic information, victims of domestic violence and stalking or any other class protected by Federal, State or local law. This policy applies to all terms of employment. NBT Bank is inclusive and supportive of individual needs. If you have a physical or other impairment that might require an accommodation, including technical assistance with the Careers website or submission process, please cal

See all jobs at NBT Bank →

Similar jobs

Signet Jewelers
Sales Associate / Jewelry Consultant - Kay Jewelers - Eastern Hills Mall - Buffalo, NY
Signet Jewelers
⚡ Apply early Kay Jewelers - Eastern Hills M... Onsite $33,280–$42,640 ⚠ 6mo+ old
● New 👁 Seen ✓ Applied 9mos ago
Immersive
Solutions Consultant (Cyber Security) - Portugal
Immersive
⚡ Apply early Portugal · location restricted
● New 👁 Seen ✓ Applied 1h ago
Fehrandpeers
Transportation Consultant (8-12 years)
Fehrandpeers
⚡ Apply early Dallas, Texas Onsite
● New 👁 Seen ✓ Applied 1h ago
Fehrandpeers
Transportation Consultant (8-12 years)
Fehrandpeers
⚡ Apply early Tacoma, Washington Onsite
● New 👁 Seen ✓ Applied 1h ago
Fehrandpeers
Transportation Consultant (8-12 years)
Fehrandpeers
⚡ Apply early Orlando, Florida Onsite
● New 👁 Seen ✓ Applied 1h ago
PlayStation Global
Senior Finance Data Governance Consultant (Contract)
PlayStation Global
⚡ Apply early United States, Remote · location restricted $129,600–$194,400
● New 👁 Seen ✓ Applied 3h ago
TraceLink, Inc
Senior Solutions Consultant (Supply Chain Business Process Architect)
TraceLink, Inc
⚡ Apply early EMEA - UK - Remote · location restricted
● New 👁 Seen ✓ Applied 3h ago
Resolve To Save Lives
Regional Implementation Consultant, IDSR in Private Health Facilities
Resolve To Save Lives
⚡ Apply early Ethiopia Onsite
● New 👁 Seen ✓ Applied 3h ago
Our Group
Insights Consultant at FirstMind
Our Group
⚡ Apply early London, United Kingdom Onsite
● New 👁 Seen ✓ Applied 4h ago

Sign up for suggestions tailored to the jobs you open and the searches you save.

More jobs at NBT Bank

See all jobs at NBT Bank →

Apply now
🤖

Whoa — hold up

JobsRadar was built for real people having a rough time in their job search — not for automated requests. You're clicking way too fast and you're now temporarily blocked.

Come back later. If you're genuinely job hunting, we've got your back — just act like a human.

Catch your next role the second it’s posted.

Create a free account and we’ll watch the boards for you — the instant a job matches your search, it lands in your inbox or Telegram. No digging, no refreshing.

Create free account

Free forever · takes 30 seconds · already have one?

Get an edge on your job hunt.

Join our Telegram channel for the stuff that helps you land the role — salary benchmarks, the weekly market pulse, and new-feature drops. No spam, just signal.

Join the channel — it's free