Data Engineer

About the Data and Analytics Team
Do you enjoy working on an energetic and innovative team that is moving the needle with all things data on a daily basis? At Bangor Savings Bank, we are hiring a Data Engineer to join the Data and Analytics (D&A) team. As part of this team, you will be critical to the success of onboarding new data sources and delivering data solutions for consumption by business line stakeholders.
Job Description
About the Role
As a full-time Data Engineer at Bangor Savings Bank, you will:
• Create data pipelines to support various use cases and project initiatives.
• Design and deploy data warehouses, data marts, and data lakes as needed for stakeholder solutions.
• Identify gaps and improvements in data management systems, focusing on automation, quality, and data delivery.
• Implement end-to-end Data Warehousing solutions, including data architecture, provisioning, integration, and publishing.
• Collaborate effectively as part of a team, taking requests and gathering requirements for reports, dashboards, scorecards, and other information delivery forms.
• Translate requirements into technical solutions, implement them, and maintain them over time.

This role requires initiative, drive, and a strong work ethic. You will balance a fast-paced work environment with meticulous and proper execution, working independently within highly collaborative, integrated teams.

A Senior-level Data Engineer is expected to:

• Have practical knowledge of data modeling concepts.
• Successfully lead teams or projects related to data design and deployment.
• Work harmoniously with teams and business lines across the bank in a productive and thoughtful manner.
• Act as a role model in all aspects of daily work, including educating less experienced team members and leading by example.

A Principal-level Data Engineer is expected to:

• Provide leadership and mentoring to other D&A team members, including analysts and technical staff.
• Take a proactive approach to continue their education and maintain expert-level knowledge.
• Develop solutions and fulfill job duties as the most senior member of the D&A team.
• Act as a backup for management in various capacities, such as training, coaching, and mentoring fellow employees.
• Lead the team and work on strategic initiatives crucial to the success of business lines.

You’re Excited About this Opportunity Because You Will…

• Demonstrate ownership of service requests and operationalize vague requests through discovery with internal customers.
• Maintain and extend competence with reporting and analytics tools, data structures, and relevant technical disciplines.
• 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 for 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 to identify data quality issues, anomalies, and gather metadata information.
• Support and improve production data integration systems and environments.
• Understand data architecture needs and data structures in source systems and business processes.
• Design data marts for business units and collaborate with development teams during implementation.
• Collaborate with internal and external data consumers to unify data requirements for key data elements.
• Document and maintain data mapping and other data design artifacts, including data specifications and transformation rules.
• Collaborate with vendors and internal developers in requirements gathering sessions to capture data needs.
• Translate business requirements into solutions for reporting, scorecards, and dashboards.
• Apply bank standards and industry best practices to manage database infrastructure and related technologies.
• Ensure the highest levels of availability and performance within data systems and infrastructure.
• Perform relevant administrative functions as requested.

We’re Excited About You Because You…

• Have demonstrated experience using SSIS, Talend, Python, or other similar tools to support data onboarding and exploration.
• Have a high proficiency in a MS SQL environment.
• Are analytical, observe processes and trends; make recommendations for process changes that help achieve departmental and individual goals.
• Take initiative and independent action, operate as a pro-active self-starter, act on opportunities, and practice self-development.
• Are adaptable and flexible, aren’t afraid of change, open to new ideas, take on new challenges, handle pressure, adjust plans to meet changing needs.
• Have integrity and ethics to deal with others in a straightforward, honest manner, are accountable for you own actions, maintain confidentiality, support company values, and convey news good or bad.
• Have good interpersonal skills including active listening skills and negotiation techniques.
• Have the vision and values of BSB!
• Have a strong organization system and use that system for the improvement and advancement of personal and team goals.
• Have relevant employment experience and demonstrated abilities as a Data Engineer.
• Have the desire and ability to maintain knowledge and skill currency within the fast-changing technological realm.
• Meet punctuality/attendance standards as expressed in the Employee Handbook.

What You Bring to the Table is…

• A BS or MS degree in Computer Science or a related technical field, or relevant work experience.
• Relevant technical certification(s) preferred.
• Experience with Data Architecture, Data Lakes, Data Marts, Operational Data Stores, Analytical systems, Metadata management, and scalable data storage solutions (blobs, data lakehouse, etc.).
• Experience with schema design and dimensional data modeling, including star schemas and ETL strategies.
• Proficiency in programming languages like Python, JavaScript, C#, Java, etc.
• Experience with APIs (REST APIs, SDKs, CLI tools) for ETL provisioning.
• Experience with multi-format files (JSON, XML, CSV).
• Exceptional troubleshooting abilities.
• Strong verbal and written communication skills.
• Proficiency with documentation tools (MS-Word, MS-Excel, MS-Visio).
• Expert-level knowledge of modern databases, reporting packages, and cloud-based solutions (AWS Redshift, Google BigQuery, Azure SQL Data Warehouse).
• Strong knowledge of SQL development, performance tuning, and index management.
• Strong knowledge of relational and multi-dimensional databases.
• Analytical approach to problem-solving and process improvement.
• Knowledge of responsible data and AI uses, including compliance, data limitations, and provenance.
• Willingness to stay updated on current and emerging technologies, industry trends, and best practices.

You’ll Love Working at Bangor Savings Bank Because We…

• Are a successful, vibrant, and innovative company.
• Care most about our employees, our customers, and our communities.
• Believe every interaction is an opportunity to provide a “You Matter More” experience.
• Believe in autonomy & initiative taking.
• Are a technologically and data-driven business.
• Have a smart, experienced, and diverse leadership team that wants to do it right & is open to new ideas.
• Have a beautiful new campus in Bangor, Maine.

External and internal applications, as well as position incumbents who become disabled, must be able to perform the essential functions (as listed) either unaided or with the assistance of a reasonable accommodation to be determined by management on an individual basis.