Hiring.Camp

Data Warehouse & Analytics Consultant

Nb T

·

Yesterday

Salary
$19 – $21/hr
Location
6460 Main Williamsville, United States of America
Type
Part-time
Department
Operations
Education
Bachelor
Visa
Not sponsored
Source
Workday

Description

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.

Skills

PythonSQLAirflowData EngineeringETLExcelPower BIdbt

Similar Jobs

30

Data Architect / Data Warehouse Architect – Remote Contract

Maxit Consulting Jobs·Athens, Attica·Remote

Today

Database Architect – Data Warehouse & Workday Reporting (Remote, Contract)

Maxit Consulting Jobs·Athens, Attica·Remote

Today

Data Warehouse Engineer

Twoharbors·446 Wrenplace Rd, Fort Mill +2

Today

Data Warehouse & Data Science Trainee

Sandoz·Spain

1d ago

Data Warehouse Architect

Fast Switch

IT Data Science Principal (Data Warehouse)

Cornerstone Building Brands·Cary, North Carolina·Remote

1w ago

Data Warehouse Developer SQL / ETL (all genders)

Accenture·Innsbruck, Tyrol +1·Hybrid

1w ago

Data Warehouse Developer (Data Warehouse Engineer, Data Engineer)

Cleveland Steel Container·Hudson, Ohio

1w ago

Principal Data Engineer, Data Warehouse (TPL)

Engelhart·London, England

1w ago

SAP/BW Data Warehouse Analyst

RTX·Glenrothes, Scotland +1·Hybrid

1w ago

Data Warehouse Engineer

Manobank·Vilnius, Lithuania·Hybrid

1w ago

Data Warehouse Engineer

Hamiltoncompany·Reno, Nevada·Onsite

2w ago

Data Warehouse/Microsoft Fabric Engineer

Parsons Corporation·US·Remote

2w ago

Senior Data Warehouse Architect

Datamatics Technologies·Stockholm, Sweden·Onsite

2w ago

Senior Data Warehouse Architect

Datamatics Technologies·Malmö, Skåne·Onsite

2w ago

Senior Data Warehouse Architect

Datamatics Technologies·Göteborg, Västra Götaland·Onsite

2w ago

Lead Data Warehouse Engineer

Greendotcorp·US·Remote, Hybrid, Onsite

2w ago

Data Warehouse Specialist

Careers Home·La Jolla, California

2w ago

DWH Developer (m/w/d) – Data Warehouse & BI

Ecotel·Düsseldorf, North Rhine-Westphalia·Hybrid

2w ago

Data Warehouse Intern

Fuku·Singapore

Data Warehouse Architect

Hebrewseniorlife·Roslindale, Massachusetts·Hybrid

2w ago

Data Warehouse System Engineer

Synnex·Ontario, California

2w ago

SQL Developer / Data Warehouse ETL Developer

Southgeeks·Remote·Remote

2w ago

Business Analyst - Data Warehouse & Business Intelligence

Fil·Toronto, Ontario

3w ago

Data Warehouse Developer

bet365·Manchester, England·Hybrid

3w ago

Data Warehouse Developer

bet365·Stoke-on-Trent, England·Hybrid

3w ago

Summer 2027 Enterprise Data Warehouse Systems enGen Undergraduate Intern

Highmarkhealth·US·Hybrid

3w ago

Data Warehouse Director

Forest River, Inc.·Elkhart, Indiana·Onsite

1mo ago

WM Data Platforms for Data Warehouse – Product Owner - Assistant Vice President

Morgan Stanley·Budapest, Hungary

1mo ago

WM Data Platforms for Data Warehouse – Product Owner - Assistant Vice President

Ms·Hungary

1mo ago