Data Engineer

FalconSmartIT; Dover (DE); On-site; USD 100,000 - 140,000; Part time

Job summary

FalconSmartIT is seeking a Data Engineer in Pittsburgh, PA for an onsite role. The candidate will design, develop, and maintain scalable ETL/ELT data pipelines and data warehouses using Snowflake, SQL, and Python.

They will optimize Snowflake workloads, manage cloud infrastructure costs, and ensure data quality across multiple sources. Collaboration with analysts, data scientists, and business teams is essential, with adherence to CI/CD and code quality practices.

Qualifications

• 5+ years of experience in Data Engineering with hands-on Snowflake, SQL, Python, and ETL/ELT.
• Build scalable data pipelines, data warehouse solutions, and reliable data platforms.
• Design, develop, and maintain scalable ETL/ELT pipelines.
• Experience with cloud platforms (AWS/Azure/GCP) and data governance.

Responsibilities

• Develop and optimize SQL queries and Snowflake workloads.
• Build data warehouse models and data pipelines in Snowflake.
• Integrate data from multiple sources and ensure data quality.
• Collaborate with analysts, data scientists, and business teams.
• Follow best practices for code quality, testing, version control, and documentation.

Skills

Snowflake

SQL

Python

ETL/ELT

Data Warehousing

Data Modelling

AWS

Azure

GCP

Git

CI/CD

Airflow

dbt

Spark/PySpark

Kafka

Data Governance

Tools

Airflow

dbt

Azure Data Factory

AWS Glue

Git

CI/CD

Snowflake

Spark

Job description

Job Title: Data Engineer

Location: Pittsburgh, PA (Onsite)

Job Type C2C

Job 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