Data Warehouse & Analytics Consultant

NBT Bankβ€’Williamsville, NY
β€’$19 - $21

About The Position

NBT Bank is seeking a temporary, project-based Data Warehouse & Analytics Consultant to support data warehousing, analytics, reporting, and data governance initiatives. The role contributes to the design, development, and enhancement of enterprise data solutions that support business decision-making. The consultant partners with business stakeholders and technical teams to gather requirements, design data warehouse structures and reporting environments, build and maintain ETL/ELT pipelines, document data mappings and business rules, develop Power BI dashboards, and perform validation and quality assurance. The position also includes participation in project planning, status meetings, stakeholder reviews, and knowledge-sharing activities. The role requires an associate's or bachelor's degree in a relevant field or equivalent experience, along with experience in data engineering, data warehousing, BI, or analytics projects. Experience with cloud data platforms is preferred. Applicants must be authorized to work for any employer in the United States; visa sponsorship is not available.

Requirements

  • Associate's or bachelor's degree in Computer Science, Information Systems, Data Analytics, Business Analytics, or a related field, or equivalent experience.
  • Experience with data engineering, data warehousing, BI, or analytics projects.
  • Ability to independently manage project deliverables and timelines.
  • Skills in Microsoft Fabric, Airflow, dbt, SQL, and Python.
  • Knowledge of data warehouse architecture and dimensional modeling.
  • Power BI dashboard development skills.
  • Knowledge of data governance and data quality controls.
  • Advanced Excel and stakeholder communication skills.
  • Authorization to work for any employer in the United States.

Nice To Haves

  • Experience with cloud data platforms.

Responsibilities

  • Partner with business stakeholders and technical teams to gather reporting and analytics requirements.
  • Design dimensional models, fact tables, reporting structures, and centralized data repositories integrating information from multiple systems.
  • Evaluate data architecture and recommend improvements for scalability, performance, and usability.
  • Develop and optimize automated ETL/ELT data integration processes using cloud technologies and modern data engineering tools.
  • Create extraction, transformation, and loading processes for structured and unstructured data sources.
  • Monitor pipeline performance, troubleshoot issues, and improve reliability, efficiency, and data integrity.
  • Create and maintain source-to-target mappings, transformation logic documentation, process flows, and technical specifications.
  • Document business rules, data definitions, and reporting methodologies for governance, audit, and ongoing maintenance.
  • Design and develop interactive Power BI dashboards, scorecards, and executive reporting solutions.
  • Collaborate with stakeholders to identify KPIs and present information through data visualizations.
  • Perform testing, reconciliation, and validation to ensure data accuracy, completeness, and consistency.
  • Investigate data quality issues, recommend corrective actions, and support user acceptance testing.
  • Participate in project planning, status meetings, and stakeholder reviews; present progress updates and communicate technical concepts to non-technical audiences.
  • Contribute process improvement recommendations, support knowledge sharing, and perform other duties as assigned.

Benefits

  • Generous paid time off of at least 22 days annually for full-time employees, prorated in the year of hire.
  • Six weeks of paid parental leave at 100% of salary.
  • Medical coverage, including employer HSA contributions for eligible High Deductible Health Plan participants.
  • Dental and vision coverage.
  • Flexible spending accounts for healthcare and dependent care expenses.
  • Employer-paid short- and long-term disability coverage, with an option to purchase additional long-term coverage.
  • Employer-paid basic life insurance, with an option to purchase supplemental coverage.
  • Voluntary hospital, accident, and critical illness coverage.
  • 401(k) with employer matching, optional Roth 401(k), and pension plan.
  • Adoption assistance.
  • Tuition reimbursement.
  • Employee Assistance Program.
  • Pet insurance.
  • Banking services benefits and financial planning assistance.
  • Paid sick and safe leave for part-time employees.
Β© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service