Snowflake Developer (Remote friendly)
Overview: 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. Why Imagine? 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. A Bit About The Role: 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).
- 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
About You:
- 6–10+ years of experience in Data Engineering or Data Warehousing
- SnowPro Core Certification
- 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 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 Have:
- 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.
Celebrating difference, together stronger At Imagine Communications, we don’t just accept difference — we celebrate it, we support it, and we thrive on it for the benefit of our customers, our employees, our products, and our communities. We are committed to providing an environment of mutual respect. Imagine Communications is proud to be an equal opportunity workplace and is an affirmative action employer. Apply tot his job Apply To this Job