Data Engineer III

Orrstown Bank•Harrisburg, PA

About The Position

The Data Engineer III is responsible for designing, developing, and maintaining the bank's data infrastructure and systems. This position involves leading the implementation of scalable and robust data solutions, ensuring data quality, security, and compliance. The Data Engineer III will provide technical leadership, collaborate with cross-functional teams, and drive innovation in data engineering practices to support the bank's strategic objectives.

Requirements

Bachelor's degree in Computer Science, Information Systems, or a related field.
Proven experience as a Data Engineer, 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)
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

Nice To Haves

A master's degree is preferred.

Responsibilities

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, and 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.