Data Engineer – Snowflake Data Ingestion & Data Products (ECC Platform) - W2 Position
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.