Lead Snowflake Engineer

4 weeks ago

Reston, United States Intellibus Full time

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


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.

Are you a data enthusiast with a natural ability for analytics? We’re looking forward skilled Data/Analytics Engineers to fill multiple roles for our exciting new client. This is your chance to shine, demonstrating your dedication and commitment in a role that promises both challenge and reward.

 

What We Offer:

A dynamic environment where your skills will make a direct impact. The opportunity to work with cutting-edge technologies and innovative projects. A collaborative team that values your passion and focus.


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


Key Skills & Qualifications:


  •  ETL – Experience with ETL processes for data integration.
  • SQL – Strong SQL skills for querying and data manipulation
  • Python – Strong command of Python, especially in AWS Boto3, JSON handling, and dictionary operations
  • Unix – Competent in Unix for file operations, searches, and regular expressions
  • AWS – Proficient with AWS services including EC2, Glue, S3, Step Functions, and Lambda for scalable cloud solutions
  • Database Modeling – Solid grasp of database design principles, including logical and physical data models, and change data capture (CDC) mechanisms.
  •  Snowflake – Experienced in Snowflake for efficient data integration, utilizing features like Snowpipe, Streams, Tasks, and Stored Procedures.
  • Airflow – Fundamental knowledge of Airflow for orchestrating complex data workflows and setting up automated pipelines
  • Bachelor's degree in Computer Science, or a related field is preferred. Relevant work experience may be considered in lieu of a degree.
  • Excellent communication and interpersonal skills, with the ability to effectively collaborate with cross-functional teams and stakeholders.
  • Proven leadership abilities, with experience mentoring junior developers and driving technical excellence within the team.


We work closely with

  • Data Wrangling
  • ETL
  • Talend
  • Jasper
  • Java
  • Python
  • Unix
  • AWS
  • Data Warehousing
  • Data Modeling
  • Database Migration
  • 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.

  • Lead Snowflake Engineer

    3 weeks ago

    Reston, United States Intellibus Full time

    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!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...

  • Big Data Lead

    4 weeks ago

    Reston, United States Diverse Lynx Full time

    Location: Stamford, Connecticut -Weekly Thrice(Hybrid) Job Description Senior Data Engineer (8+ yrs of exp) Responsibilities - Experienced Data engineer responsible for developing, overseeing, organizing, storing, and analyzing data and data systems. • Responsible for Cloud migrations for data pipelines using AWS and Snowflake • Participate in all...

  • Senior Data Engineer

    2 months ago

    Reston, United States AVM Consulting Inc Full time

    Sr. Data EngineerIn this role, you'll help shape the future of forecasting for one of the largest mortgage industry companies in the world. This is an exciting opportunity to join a team working with cutting-edge technology at an unparalleled scale. We are looking for a strong Senior Data Engineer who can help design and implement a sophisticated Data...

  • Senior Data Engineer

    2 months ago

    Reston, United States AVM Consulting Inc Full time

    Sr. Data EngineerIn this role, you'll help shape the future of forecasting for one of the largest mortgage industry companies in the world. This is an exciting opportunity to join a team working with cutting-edge technology at an unparalleled scale. We are looking for a strong Senior Data Engineer who can help design and implement a sophisticated Data...

  • AWS Data Engineer

    2 months ago

    Reston, United States Atechstar Full time

    Required Qualifications Candidate can be located anywhere in US for this position. This position may require travel in the US and Canada. Bachelors degree or foreign equivalent required from accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education At least 4 years of experience with...

  • lead software engineer

    2 months ago

    Reston, Virginia, United States Atechstar Full time

    Job Description Lead Software Engineer In this role you willThe ideal candidate will work closely with other members of the development team to ensure success of the project. Lead complex technology initiatives including those that are companywide with broad impact Act as a key participant in developing standards and companywide best practices for...

  • lead software engineer

    1 week ago

    Reston, Virginia, United States Atechstar Full time

    Job Description Lead Software Engineer In this role you willThe ideal candidate will work closely with other members of the development team to ensure success of the project. Lead complex technology initiatives including those that are companywide with broad impact Act as a key participant in developing standards and companywide best practices for...

  • AWS Data Engineer

    2 months ago

    Reston, Virginia, United States Atechstar Full time

    Required Qualifications Candidate can be located anywhere in US for this position. This position may require travel in the US and Canada. Bachelors degree or foreign equivalent required from accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education At least 4 years of experience with...

  • AWS Data Engineer

    1 week ago

    Reston, Virginia, United States Atechstar Full time

    Required Qualifications Candidate can be located anywhere in US for this position. This position may require travel in the US and Canada. Bachelors degree or foreign equivalent required from accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education At least 4 years of experience with...

  • Engineering Lead

    2 weeks ago

    Reston, United States Scout Solutions Inc Defunct Full time

    Engineering Lead Location: Reston, VA (Hybrid) The Senior Manager, Engineering Lead is responsible for being a leader on a technical team in the design, development, and delivery of technology-enabled applications and for delivering fast and sustainable results in three (3) primary areas: •Deliver business solutions with a customer focus; •Build and...

  • Lead Systems Engineer

    3 weeks ago

    Reston, United States RGI, LLC Full time

    As a Lead Systems Engineer, you will be directly supporting a program which provides critical capabilities to help enable efficient and timely collection management across multiple collection providers. You will provide engineering analysis, design and architecture for a growing data driven microservice and mission application environment, where you will be...

  • Lead Systems Engineer

    3 weeks ago

    Reston, United States Reinventing Geospatial Full time

    Job Highlights: As a Lead Systems Engineer, you will be directly supporting a program which provides critical capabilities to help enable efficient and timely collection management across multiple collection providers. You will provide engineering analysis, design and architecture for a growing data driven microservice and mission application environment,...

  • Engineering Team Lead

    1 week ago

    Reston, United States Thermo Systems Full time

    Career Opportunities with Thermo Systems LLC Careers At Thermo Systems LLC Current job opportunities are posted here as they become available. Subscribe to our RSS feeds to receive instant updates as new positions become available. Thermo Systems is a $100 million-dollar global, full-service control systems integration partner, providing world-class...

  • Lead Data Engineer

    3 days ago

    Reston, United States Buzzclan Full time

    Job DescriptionJob DescriptionJob Title : Lead Data EngineerJob Location : Reston, VA/Hybrid Job Tenure : 12 Months with Possible Contract to HireDescription:Purpose: The Lead Data Engineer is responsible for orchestrating, deploying, maintaining and scaling cloud OR on-premise infrastructure targeting big data and platform data management (Relational and...

  • Sr Full Stack AWS Engineer

    1 week ago

    Reston, United States The Consortium Full time

    TECHNICAL SKILLS Must Have Automated API integration testing Automated E2E browser testing AWS Dynamo AWS Lambda AWS S3 AWS - SNS/SQS Data Reporting JavaScript (ES6) logi analytics Node.js React js SnowFlake SQL Team: Team focus on data Profile: Senior level software engineer with strong Node and DynamoDB with experience development applications with lots...

  • Lead Civil Engineer

    3 weeks ago

    Reston, United States Orchard , CO Full time

    Description Lead Civil Engineer Reston, VA @Orchard LLC has an immediate opening for an experienced Civil Engineer to support a contract for a well-established solutions provider within the defense, intelligence, and critical infrastructure sectors. The position is a contract-to-hire requiring at least 4 months of contract tenure to be eligible for full-time...

  • Lead Electrical Engineer

    1 week ago

    Reston, United States Bechtel Oil, Gas & Chemicals Incorporated Full time

    Press Tab to Move to Skip to Content Link Select how often (in days) to receive an alert: Select how often (in days) to receive an alert: Extraordinary teams building inspiring projects: Since 1898, we have helped customers complete more than 25,000 projects in 160 countries on all seven continents that have created jobs, grown economies, improved the...

  • Lead Structural Engineer

    3 days ago

    Reston, United States Bechtel Corporation Full time

    Overview: As the Lead Structural Engineer, you will be responsible for supervising other structural engineers and helping to execute assignments concerned with specialized or unique engineering requirements in a global business unit. This position has technical responsibility for interpreting, organizing, and coordinating these assignments. This...

  • Lead Electrical Engineer

    2 weeks ago

    Reston, Virginia, United States Bechtel Full time

    Requisition ID: 276726 Relocation Authorized: National - Family Telework Type: Full-Time Office/Project Work Location: Reston, VA Extraordinary teams building inspiring projects:Since 1898, we have helped customers complete more than 25,000 projects in 160 countries on all seven continents that have created jobs, grown economies, improved the resiliency...

  • Lead Electrical Engineer

    2 weeks ago

    Reston, United States Bechtel Full time

    Requisition ID: 276726   Relocation Authorized: National - Family  Telework Type: Full-Time Office/Project  Work Location: Reston, VA  Extraordinary teams building inspiring projects: Since 1898, we have helped customers complete more than 25,000 projects in 160 countries on all seven continents that have created jobs, grown economies,...