IT Lead Analytics Engineer - Harrisburg, PA

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

A great company begins with a great team! Mid Penn Bank is actively seeking Lead Analytics Engineer to join our team in Wyomissing or Harrisburg, PA.

We believe that our ongoing success depends upon a skilled, satisfied, and valued work force. As a member of our team, you can expect opportunities to develop your skills to help you excel in your role and achieve your professional career goals. We offer a comprehensive range of flexible benefits to support your personal and financial well-being. Our inclusive culture encourages all employees to share ideas, collaborate, and contribute to the values that make us a winning team for our customers, shareholders, and communities.

This position is 100% onsite in Wyomissing or Harrisburg, PA.

Position Overview

The Lead Analytics Engineer is responsible for designing, implementing and optimizing data strategies throughout various platforms, with a focus on data integrity, security and efficient pipelines. This individual plays a crucial role in ensuring that the organization's data is aligned with business needs and requirements of the company. The Lead Analytics Engineer assumes responsibility for leveraging data assets by designing robust solutions, ensuring integrity and adhering to governance frameworks.

Essential Duties and Responsibilities

• Designs, implements, and manages scalable data models and solutions using Snowflake, SQL, Azure, and other tools.
• Leads the migration of data from traditional relational databases, and other applications to Snowflake.
• Ensures data integrity and optimizes workflows within Snowflake.
• Collaborates with cross-functional teams to integrate data governance and science tools.
• Creates, implements, and maintains effective and relevant management reporting solutions for various business units.
• Establishes data-related goals and aligns them with business objectives.
• Suggests new information-based solutions to help drive efficiencies and informed decision-making.
• Designs and implements data collection and process improvements to improve the efficiency of the group's reporting and the quality of output provided to other stakeholders.
• Works with leadership, Information Security and Risk Management to develop data governance and best practice standards.
• Prepares departmental reporting based on metrics to identify trends and areas for improvement.
• Reports pertinent information to the immediate supervisor as requested, or according to an established schedule; compiles information as necessary or as directed and provides data to appropriate personnel.
• Maintains regulatory compliance and sound operating environments by writing, updating, and adhering to policy and procedures.
• Plays an active role in protecting the organization and its customers against fraud by incorporating risk awareness and prevention into daily responsibilities.

Education & Qualifications

• A B.S. or B.A. degree in business administration, data science, information science or related field; specialized financial services training preferred.
• A minimum of three (3) years of related experience normally required.
• Strong expertise with Snowflake architecture and best practices in cloud data.
• Hands‑on experience migrating data workflows to Snowflake or other cloud‑native platforms.
• Solid SQL and Python programming skills for data analysis and automation.
• Report writing experience using query and visualization tools.
• Familiarity with data governance principles and integration of governance/data science tools (dbt Core/Cloud experience).

Skill(s)

Leadership and planning; team building and coaching; advanced project management; proficient SQL and Python experience; advanced analytical skills, advanced reading, writing, grammar, and mathematics skills; excellent interpersonal relations and communicative skills; proficiency in analyzing, interpreting, and implementing strategy; proficient composition skills; competency with PC and software operations; ability to sit, stand, walk, bend, stoop, reach with hands or arms, use hands to manipulate objects, handle or feel, and lift items weighing 20 lbs. or less; visual, auditory, and speaking skills.

Equipment/Machines

• Telephone
• PC/Computer keyboard
• Mobile Devices
• Printers
• Calculator
• Fax machine
• Copy machine

Pay Transparency

We set standard salary ranges for our roles based on the position, function, and responsibilities, as benchmarked against similarly sized companies in our industry. Specific compensation offered will be determined based on a combination of factors including the candidate's knowledge, skills, depth of work experience, and relevant licenses/credentials. The salary range may vary based on geographic location.

Benefits

• medical plans with prescription drug coverage
• flexible spending account
• dental and vision insurance
• life insurance
• 401(k) program with employer match and employee stock purchase plan
• paid time off
• paid holidays
• disability insurance coverage
• parental leave
• employee assistance program
• tuition reimbursement
• mentorship programs
• individualized development and career counseling
• Mid Penn University courses and development programs

EEO Statement

Qualified applicants are considered without regard to race, color, age, sex, sexual orientation, gender identity, religion, national origin, genetic information, pregnancy, disability, or protected veteran status. We also comply with all applicable laws governing employment practices and do not discriminate on the basis of any unlawful criteria.

Equal Opportunity Employer-Minorities/Females/Veterans/Individuals with Disabilities/Sexual Orientation/Gender Identity

Sponsorship Statement

As a condition of employment, individuals must be authorized to work in the United States without sponsorship for a work visa by Mid Penn Bank currently or in the future.