Lead Analytics Engineer

Lead Analytics Engineer Mid Penn Bank - Millersburg Branch - 3.4 Wyomissing, PA Job Details Full-time 1 day ago Benefits Employee stock purchase plan Paid holidays Disability insurance Health insurance Dental insurance Flexible spending account Tuition reimbursement Paid time off Parental leave Employee assistance program Vision insurance 401(k) matching Life insurance Prescription drug insurance Qualifications Data model design Computer operation Data visualization software proficiency Azure SQL databases Cloud data warehouses Automation Data modeling projects Data migration Process optimization Relational databases Bachelor of Science Writing skills Regulatory compliance Process improvement Data reporting Scalable systems 3 years Compliance management implementation Snowflake Bachelor's degree in business administration Bachelor's degree in information science SQL Data quality management Team development Data Architecture Design (Architecture design skills) Analysis skills Policy & process development Math Data analytics Developing data pipelines Scalability Business Administration Fraud prevention and detection Cloud migration Senior level Cross-functional collaboration Business Project leadership Grammar Experience Leadership Bachelor of Arts Python Cross-functional communication Bachelor's degree in data science Data Science Full 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. 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 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. 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.