Lead Analytics Engineer

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

• 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.

Tuition reimbursement, Employee stock purchase plan, Prescription drug insurance, Parental leave, Health insurance, 401(k) matching, Paid time off, Vision insurance, Mid Penn Bank offers a comprehensive benefits package to those who qualify. This includes 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, and tuition reimbursement.

In addition, all employees are eligible to participate in mentorship programs, receive individualized development and career counseling, and participate in Mid Penn University courses and development programs.

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.