About this role
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.