Job Description
Job Title: Data Engineer – Snowflake & Azure Data Factory
Overview:
We are seeking a skilled Data Engineer with expertise in Snowflake and Azure Data Factory (ADF) to design, build, and optimize modern data pipelines and cloud-based data solutions. The ideal candidate will have hands-on experience working with large-scale datasets, data integration, ETL/ELT processes, and cloud technologies to enable reliable, scalable, and secure data flows across the organization.
Key Responsibilities:
Design, develop, and maintain data pipelines and workflows using Azure Data Factory to ingest, transform, and load data from multiple sources.
Build and optimize data models and warehouses in Snowflake to support analytics, reporting, and data science needs.
Implement ETL/ELT processes ensuring high-quality, reliable, and performant data integration.
Collaborate with business analysts, data scientists, and other stakeholders to understand requirements and deliver data solutions.
Monitor and optimize pipeline performance , troubleshoot failures, and ensure data accuracy.
Apply best practices in data security, governance, and compliance.
Work with structured, semi-structured, and unstructured data (JSON, Parquet, Avro, etc.).
Automate workflows, version control, and CI/CD deployment of data solutions.
Document technical designs, data flow diagrams, and metadata for ongoing support.
Qualifications:
Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or related field (or equivalent experience).
3+ years of professional experience as a Data Engineer or similar role.
Strong expertise in Snowflake (data modeling, performance tuning, query optimization).
Hands-on experience with Azure Data Factory (pipeline creation, orchestration, scheduling, monitoring).
Proficiency in SQL and scripting languages (Python, Scala, or similar).
Experience with Azure ecosystem (Azure SQL DB, Data Lake, Synapse, Key Vault, etc.).
Knowledge of data integration best practices , error handling, and logging frameworks.
Familiarity with DevOps practices , Git, and CI/CD for data pipelines.
Understanding of data governance, security, and compliance standards.
Preferred Skills:
Experience with Databricks, Azure Synapse, or Power BI.
Knowledge of streaming technologies (Kafka, Event Hubs, etc.).
Exposure to machine learning pipelines and data science workflows.
Why Join Us?
Work on cutting-edge cloud data platforms.
Collaborate with a highly skilled data & analytics team.
Opportunity to shape and scale enterprise-level data engineering solutions.
Company Description
Impact Consulting Solutions, Inc. is an Information Technology consulting and full time Placement Company located in the Pittsburgh area. Our clients range from small local businesses to Fortune 500 Corporations.
We work with a selected number of clients and service their entire business staffing requirements including:
consulting and project work
full-time placements
from Consultant level all the way to Director and Partner level.
Exciting opportunities currently exist for Information Systems professionals. If you are looking for career advancement, new technologies, and the money you deserve, we are the firm for you. We take pride in our ability to match the individual with the right job. Our promise is to provide you with the best financial and career opportunities available
Impact Consulting Solutions, Inc. is an Information Technology consulting and full time Placement Company located in the Pittsburgh area. Our clients range from small local businesses to Fortune 500 Corporations.\r\n\r\n\r\nWe work with a selected number of clients and service their entire business staffing requirements including:\r\n\r\nconsulting and project work\r\nfull-time placements\r\nfrom Consultant level all the way to Director and Partner level.\r\n\r\nExciting opportunities currently exist for Information Systems professionals. If you are looking for career advancement, new technologies, and the money you deserve, we are the firm for you. We take pride in our ability to match the individual with the right job. Our promise is to provide you with the best financial and career opportunities available