Data Warehouse Engineer

TEKSYSTEMS INC.
Pittsburgh, PA, United States
3 days ago
Apply on www.careercircle.com
Prepare application

Role details

Contract type
Temporary to permanent
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Compensation
$156,000 - $187,200
Working hours
Regular working hours

Tech stack

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
+20 more
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

Job 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.

Requirements

  • 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.

About the company

We’re partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That’s the power of true partnership. TEKsystems is an Allegis Group company., Were a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. Were a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. Were strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. Were building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careercircle.com
Prepare application

Good distractions

Loading talks and stories from around this role…