Snowflake Data Engineer

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?

Imagine working at Intellibus to engineer platforms that impact billions of lives around the world. With your passion and focus we will accomplish great things together!

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.

We are looking for Engineers who can

• 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)

We work closely with

• Data Wrangling
• ETL
• Talend
• Jasper
• Java
• Python
• Unix
• AWS
• Data Warehousing
• Data Modeling
• Database Migration
• ECreLT
• RBAC model
• Data migration

Our Process

• Schedule a 15 min Video Call with someone from our Team
• 4 Proctored GQ Tests (< 2 hours)
• 30-45 min Final Video Interview
• Receive Job Offer

If you are interested in reaching out to us, please apply and our team will contact you within the hour.

Job Type: Full-time

Pay: $60.00 - $80.00 per hour

Schedule:

• Monday to Friday

Experience:

• Data Wrangling: 7 years (Preferred)
• Snowflake: 7 years (Preferred)
• ETL: 7 years (Preferred)

Ability to Relocate:

• Herndon, VA: Relocate before starting work (Required)

Work Location: In person