Data Engineer: Build Scalable Snowflake Pipelines

IntePros; Pittsburgh (Allegheny County); On-site; USD 90,000 - 120,000; Full time

Job summary

IntePros is seeking a Data Engineer to join our growing enterprise data team focused on building a modern data platform for analytics, reporting, and AI-driven solutions. The role centers on developing scalable data ingestion pipelines into Snowflake and delivering trusted data products for BI, APIs, and advanced analytics.

You will design and optimize Snowflake structures, transform large datasets with SQL, and ensure data quality and governance while collaborating with cross-functional teams

Qualifications

• Hands-on Snowflake data modeling, tables, views, and performance tuning.
• Advanced SQL for transforming and optimizing large datasets.
• Experience designing and supporting ETL/ELT pipelines.
• Experience with AWS S3 and API-based data integrations.
• Understanding of dimensional modeling and analytics-focused database design.
• Strong troubleshooting and data quality analysis skills.
• Experience working in Agile development environments.

Responsibilities

• Design, build, and maintain scalable ETL/ELT pipelines to ingest data from multiple sources into Snowflake using APIs, AWS S3, and batch processing.
• Transform raw data into curated, analytics-ready datasets and reusable data products for downstream consumers.
• Develop and optimize Snowflake tables, views, and SQL queries to improve performance and usability.
• Monitor and troubleshoot data pipelines to ensure reliability, accuracy, and timely delivery.
• Implement data validation, quality checks, and governance best practices.
• Collaborate with cross-functional teams to onboard new data sources and support reporting, analytics, and AI initiatives.
• Maintain scheduling and orchestration workflows while optimizing pipeline performance and cost.
• Participate in Agile ceremonies and contribute to continuous improvement of the data platform.

Skills

Snowflake

SQL

ETL/ELT pipelines

Agile development

Data quality analysis

Tools

AWS S3

APIs

Job description

IntePros is seeking a Data Engineer to join our growing enterprise data team focused on building a modern data platform for analytics, reporting, and AI-driven solutions. The role centers on developing scalable data ingestion pipelines into Snowflake and delivering trusted data products for BI, APIs, and advanced analytics.

You will design and optimize Snowflake structures, transform large datasets with SQL, and ensure data quality and governance while collaborating with cross-functional teams