Snowflake Data Engineer
March 17
🏡 Remote – New York
Description
• Are you a Data Engineer working at a Large Financial Institution and being told by your leadership that you are too hands-on or detail-oriented or think and work like a start-up? • We are looking forward to you joining our Platform Engineering Team. • Our Platform Engineering Team is working to solve the Multiplicity Problem. We are trusted by some of the most reputable and established FinTech Firms. Recently, our team has spearheaded the Conversion & Go Live of apps that support the backbone of the Financial Trading Industry. • Design, develop, and maintain data pipelines to ingest, transform, and load data from various sources into Snowflake. • Implement ETL (Extract, Transform, Load) processes using Snowflake's features such as Snowpipe, Streams, and Tasks. • Design and implement efficient data models and schemas within Snowflake to support reporting, analytics, and business intelligence needs. • Optimize data warehouse performance and scalability using Snowflake features like clustering, partitioning, and materialized views. • Integrate Snowflake with external systems and data sources, including on-premises databases, cloud storage, and third-party APIs. • Implement data synchronization processes to ensure consistency and accuracy of data across different systems. • Monitor and optimize query performance and resource utilization within Snowflake using query profiling, query optimization techniques, and workload management features. • Identify and resolve performance bottlenecks and optimize data warehouse configurations for maximum efficiency. • Work on Snowflake modeling – roles, databases, schemas, ETL tools with cloud-driven skills • Work on SQL performance measuring, query tuning, and database tuning • Handle SQL language and cloud-based technologies • Set up the RBAC model at the infra and data level. • Work on Data Masking / Encryption / Tokenization, Data Wrangling / ECreLT / Data Pipeline orchestration (tasks). • Setup AWS S3/EC2, Configure External stages, and SQS/SNS • Perform Data Integration e.g. MSK Kafka connect and other partners like Delta Lake (data bricks)
Requirements
• Data Wrangling • ETL • Talend • Jasper • Java • Python • Unix • AWS • Data Warehousing • Data Modeling • Database Migration • ECreLT • RBAC model • Data migration
Apply Now
