> Markdown version of [/jobs/ext/4785673-data-warehouse-engineer](https://www.wearedevelopers.com/jobs/ext/4785673-data-warehouse-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Warehouse Engineer - **Company:** TEKSYSTEMS INC. - **Location:** Pittsburgh, PA, United States (Remote available) - **Experience:** Experienced - **Salary:** $156,000 - $187,200 - **Contract:** Temporary to permanent - **Skills:** Business Analytics Applications, Data Analysis, Unit Testing, Microsoft Azure, Continuous Integration, Information Engineering, Data Governance, Extract Transform Load (ETL), Data Security, Data Warehousing, Github, Revision Control Systems, Performance Tuning, Query Optimization, Role-Based Access Control, Release Management, Power BI, SQL Stored Procedures, SQL Databases, Web Intelligence, Snowflake, Software Troubleshooting, Sap Business Objects, Gitlab, Git, Gitlab-ci, Integration Tests, Deployment Automation, Qlikview, Bitbucket, Software Version Control, Data Pipelines - **Published:** November 19, 2026 - **Apply:** https://www.careercircle.com/jobs/all/all/usa/pa/pittsburgh/4ce7dde3-e6e5-4699-b2ad-216fac0c2174 ## About the Role * 5+ years of advanced SQL development experience, including query optimization, performance tuning, and ETL/ELT development. * 5+ years of experience working with enterprise data warehouse solutions. * 3+ years of hands-on Snowflake administration experience. * 4+ years of experience developing and maintaining dbt transformation frameworks. * 5+ years of experience utilizing Git-based version control tools such as GitHub, GitLab, or Bitbucket. * 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., * Experience within 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., Individual compensation offered for this position within this range will depend on many factors, including qualifications, skills, relevant experience, job knowledge, geographic location, internal equity, and other pertinent job-related factors. ## Description CI/CD Gitlab Github Power BI Operations Leadership Automation Warehousing Scalability Informatica Data Quality Unit Testing Azure DevOps GitLab CI/CD Data Security Data Modeling Version Control Problem Solving Data Governance Data Warehousing Data Engineering Stored Procedure Performance Tuning Release Management Business Valuation Financial Services Query Optimization Scalability Design Workflow Management Integration Testing SAP BusinessObjects Business Intelligence Full Stack Development Business Transformation SQL (Programming Language) Snowflake (Data Warehouse) Git (Version Control System) Extract Transform Load (ETL) Role-Based Access Control (RBAC) Troubleshooting (Problem Solving), WesBanco Bank is seeking an experienced Data Warehouse Engineer to support the development, administration, and optimization of enterprise data warehouse solutions within a Snowflake environment. This role will focus on designing scalable data models, developing and maintaining dbt transformations, administering Snowflake environments, and supporting business-critical reporting and analytics initiatives. The ideal candidate will have strong expertise in Snowflake, SQL, dbt, Git, and CI/CD deployment practices, with the ability to work cross-functionally across Data Engineering, BI, Analytics, and Data Governance teams., * 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 to support scalable and reliable data pipelines. * Implement and support Snowflake Tasks, Streams, Stored Procedures, and workflow automation. * Perform unit testing, integration testing, and deployment validation activities. * 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 to support enterprise reporting and analytics solutions. * Troubleshoot and resolve production issues while ensuring platform stability and reliability.