Data Engineer Lead

Overview

Hybrid
Depends on Experience
Contract - W2
Contract - 12 Month(s)

Skills

PL/SQL
Snowflake
Snow Flake Schema

Job Details

Role: Data Engineer Lead

Locations: Pittsburgh, PA (Hybrid)

Duration: 12+ Months Contract

Note: Candidate needs to be in the office 3-4 Days every week.

Primary Skills:

  • Must have skills Snowflake
  • Good to have skills PLSQL

Job Description:

  • Data Engineer with deep expertise in DBT Data Build Tool Snowflake and PLSQL to join our growing data team
  • Person will be responsible for designing developing and maintaining robust data transformation pipelines that support business intelligence analytics and data science initiatives

Key Responsibilities:

  • Design and implement scalable data models and transformation pipelines using DBT on Snowflake
  • Write efficient and maintainable PLSQL code for complex data processing and transformation tasks
  • Collaborate with data analysts data scientists and business stakeholders to understand data requirements and deliver high quality solutions
  • Optimize Snowflake performance through query tuning clustering and resource management
  • Ensure data quality integrity and governance through testing documentation and monitoring
  • Participate in code reviews architecture discussions and continuous improvement initiatives
  • Maintain and enhance CICD pipelines for DBT projects

Required Qualifications:

  • 3 years of experience in leading data engineering team
  • Strong hands-on experience with DBT modular SQL development testing documentation
  • Proficiency in Snowflake data warehousing performance tuning security
  • Advanced knowledge of PLSQL and experience with stored procedures functions and packages
  • Solid understanding of data modeling concepts star snowflake schemas normalization
  • Experience with version control systems eg Git and CICD practices
  • Familiarity with orchestration tools E.g., Airflow dbt Cloud Prefect is a plus
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.