WesBanco Bank, Inc. is seeking a Senior Data Engineer to play a critical role in designing, implementing, and maintaining the bank's enterprise data platform. The individual will develop scalable data pipelines, ensure data quality, and collaborate with stakeholders to advance enterprise data initiatives.
Responsibilities:
- Collaborates with ED&A Team to ensure alignment with enterprise data architecture standards
- Participates in cross-functional initiatives to ensure data availability and consistency across the enterprise
- Ensures data lineage and metadata are documented and maintained
- Designs, develops and maintains Snowflake database structures
- Designs, develops, and maintains ETL/ELT pipelines using Informatica, SQL, and Python
- Builds and maintains data models for reporting and analytics
- Partners with business analysts and finance, operations, and risk teams to understand data requirements and translate them into technical solutions
- Provides guidance to downstream teams on data consumption best practices
- Works with compliance teams to ensure regulatory and security requirements are met
- Mentors junior team members and provide knowledge sharing to elevate team capabilities
- Identifies opportunities to improve ETL processes, performance, and data quality
- Remains current with emerging data engineering technologies, tools, and best practices
- Drives awareness of responsible data use within business teams
Requirements:
- Bachelor's degree and minimum of 5 years of experience in data engineering, ETL development, and analytics-focused roles required or equivalent combination of education and experience
- Minimum of 3 years' experience with Informatica, Snowflake, DBT, SQL and Python Programming required
- Strong understanding of data modeling concepts (star schema, snowflake schema, SCD2) and best practices
- Strong understanding of data partitioning, indexing, and performance optimization
- Familiarity with data governance and compliance frameworks
- Proficiency in Microsoft Office Products including Excel, PowerPoint and Word
- Strong analytical, problem-solving, and debugging skills
- Excellent communication skills, with the ability to translate business requirements into technical solutions
- Strong attention to detail and commitment to data quality
- Ability to manage multiple priorities in a fast-paced environment
- Collaborative mindset with the ability to work across teams
- Proactive problem solver with a focus on scalable and maintainable solutions
- Degree in computer science, Information Systems, or related field
- Experience with API-based data ingestion and streaming platforms
- Experience in financial services or banking data environments