VP Enterprise Data Engineer

Job Purpose

The Enterprise Data Engineer will solution, build, and operate scalable, governed data pipelines and analytics-ready data products on the enterprise data platform. This role is a core contributor to our modern data architecture, leveraging Snowflake, ELT tools (Fivetran/Informatica/SSIS), dbt/SQL-driven transformations with medallion architecture patterns (Bronze / Silver / Gold) to deliver trusted, reusable data assets across the organization.

Job Duties

• Design, build, and maintain enterprise-grade ELT pipelines using Fivetran, Informatica or similar tool to ingest data from operational systems into Snowflake.
• Implement and operate a medallion architecture (Bronze, Silver, Gold) that supports data lineage, quality enforcement, and scalable consumption.
• Develop SQL-based transformations using dbt, Snowflake stored procedures, and views to standardize, conform, and enrich data.
• Create and maintain analytics-ready data models that support BI, reporting, and downstream data products.
• Embed data quality checks, audit columns, and metadata into pipelines to support traceability and compliance.
• Partner with data governance and security teams to implement role-based access controls, masking, and least-privilege access patterns in Snowflake.
• Monitor pipeline health, performance, and cost efficiency; proactively resolve failures and optimize workloads.
• Work closely with domain SMEs, analytics teams, and others to translate business requirements into scalable data solutions.
• Contribute to shared engineering standards, reusable frameworks, and documentation to improve consistency and delivery velocity.
• Support a data-product mindset, enabling teams to consume trusted data without rebuilding logic.
• Perform special projects as assigned.

Education, Job Skills and Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Business Administration, or related field preferred.
• 5+ years of experience in data engineering, analytics engineering, or related roles.
• Strong proficiency in SQL for data transformation, modeling, and performance optimization.
• Experience with ELT/ETL tools such as Fivetran and/or Informatica.
• Experience working in regulated or enterprise environments (financial services, healthcare, etc.).
• Knowledge of cloud storage and integration patterns (e.g., Azure Blob, cloud landing zones).
• Experience with CI/CD for data pipelines and version control (Git-based workflows).
• Understanding of cost optimization strategies in Snowflake.
• Hands-on experience with Snowflake as a primary data warehouse.
• Practical experience implementing medallion or layered data architectures.
• Experience with dbt and/or Snowflake stored procedures for transformation orchestration.
• Familiarity with data quality concepts, pipeline monitoring, and production support.
• Exposure to data governance, metadata management, or lineage tooling.
• Ability to prioritize meeting project and strategic objectives deadlines.

Basic Qualifications

• 5+ years of experience in data engineering, analytics engineering, or related roles.
• Strong proficiency in SQL for data transformation, modeling, and performance optimization.

Benefits

We offer a comprehensive benefits package including:

• 401(k) retirement plan with an employer match
• Employee stock purchase plan
• Variety of education assistance programs such as student loan and tuition paydown/reimbursement
• Paid vacation, holidays
• and much more.

For full details of our benefits offerings, please visit: peoplesbancorp.com/about-us/find-a-career