Senior Data Engineer - Data Warehousing & ETL Lead

Bangor Savings Bank; United States; On-site; USD 68,000 - 88,000; Full time

Benefits offered by this job

Tuition reimbursement

Health & wellness programs

On-site campus Bangor, ME

Job summary

Bangor Savings Bank is seeking a Data Engineer at Senior/Principal level to lead data warehousing initiatives and build end-to-end ETL pipelines. You will design data warehouses, data lakes, and data marts, ensuring data quality and timely delivery for BI solutions.

The role emphasizes mentorship, collaboration with business lines, and driving automation across data platforms. You should bring strong SQL skills, experience with SSIS or Talend, and proficiency in Python/Java/.NET, with a track

Qualifications

• BS or MS in Computer Science or related field or equivalent work experience.
• Experience with Data Architecture, Data Lake, Data Marts, ODS, analytics systems and metadata management.
• Experience with schema design and dimensional data modeling.
• Programming experience in Python, JavaScript, C#, Java.
• Experience with REST APIs, SDKs and CLI tools for ETL provisioning.
• Experience with multi-format data (JSON, XML, CSV, flat files).
• Relevant certifications preferred.
• Strong troubleshooting, documentation and collaboration skills.
• Expert knowledge of modern databases and BI technologies.

Responsibilities

• Design, deploy data warehouses, data marts and data lakes as data stores for BI solutions.
• Build and maintain ETL pipelines to integrate data sources.
• Develop and test ETL mappings and BI data stores.
• Collaborate with stakeholders to define reporting and dashboard needs.
• Mentor and lead data design projects within D&A.
• Ensure high availability and performance of data platforms.

Skills

SSIS

Talend

MS SQL

Python

JavaScript

C#

Java

REST APIs

JSON/XML/CSV

Data modeling

Data warehousing

Data quality

Education

BS or MS in CS or related field

Job description

Bangor Savings Bank is seeking a Data Engineer at Senior/Principal level to lead data warehousing initiatives and build end-to-end ETL pipelines. You will design data warehouses, data lakes, and data marts, ensuring data quality and timely delivery for BI solutions.

The role emphasizes mentorship, collaboration with business lines, and driving automation across data platforms. You should bring strong SQL skills, experience with SSIS or Talend, and proficiency in Python/Java/.NET, with a track