Data Engineer

Organizational Duties And Responsibilities

• Supports the mission, vision and philosophy of the bank.
• Complies willingly with all organizational policies and procedures.
• Supports all functions that maintain compliance with regulatory agencies.

Essential Duties And Responsibilities

• 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.
• 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 bank’s 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.

Working Conditions

• Primarily sedentary work performed in an office environment.
• Frequent use of hands and fingers to operate a computer, keyboard, mouse, and other office equipment.
• Frequent use of eyes to read computer screens, printed documents, and financial data.
• Occasional standing, walking, bending, or reaching.
• Occasional lifting and carrying up to 10–15 pounds occasionally (e.g., files, office supplies).

Education

• Bachelor’s degree in Data Analytics, Statistics, Mathematics, Computer Science, Business Administration or related field.

Experience

• 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).
• Proficiency in writing advanced SQL to handle complex data transformations.

Skills

• Motivated, self-starter.
• Proven ability to manage multiple projects simultaneously while maintaining high standards of quality and meeting deadlines.
• 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.
• Able to work flexible work schedules, after-hours as required.
• Professional verbal and written communication skills.
• Able 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.
• Flexible Savings 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.