Data Engineer – Snowflake Data Ingestion & Data Products (ECC Platform) - W2 Position

VTekis Consulting LLP•Pittsburgh, PA

14d

About The Position

We provide Recruitment and Staffing services to many industries and domain through our innovative and customized solutions and passionate commitment to research. Ability to understand the hiring strategies, availability of talent and compensation benchmarking makes us proud hiring partner for various industries. We work as trusted business partners and always strive to deliver the most value and highest return on investment for our clients. We are highly trained business professionals with strong understanding of clients need. We work closely with the leading staffing trade associations, training, and research organizations to ensure we are knowledgeable of thustry trends and technologies.

Requirements

Strong hands-on experience with Snowflake (tables, views, performance tuning)
Advanced SQL skills and data transformation expertise
Experience building data ingestion pipelines (ETL/ELT)
Experience working with cloud storage (e.g., AWS S3) and data integration patterns
Understanding of data modeling for analytics (star schema, dimensional models)
Experience with API-based ingestion and/or file-based ingestion pipelines
Strong troubleshooting and data quality analysis skills
Experience working in Agile POD/team environments

Responsibilities

Design and build scalable data pipelines to ingest data from multiple sources into Snowflake (via AWS S3 or APIs)
Support ingestion patterns including batch loads, API-based ingestion, and near real-time streaming where applicable
Standardize ingestion into RAW data layers in Snowflake SPN
Partner with upstream teams (Core Tech, WFM, external vendors) to onboard new data sources
Monitor ingestion jobs and resolve failures, latency, or data completeness issues
Design and develop Snowflake views (curated & consumption layers) aligned with business requirements
Transform RAW data into domain-aligned, analytics-ready data products
Implement reusable Mesh views across domains (e.g., Workforce Management, Core Tech)
Optimize performance of queries and views for downstream consumption
Align view design with Power BI reporting and API consumption needs
Implement validation checks to ensure data accuracy, completeness, and consistency
Support data classification, lineage, and metadata documentation (data dictionary)
Ensure compliance with enterprise data governance and security standards
Manage role-based access and secure data sharing in Snowflake
Develop and maintain scheduling and orchestration workflows for ingestion pipelines
Monitor Snowflake performance and optimize pipelines for efficiency and cost
Troubleshoot data issues and support production releases
Maintain high availability and reliability of data pipelines and views
Work closely with POD teams (Core Tech, Workforce Management, etc.)
Engage with Power BI developers to align on reporting requirements
Support AI/analytics use cases (e.g., data exposure for APIs, AI agents)
Participate in Agile ceremonies (PI planning, sprint execution, backlog refinement)