The Senior Data Engineer will lead the design and implementation of enterprise-scale ELT/ETL pipelines using Informatica Cloud (IICS), ensuring data quality, security, and governance, and mentor junior and mid-level data engineers. The role involves working with cloud technologies, advanced data security protocols, and data governance frameworks.
Requirements
- Bachelor’s degree and 6+ years of progressive experience in data engineering or related fields.
- 5 years of hands-on experience designing and deploying production ELT/ETL solutions using Informatica Cloud (IICS), including Mapping Designer, Data Integration, and API management.
- 5 years of experience working with Snowflake in a data engineering capacity, including advanced features like Streams, Tasks, stored procedures, UDFs, and external functions.
- Expert-level proficiency in SQL, including complex window functions, CTEs, recursive queries, and Snowflake-specific optimizations (zero-copy cloning, time travel, result caching).
- Proven experience implementing data governance policies and security compliance frameworks, using tools like Collibra, Alation, or native Snowflake features.
- Deep understanding of data security principles, including encryption standards (AES-256), key management (AWS KMS, Azure Key Vault), and secure data sharing protocols.
- Strong Python skills for data transformation, automation, and API integration.
- Proven track record of designing and implementing enterprise system integrations for seamless data interoperability.
- Proficiency in data lakehouse architecture and data product development.
- Excellent communication skills for effective collaboration across diverse teams.
Benefits
- Health & Wellness
- Flexible Downtime
- Continuous Learning
- Invest in Your Future
- Family Friendly Perks
- Beyond the Basics