NBT Bancorp
Direct Workday career site

Data Warehouse & Analytics Consultant

Pay
$19 – $21 per hour
Location
Williamsville, NY · On-site
Job type
Temporary
Level
Mid-level
Listed
Today

Skills & highlights for this role

  • SQL
  • Python
  • dimensional modeling
  • Power BI

Also useful

  • Microsoft Fabric
  • Airflow
  • dbt

Stated benefits & perks

  • Health
  • Dental
  • 401k
  • Paid parental leave
Free · No account needed

How well does your resume fit this job?

Upload your resume to see your score for this NBT Bancorp role, what matches, what's missing, and your best other matches.

Scored on our server and not saved there. The file stays in this browser so you don't have to upload it again after you sign up.

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

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.
  • 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.

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.

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.

Read the original posting

From NBT Bancorp's careers page, first listed on Rolev.ai on November 20, 2026. Rolev.ai is not the employer.

How Rolev.ai helps with this application

Rolev.ai is a job search and application tool for US job seekers. For this Data Warehouse & Analytics Consultant role at NBT Bancorp, it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.

  • See how you fit

    Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.

  • Tailor without inventing

    Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.

  • Draft the full kit

    Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.

  • 1-Click Extension Autofill

    The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.

Common questions

What is the salary for the Data Warehouse & Analytics Consultant role at NBT Bancorp?

The Data Warehouse & Analytics Consultant posting at NBT Bancorp states compensation of $19 – $21 per hour. It is listed as a temporary position. Final pay may depend on location, experience, and interview evaluation on NBT Bancorp's official career site.

Where is the Data Warehouse & Analytics Consultant job at NBT Bancorp located?

This Data Warehouse & Analytics Consultant position at NBT Bancorp is located in Williamsville, NY (On-site). Always check NBT Bancorp's application page for specific state eligibility or relocation policies.

What qualifications are required for Data Warehouse & Analytics Consultant at NBT Bancorp?

For the Data Warehouse & Analytics Consultant role, NBT Bancorp highlights experience with SQL, Python, dimensional modeling, Power BI. Rolev.ai can score your existing resume against these requirements and show any skill gaps before you apply.

How do I apply for the Data Warehouse & Analytics Consultant position at NBT Bancorp?

This listing links directly to NBT Bancorp's Workday application page. You can apply directly on NBT Bancorp's site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the Workday application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.