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


Job Location:

Pittsburgh, PA - USA

Monthly Salary: Not Disclosed
Posted on: 3 hours ago
Vacancies: 1 Vacancy

Job Summary

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 - or Text - or You can share the updated resume at com


Additional Information :

All your information will be kept confidential according to EEO guidelines.


Remote Work :

No


Employment Type :

Full-time

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 i...

About Company

Company Logo

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 par ... View more

View Profile View Profile