Data Engineer

About the Business Intelligence Team    
** About the Role
** As a full-time, Data Engineer, you will be responsible for the creation of data pipelines required to support various use cases or project initiatives at Bangor Savings Bank. You will design & deploy data warehouses, data marts, and data lakes where appropriate as data stores for business intelligence solutions. You will identify gaps and improvements to the data management systems with an emphasis on automation, quality and data delivery solutions.

You will implement full end-to-end Data Warehousing solutions including data architecture, data provisioning, data integration, data publishing, and execute effectively as part of a team.

This role requires initiative, drive, and a strong work ethic. The position balances a fast-paced work environment with doing things meticulously and properly; working independently within highly collaborative integrated teams.

A Senior-level Data Engineer is additionally expected to have a practical working knowledge of data modelling concepts and will be able to successfully lead teams or projects related to data design and deployment.  An individual in the senior role will require a demonstrated ability to work harmoniously with teams and business lines throughout the bank in a productive and thoughtful manner.

This position is expected to act as a role model for other BI team members in all aspects of daily work, including the education of less experienced team members, and by leading by example.

A Principal-level Data Engineer is additionally expected to provide leadership and mentoring to other BI team members – both analysts and technical staff.  This role additionally takes a proactive approach to continue their education and maintain an expert level working knowledge.  Persons in this position are considered the most senior of BI staff, and as such, will be expected to take primary responsibility for developing solutions and fulfilling job duties.  

This position may also act as a backup for management in several capacities including, but not limited to, training, coaching, and mentoring fellow employees.  They will lead within BI, and work on strategic initiatives that are key to the success of business lines.
** You’re Excited About this Opportunity Because You Will…
*** Collaborate with project leads, business analysts, end users and third-party contacts to design, implement and test data warehouse applications.
* Design, build, enhance, and maintain ETL processes to make new and existing data sources.
* Develop and perform unit, system, performance and regression testing on ETL mappings.
* Design and develop enterprise and departmental business intelligence and data warehousing solutions.
* Interact with end users and business analysts to understand reporting/dashboard requirements.
* Perform data profiling of source data to identify data quality issues and anomalies, business knowledge embedded in data, gathering of natural keys, and metadata information.
* Support and improve production data integration system and environment.
* Understand the data architecture needs and data structures in the source systems and business processes.
* Design data marts for business units and collaborate with development teams during the implementation.
* Collaborate with internal & external data consumers to understand their data needs and drive towards unifying collections of data requirements for key data elements across the organization.
* Document and maintain documentation related to data mapping and other data design artifacts that encompass data specifications, business & transformation rules.
* Collaborate with vendors and internal developers in requirements gathering sessions with stakeholders to determine user needs and capture data requirements.
* Translate business requirements and data needs into solutions easily used for reporting, scorecards and dashboards.
* Apply Bank standards and industry best practices to the ongoing management of the database infrastructure and related technologies.
* Demonstrate ownership of database and related technologies and all issues that arise with them.
* Ensure the highest…