SUMMARY:
The Data Engineer will play a critical role in designing, implementing, and maintaining the bank’s enterprise data platform. This individual will develop scalable, reliable, and high-performance data pipelines, ensure data quality and integrity, and drive Data Engineering initiatives across the organization. They will collaborate closely with stakeholders across the Enterprise Data & Analytics (ED&A) team to support, manage, and advance our enterprise data initiatives.
ESSENTIAL DUTIES AND RESPONSIBILITIES:
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Business Engagement & Impact
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.
Technical Execution
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.
Platform & Strategy Alignment
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.
Collaboration & Enablement
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.
Ethics & Responsible AI
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.
OTHER REQUIREMENTS:
Banking is a highly regulated industry and you will be expected to acquire and maintain a proficiency in the Bank's policies and procedures, and adhere to all laws, rules and regulations that are applicable to your conduct and the work you will be performing. You will also be expected to complete all assigned compliance training in a timely manner.
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.
Preferred QualificationsBachelor'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. Degree in computer science, Information Systems, or related field, preferred.
Minimum of 3 years’ experience with Informatica, Snowflake, DBT, SQL and Python Programming, required.
Experience with API-based data ingestion and streaming platforms preferred.
Experience in financial services or banking data environments, preferred.
Top Skills
What We Do
Founded in 1870, WesBanco, Inc. (www.wesbanco.com) is a diversified and balanced financial services company that delivers large bank capabilities with a community bank feel. Our distinct long-term growth strategies are built upon unique sustainable advantages permitting us to span eight states with meaningful market share. Built upon our ‘Better Banking Pledge’, our customer-centric service culture is focused on growing long-term relationships by pledging to serve all personal and business customer needs efficiently and effectively. In addition to a full range of online and mobile banking options and a full-suite of commercial products and services, WesBanco provides trust, wealth management, securities brokerage, and private banking services through our century-old Trust and Investment Services department. WesBanco's banking subsidiary, WesBanco Bank, Inc., operates branches and offices in eight states Additionally, WesBanco operates an insurance agency, WesBanco Insurance Services, Inc., and a full service broker/dealer, WesBanco Securities, Inc.
