Snowflake Developer (Remote friendly)

Imagine Communications • Chesapeake, VA

1d • Remote

About The Position

Every day, Imagine Communications is delivering billions of media moments all over the world — anywhere, anytime and on any device. Imagine Communications delivers innovative, end-to-end media software and networking solutions to over 3,000 customers in more than 185 countries, including the top broadcast facilities and the most technologically advanced sports and live-event venues.
We are seeking a hands-on Data Engineer with strong experience in Snowflake and Informatica Intelligent Cloud Services (IICS).
The role focuses on building, optimizing, and supporting scalable data pipelines and analytics-ready data models.
This position requires Advanced SQL skills, Snowflake stored procedure development, IICS pipeline orchestration, and CI/CD deployment using GitHub, and experience integrating data from Oracle Fusion Analytics (FAW).

Requirements

• 6–10+ years of experience in Data Engineering or Data Warehousing
• Strong hands-on experience with Snowflake, Advanced SQL skills, including query optimization and performance tuning
• Hands-on experience with Informatica Intelligent Cloud Services (IICS) – Mappings / Transformations / Tasks / Taskflows
• Experience in Data integration of Oracle Fusion Analytics (FAW)
• Experience implementing CI/CD pipelines for data platforms
• Strong experience using GitHub for version control and deployments
• Solid understanding of ETL and ELT design patterns
• Experience working with structured and semi-structured data (XML/JSON/Parquet)

Nice To Haves

• Python or scripting experience for automation
• Experience with dbt or other ELT frameworks
• Exposure to AWS or Azure cloud platforms
• Familiarity with data governance, auditing, and monitoring, Oracle Fusion Cloud ERP or any other ERP system.

Responsibilities

• Design, develop, and maintain ELT data pipelines in Snowflake
• Design and build Informatica IICS mappings for batch, mass ingestion, and incremental data ingestion
• Develop and schedule IICS Taskflows for orchestration, dependencies, retries, and error handling
• Integrate data from Oracle Fusion Analytics (FAW) into Snowflake using IICS
• Monitor, troubleshoot, and optimize IICS workflows and data pipelines
• Implement CI/CD pipelines for Snowflake and IICS assets
• Use GitHub for source control, versioning, code reviews, and deployments
• Write, optimize, and tune complex SQL for data transformations, CDC, and analytics use cases
• Develop Snowflake stored procedures using SQL and Python
• Implement incremental and near-real-time data processing using Snowflake Streams and Tasks
• Support multi-environment Snowflake deployments (Dev, QA, Prod)
• Automate deployment of Snowflake SQL objects, stored procedures using PowerShell
• Provide production support, root cause analysis, and performance tuning
• Collaborate with data analysts, architects, and business stakeholders
• Document technical designs, standards, and operational procedures

Benefits

• Imagine Communications offers a generous Medical, Dental, Vision and Life Insurance package and HSA and 401(k) options with company matching.
• We like to make sure all our employees are safe when travelling so we’ve got travel insurance covered too.
• Employee Wellbeing is a priority for us, so all employees and their family have access to our EAP and Wellness programs, including LifeSpeak and Vitality.
• Volunteer in your community and we will pay for that too.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed