Lead Analytics Engineer

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. Position OverviewThe 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 organizations 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 ResponsibilitiesDesigns, 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 groups 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 & QualificationsA 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 TelephonePC/Computer keyboardMobile DevicesPrintersCalculatorFax machineCopy machine Pay TransparencyWe 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 candidates knowledge, skills, depth of work experience, and relevant licenses/credentials. The salary range may vary based on geographic location.

BenefitsMid 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. EEO StatementQualified 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 EmployerMinorities/Females/Veterans/Individuals with Disabilities/Sexual Orientation/Gender IdentitySponsorship StatementAs 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.