Lead Analytics Engineer - Snowflake Data Architect

Mid Penn Bank; Harrisburg (Dauphin County); On-site; USD 110,000 - 160,000; Full time

Benefits offered by this job

Medical plans with prescription drug

401(k) with employer match

Paid time off

Tuition reimbursement

Mentorship programs

Career development programs

Job summary

Mid Penn Bank is seeking a Lead Analytics Engineer to design, implement, and optimize data strategies across platforms with a focus on integrity, governance, and efficient pipelines. This role is onsite in Wyomissing or Harrisburg, PA and partners with leadership, security, and risk teams.

The ideal candidate blends SQL and Python expertise with Snowflake/cloud experience, drives reporting solutions, and leads data initiatives to support business decisions.

Qualifications

• BS/BA in business administration, data science, information science, or related field.
• 3+ years of relevant experience.
• Strong expertise with Snowflake architecture and cloud data best practices.
• Hands-on experience migrating data workflows to Snowflake or cloud-native platforms.
• Solid SQL and Python for data analysis and automation.

Responsibilities

• Design, implement and optimize scalable data models and pipelines.
• Lead data governance initiatives and collaborate with cross-functional teams.
• Develop reporting solutions for multiple business units.
• Ensure data integrity and compliance.

Skills

Leadership

Planning

Team building

Project management

SQL

Python

Data analysis

Communication

Education

Bachelor's degree in business administration, data science, information science or related field

Tools

Snowflake

Azure

dbt Core/Cloud

Job description

Mid Penn Bank is seeking a Lead Analytics Engineer to design, implement, and optimize data strategies across platforms with a focus on integrity, governance, and efficient pipelines. This role is onsite in Wyomissing or Harrisburg, PA and partners with leadership, security, and risk teams.

The ideal candidate blends SQL and Python expertise with Snowflake/cloud experience, drives reporting solutions, and leads data initiatives to support business decisions.