Data Warehouse Engineer

TEKsystems•Pittsburgh, PA
•$75 - $90•Remote

About The Position

WesBanco Bank is seeking an experienced Data Warehouse Engineer to support the development, administration, and optimization of enterprise data warehouse solutions in a Snowflake environment. The role focuses on designing scalable data models, developing and maintaining dbt transformations, administering Snowflake environments, and supporting business-critical reporting and analytics initiatives. The engineer will work cross-functionally with Data Engineering, BI, Analytics, Platform Administration, and Data Governance teams in a collaborative remote environment. The position is contract-to-hire and fully remote, with a requirement to reside on the East Coast.

Requirements

  • At least 5 years of advanced SQL development experience, including query optimization, performance tuning, and ETL/ELT development.
  • At least 5 years of experience working with enterprise data warehouse solutions.
  • At least 3 years of hands-on Snowflake administration experience.
  • At least 4 years of experience developing and maintaining dbt transformation frameworks.
  • At least 5 years of experience using Git-based version control tools such as GitHub, GitLab, or Bitbucket.
  • At least 5 years of experience supporting CI/CD pipelines and deployment automation using Azure DevOps, GitHub Actions, GitLab CI/CD, or similar tools.
  • Strong experience with dimensional data modeling, fact tables, and conformed dimensions.
  • Experience implementing data security controls, including RBAC and masking policies.
  • Strong troubleshooting, analytical, and problem-solving skills.
  • Ability to work independently in a highly collaborative remote environment.
  • Must reside on the East Coast.

Nice To Haves

  • Experience in the banking or financial services industry.
  • Experience with Informatica IDMC or other Informatica products.
  • Experience with SAP BusinessObjects / Web Intelligence.
  • Hands-on experience with Power BI and Qlik.
  • Familiarity with data governance, data quality, and compliance initiatives.
  • Experience supporting enterprise reporting and analytics platforms.
  • Ability to serve as a hands-on technical SME in a fast-paced environment.

Responsibilities

  • Design, develop, and maintain enterprise data warehouse solutions using Snowflake.
  • Build and support dimensional data models, including fact tables, conformed dimensions, and semantic views.
  • Develop, test, and optimize SQL transformations and ELT processes within Snowflake.
  • Create and maintain dbt models, tests, and documentation for scalable and reliable data pipelines.
  • Implement and support Snowflake Tasks, Streams, Stored Procedures, and workflow automation.
  • Perform unit testing, integration testing, and deployment validation.
  • Administer Snowflake security, including RBAC, row-level security, masking policies, and object permissions.
  • Monitor and optimize Snowflake performance, warehouse utilization, storage consumption, and cost governance.
  • Manage source control and deployments through Git-based version control systems.
  • Support CI/CD processes, release management, and deployment automation.
  • Collaborate with Data Engineers, BI teams, Platform Administrators, and Data Governance teams on enterprise reporting and analytics solutions.
  • Troubleshoot and resolve production issues while maintaining platform stability and reliability.

Benefits

  • Medical insurance
  • Dental insurance
  • Vision insurance
  • Critical Illness, Accident, and Hospital coverage
  • 401(k) retirement plan, with pre-tax and Roth post-tax contributions available
  • Voluntary life and AD&D insurance for the employee and dependents
  • Short- and long-term disability
  • Health Spending Account (HSA)
  • Transportation benefits
  • Employee Assistance Program
  • Time off/leave, including PTO, vacation, or sick leave (subject to eligibility and applicable terms)
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service