Job Title:Data Warehouse EngineerCompany: TEKsystemsLocation: Remote (Must reside on the East Coast)Contract-to-Hire Job Description OverviewWesBanco 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. Key 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 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.
Required Qualifications
- 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.
Preferred Qualifications
- 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.
Job Type & LocationThis is a Contract to Hire position based out of Pittsburgh, PA. Pay and BenefitsThe pay range for this position is $75.00 - $90.00/hr. 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.Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits
available for this temporary role may include the following:
Medical, dental & vision Critical Illness, Accident, and Hospital 401(k) Retirement Plan Pre-tax and Roth post-tax contributions available Life Insurance (Voluntary Life & AD&D for the employee and dependents) Short and long-term disability Health Spending Account (HSA) Transportation benefits Employee Assistance Program Time Off/Leave (PTO, Vacation or Sick Leave) Job Type & LocationThis is a Contract to Hire position based out of Pittsburgh, PA. Application DeadlineThis position is anticipated to close on Nov 27, 2026. Workplace TypeThis is a fully remote position.
About TEKsystems
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.
The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
About TEKsystems and TEKsystems Global Services
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.
The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
San Francisco Fair Chance Ordinance: Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records.
Massachusetts Lie Detector: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.
Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools.