Snowflake Engineer Job at 1 point system, Pittsburgh, PA

MlFlWm50TzBqM3RBbHBDVjlScFlmOFI1VEE9PQ==
  • 1 point system
  • Pittsburgh, PA

Job Description

Data Engineer - Job Description/ Responsibilities
Role Summary
We are seeking a Data Engineer to support the Enterprise Contact Center (ECC) data platform, with a primary focus on data ingestion into Snowflake (SPN) and creation of curated data products (views) for downstream analytics and AI use cases.
This role will work within the Data Enrichment POD under the Platforms Operating Model (POM), building scalable pipelines to ingest data from multiple source systems (e.g., Avaya, Genesys, NICE, Dynamics, IVR platforms) into Snowflake, and transforming it into trusted, consumable datasets for Power BI, APIs, and AI-driven solutions.


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)


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


Preferred Skills
Experience with Contact Center data platforms (Avaya, Genesys, NICE, Dynamics, IVR)
Familiarity with Data Mesh / Data Product architecture
Experience supporting Power BI or Tableau
Exposure to AI/analytics enablement (data for ML, APIs, or semantic layers)
Knowledge of orchestration tools (Airflow, Snowflake Tasks, etc.)


Success Measures
Reliable and scalable ingestion pipelines into Snowflake SPN
Timely onboarding of new data sources
High-quality, validated curated views used by Power BI and downstream consumers
Reduced data latency and improved data availability
Strong alignment with business and reporting requirements

Job Tags

Similar Jobs

IGL4US

Event Staff Job at IGL4US

 ...integrations, automation tools, or AI-driven systems, we help companies bridge the gap between ideas and execution. We believe innovation...  ...IGL4US is seeking energetic, dependable, and customer-focused Event Staff to support the successful execution of events throughout... 

Terra Global Capital LLC

GHG Quantification and Mangrove Specialist, Nature-based Solutions (NbS) Job at Terra Global Capital LLC

 ...Position: GHG Quantification and Mangrove Specialist, Nature-based Solutions (NbS) Term: Full-time Employee...  ...mangroves and other tidal wetlands, including both restoration and conservation activities. Utilize advanced biostatistical techniques to... 

Royal Caribbean Cruises, Inc.

Sports Manager Job at Royal Caribbean Cruises, Inc.

Sports ManagerThe Entertainment Team helps ensure that our guests enjoy their stay on board as much as their time in port. They embrace the challenge of being in the spotlight or working behind the scenes to deliver world-class productions in the different performance... 

Loreal

2027 L'Oréal USA Summer Internship -Finance- Undergraduate (Tampa) Job at Loreal

 ...able tohelp drive the future of beauty. The LOral USA Summer Internship Program is a paid, 11-week experience where you will be fully...  ...~ Tampa, FL What Youll Do: Dive into the world of finance through day-to-day tasks like category analysis, process improvement... 

AIR Communities

Apartment Leasing Consultant - Zerzura Job at AIR Communities

 ...AIR Communities owns and operates best-in-class apartment communities in major markets across the country. Our communities are managed...  ...customer service to our residents. Job Description Our Leasing Consultants are top sales performers , creating moments that...