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

Back to Jobs
VTekis Consulting logo

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

VTekis Consulting

Location

Pittsburgh, PA, United States

Experience

Mid

Posted

Jul 30, 2026

Apply by

August 29, 2026

Applicants

0

Early applicantEasy applyFull-timeWork from Office

Job Description

## Company Description 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. ## Job Description Required Skills & Experience • 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 Key Responsibilities Data Ingestion (Primary Focus) • 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 Snowflake Data Modeling & View Creation (Data Products) • 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 Data Quality & Governance • 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 Platform Operations & Automation • 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 Stakeholder Collaboration • 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) Regards, Mohammed ilyas, PH - 229-264-4024 or Text - 229-469-1455 or You can share the updated resume at Mohammed@vtekis. com ## Additional Information All your information will be kept confidential according to EEO guidelines.

Key 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
  • Standardize ingestion into RAW data layers in Snowflake SPN
  • Partner with upstream teams to onboard new data sources
  • Monitor ingestion jobs and resolve failures, latency, or data completeness issues
  • Design and develop Snowflake views aligned with business requirements
  • Transform RAW data into domain-aligned, analytics-ready data products
  • Implement reusable Mesh views across domains
  • 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
  • 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 and engage with Power BI developers
  • Support AI/analytics use cases such as data exposure for APIs and AI agents
  • Participate in Agile ceremonies including PI planning and sprint execution

Skills Required

SnowflakeSQLETLELTAWS S3Data ModelingStar SchemaDimensional ModelsAPI-based IngestionFile-based IngestionAgileTroubleshootingData Quality AnalysisStakeholder CollaborationCommunication

App exclusive · Free

Smart Job AI Coach

Your personal interview coach on every job — readiness tips, profile improvements, and role-specific prep. Available only in the Pulse Job app.

Interview readiness

See how prepared you are and what to improve for each role.

Personalized tips

Actionable suggestions based on your profile and the job.

After you apply

Keep coaching momentum from job detail through application success.

Get Smart Job AI Coach in the appFree on iOS and Android