Data Engineering Team Leader

Orrstown Bank; Towson (MD); On-site; USD 110,000 - 190,000; Full time

Job summary

Orrstown Bank seeks a Data Engineering Team Leader to design, deploy, and optimize the bank's data infrastructure, including pipelines, databases, and warehouses. You will architect ETL processes, collaborate with data scientists and business stakeholders, and drive governance, quality, and security across data assets.

You will mentor junior engineers, stay ahead of industry trends, and ensure scalable, reliable data platforms that support analytics and reporting needs.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field; master's preferred.
• 7+ years in systems engineering with data solutions, banking/financial industry preferred.
• Strong SQL and relational DB experience (Oracle, SQL Server, MySQL).
• Proficiency in Python, Java, or Scala.
• Knowledge of data engineering, ETL, data integration, and data governance.
• Experience with Hadoop/Spark and cloud data services.
• Ability to lead and mentor a data engineering team.

Responsibilities

• Lead design, deployment, maintenance, and support of data infrastructure (pipelines, databases, data warehouses).
• Architect and optimize ETL processes for diverse data sources.
• Collaborate with data scientists, analysts, and stakeholders for scalable data solutions.
• Enforce data governance, quality, security, and regulatory compliance.
• Perform advanced data modeling and database design for storage and retrieval.
• Lead performance tuning for scalability, reliability, and throughput.
• Stay current with data engineering trends and technologies.
• Provide mentorship and guidance to junior data engineers.
• Coordinate with IT to ensure integration with existing infrastructure.

Skills

SQL

Python

Java/Scala

Data modeling

Leadership

Education

Bachelor's degree in CS/IS or related field

Master's degree preferred

Tools

Oracle

SQL Server

MySQL

Hadoop/Spark

Airflow

Azure/AWS/Google Cloud

Snowflake/Redshift/BigQuery

Job description

The Data Engineering Team Leader is responsible for innovating, operating, influencing, and delivering systems architectures in support of our business. This position helps shape the technology strategy and alignment with corporate strategic goals. Responsibilities include (1) managing all aspects of system design, deployment, maintenance, and support for all systems within area of responsibility, (2) recruit, retain, and develop an exceptional systems engineering team, (3) create and refine operational processes to ensure effective security and compliance, (4) strengthen user experiences, service levels, and business relationships. The Data Engineering Team Leader will provide technical leadership, collaborate with cross-functional teams, and drive innovation in data engineering practices to support the bank's strategic objectives.

Qualifications:

• Bachelor's degree in Computer Science, Information Systems, or a related field. A master's degree is preferred.
• Minimum of seven years of systems engineering experience, with a focus on designing and implementing complex data solutions, preferably in the banking or financial industry.
• Strong proficiency in SQL and experience with various relational databases (e.g., Oracle, SQL Server, MySQL) and related technologies.
• Expertise in programming languages such as Python, Java, or Scala.
• Solid understanding of data engineering concepts, techniques, and best practices.
• Experience with big data technologies such as Hadoop, Spark, or similar frameworks.
• In-depth knowledge of data integration, ETL processes, and data transformation techniques.
• Proficiency in data modeling and database design principles.
• Strong familiarity with cloud platforms like AWS, Azure, or Google Cloud, including relevant data services (e.g., Snowflake, Redshift, BigQuery).
• Deep understanding of data governance, data quality, and data security practices, including regulatory compliance requirements.
• Experience with data pipeline orchestration tools (e.g., Apache Airflow, Azure Data Factory, Qlik Talend)
• Strong problem-solving and analytical skills.
• Excellent communication and collaboration skills.
• Ability to lead and mentor a team of data engineers.
• Strong organizational and project management abilities.
• Ability to adapt to changing technologies and work effectively in a dynamic environment.
• Maintains high standards of personal integrity and accountability

Core Competencies:

Career Development: Proactively prepares and actively participates in ongoing, candid, constructive monthly Coaching sessions with supervisor. Seeks advancement into challenging and developmental roles and assignments. Sets and meets clear, measurable goals.

Communicates Effectively: Demonstrates the ability to effectively communicate with all employees and clients, regardless of level. Communicates clearly, concisely, with candor and confidence. Writes, speaks and listens to disseminate and receive information effectively and accurately. Seeks to understand the viewpoints of others. Keeps others informed in a timely manner.

Focuses on the Client: Anticipates and identifies internal and external client needs. Takes action to meet and, where possible, exceed client expectations. Plans and organizes work effectively to facilitate responsiveness to client and meet deadlines.

Judgment: Demonstrates sound reasoning and well-balanced thinking. Balances the need for action with the need for analysis. Incorporates strategic thinking skills into practice by examining facts. Shows an ability to problem solve complex issues. Probes beyond symptoms to determine the underlying cause. Learns from and accepts responsibility from mistakes.

Teamwork: Demonstrates the ability to enhance the department and Orrstown Banks development through participation. Holds self and others accountable for exceeding departmental and corporate goals. Develops strong working relationships throughout the organization. Appropriately voices opinions, even if they are contrary to the consensus of the team. Initiates and develops positive working relationships with others in a way that builds bridges across boundaries and breaks down silos. Relates to others in an open and accepting manner that creates trust, respect and a collaborative environment.

• Lead the design, development, and maintenance of the bank's data infrastructure, including data pipelines, databases, and data warehouses.
• Architect and optimize ETL processes to ensure efficient extraction, transformation, and loading of data from diverse sources into the bank's data storage systems.
• Collaborate with data scientists, analysts, and business stakeholders to understand data requirements and design scalable data solutions that support advanced analytics and reporting needs.
• Implement and enforce data governance policies, ensuring data quality, consistency, security and compliance with regulatory requirements.
• Perform advanced data modeling and database design activities, optimizing data structures for integration, storage and retrieval.
• Lead performance tuning and optimization efforts to enhance data engineering systems' scalability reliability and throughput.
• Stay abreast of emerging technologies, industry trends, best practices in data engineering, and make recommendations for their application within the bank's environment.
• Provide technical leadership, guidance, and mentorship to junior data engineers, fostering a culture of continuous learning and professional development.
• Collaborate with IT teams to ensure seamless integration of data engineering solutions with existing infrastructure and applications.
• Document data engineering processes, workflows, configurations, and system architectures.

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 job. 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 to finger, handle or feel, reach with hands and arms, and talk or hear. The employee is frequently required to stand and walk. The employee may occasionally lift and/or move up to 10 pounds. Ability to reach destinations within the Orrstown footprint at all times is required.Ability to work and report to the employer’s physical work location(s).

Work is performed in an office setting with little to moderate exposure to noise, heat, dust or other adverse factors. Working extended hours may be required as needed. The noise level in the work environment is usually quiet.