Sorry, this listing is no longer accepting applications. Don’t worry, we have more awesome opportunities and internships for you.

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

VTekis Consulting LLP

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

Pittsburgh, PA
Full Time
Paid
  • Responsibilities

    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

  • Qualifications

    Additional Information

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