Data Engineer

FalconSmartIT; Pittsburgh (Allegheny County); On-site; USD 120,000 - 160,000; Full time

Job summary

FalconSmartIT is seeking a Data Engineer in Pittsburgh, onsite, with 5+ years of experience to design and implement scalable data pipelines and data warehouse solutions using Snowflake. You will optimize workloads, develop complex SQL, and collaborate with analysts, data scientists, and business teams to deliver reliable data platforms.

Proficiency in Python, ETL/ELT, and cloud services (AWS/Azure/GCP) is required, along with Git, CI/CD, Airflow, dbt, and Spark/PySpark knowledge.

Qualifications

• 5+ years of experience in Data Engineering.
• Strong hands-on experience with Snowflake.
• Advanced SQL skills.
• Strong experience with Python and ETL/ELT.
• Good understanding of data warehousing and data modelling.
• Experience with AWS, Azure, or GCP.
• Experience with Git and CI/CD practices.
• Experience with Airflow, dbt, Azure Data Factory, or AWS Glue.
• Knowledge of Spark/PySpark.
• Exposure to Kafka, data governance, and data security.

Responsibilities

• Build scalable data pipelines and data warehouse solutions.
• Develop, optimize, and maintain complex SQL queries and Snowflake workloads.
• Integrate data from multiple sources and ensure data quality.
• Collaborate with analysts, data scientists, and business teams.
• Triage production data pipeline issues and ensure reliability.
• Follow best practices for code quality, testing, and version control.

Skills

Snowflake

SQL

Python

ETL/ELT

Airflow

dbt

Azure Data Factory

AWS Glue

Spark/PySpark

Kafka

data governance

data security

Git

CI/CD

data warehousing

data modelling

Tools

Snowflake

Airflow

dbt

Azure Data Factory

AWS Glue

Spark/PySpark

Kafka

Git

CI/CD

Job description

Job Title: Data EngineerLocation: Pittsburgh, PA (Onsite)Job Type C2CJob Description:We are looking for a Data Engineer with 5+ years of experience and strong hands-on expertise in Snowflake, SQL, Python, and ETL/ELT. The candidate will be responsible for building scalable data pipelines, data warehouse solutions, and reliable data platforms. Design, develop, and maintain scalable ETL/ELT data pipelines.Develop and optimize complex SQL queries and Snowflake workloads Build data warehouse solutions and data models using Snowflake. Integrate data from multiple sources and implement data quality and validation processes.Optimize Snowflake performance and cloud infrastructure costs. Troubleshoot production data pipeline issues and ensure data reliability.Collaborate with analysts, data scientists, and business teams to deliver data solutions.Follow best practices for code quality, testing, version control, and documentation.5+ years of experience in Data Engineering. Strong hands-on experience with Snowflake.Advanced SQL skills.Strong experience with Python and ETL/ELT.Good understanding of data warehousing and data modelling.Experience with AWS, Azure, or GCP Experience with Git and CI/CD practices. Strong problem-solving and communication skills.Experience with Airflow, dbt, Azure Data Factory, or AWS Glue Knowledge of Spark/PySpark.Experience with Snowflake Streams, Tasks, Snow pipe, Dynamic Tables, or Snowpark Exposure to Kafka, data governance, and data security Work Experience 7-10Years