DATA ENGINEER

*This is an onsite position with no relocation assistance provided*

As a Data Engineer, your day will be filled with opportunities to support the banks data analytics initiatives. The selected candidate will work closely with data analysts, data scientists, and key stakeholders across the bank to design, develop, and maintain scalable data pipelines and infrastructure. This role involves designing and implementing ETL processes, ensuring data quality and integrity, and developing robust data models to support comprehensive reporting and analytics needs. The ideal candidate will have a strong technical background in data engineering, experience with various database architectures and ETL tools, and a passion for leveraging data to drive business value.

Responsibilities

Daily responsibilities include, but are not limited to, the following:

• Design, develop, and maintain scalable data pipelines to support the bank's data analytics initiatives
• Implement and optimize ETL processes to ensure efficient data flow and integration from various sources, including APIs, SFTP, cloud and on-prem systems
• Collaborate and communicate effectively with analysts and business stakeholders to empower self-service analytics, facilitate the discovery of insights, and create intuitive visual representations of data
• Develop and maintain data models to support reporting, analytics, and data visualization needs
• Developing and implementing data security measures to protect sensitive information
• Ensure data quality and integrity by implementing data governance practices, including data validation, cleansing, and classification
• Monitor and troubleshoot data pipeline performance to ensure reliability, efficiency and cost optimization
• Maintain healthy code repositories and leverage source control systems (e.g., Git) to ensure efficient version management, seamless collaboration, and adherence to best practices in code management
• Develop and maintain an understanding of the banks data sources and how they can be used to provide business value for the bank
• Stay up to date with emerging technologies and industry trends to drive innovation and maintain a competitive edge in data engineering
• Develop and maintain documentation for data pipelines, processes, and data models

Job Requirements

The successful candidate will have the following qualifications:

• Bachelors degree in Data Analytics, Statistics, Mathematics, Computer Science, Business Administration or related field
• 5+ years of experience working in an analytics/data engineering role
• Track record of success in developing and deploying creative insights, services and solutions that drove increased business value
• Financial services background is a plus
• 3+ years working on maintaining databases with a focus on improving data ingestion pipelines
• Expertise in designing and implementing star schema dimensional models, establishing a single source of truth for analytical reporting, dashboards and insights discovery
• Experience with various database architectures (e.g. SQL Server, Snowflake, Databricks, Azure)
• Experience with various visualization solutions (e.g. Tableau, PowerBI, Sigma, MicroStrategy)
• Experience with various ETL and orchestration solutions (e.g. Informatica, Fivetran, DBT, Matillion)
• Proficient in writing advanced SQL to handle complex data transformations
• Motivated, self-starter
• Track record of working autonomously with organizational and time management skills
• Proven ability to manage multiple projects simultaneously while maintaining high standards of quality and meeting deadlines
• Enjoy supporting team members by sharing technical knowledge and helping solve problems
• Ability to develop and follow documented policies and procedures to ensure proper compliance
• Strong technical acumen and decision-making skills
• Strong problem-solving skills with the ability to troubleshoot and resolve complex technical issues efficiently
• Exhibit a professional appearance and demeanor
• Ability to work flexible work schedules, after-hours as required
• Professional verbal and written communication skills
• Ability to use the Microsoft Office M365 suite of products

Benefits

• 401(k) with a company match of up to 6%
• ESOP employer match
• Medical insurance
• Dental insurance
• Vision insurance
• Cancer / Disease insurance
• Accident insurance
• Flexible Spending Accounts
• Health Savings Accounts
• Bank paid Life / AD& D insurance
• Voluntary Life / AD&D insurance
• Bank paid Short-Term and Long-Term Disability insurance
• Employee Stock Purchase Plan
• Employee Assistance Program

Physical Requirements

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to sit; use hands and fingers, handle or feel, reach with hands and arms, and talk or hear. The employee is frequently required to stand and walk. Must be able to lift up to 15 pounds.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractors legal duty to furnish information. 41 CFR 60-1.35(c)