Jobs
>
Reston

    Lead Snowflake Engineer - Reston, United States - Intellibus

    Default job background
    Technology / Internet
    Description

    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.



  • Idexcel Bethesda, United States

    Role: Sr. Snowflake Data Engineer · Location: Bethesda, MD · Contract to Hire · Skills: · Hands on Experience as a Tech lead · Must have experience in Kafka ,SQL, Spark, Python, Pyspark, AWS. · Snowflake (certifications are big plus) · Good communication skills. · ...

  • Unacast

    Api Team Lead

    1 week ago


    Unacast Ashburn, United States

    Are you a leader that loves all things APIs? · At Unacast, we believe in agile, self-organizing teams that create valuable products, innovate and use the latest proven technologies. As a Team Leader for one of our most important product teams, you will play a vital role in one of ...

  • Diverse Lynx

    Big Data Lead

    2 weeks ago


    Diverse Lynx Reston, United States

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


  • The Salvation Army National Headquarters Alexandria, United States

    **JOB SUMMARY**: · The Data Warehouse Administrator is responsible for managing and optimizing the performance of a data warehouse, ensuring the integrity, security, and efficient storage and retrieval of data. This role involves collaborating with database developers, data archi ...


  • GEICO Chevy Chase, United States

    Job Duties · At GEICO, bringing new product features to the market is fundamental to our strategic vision of attracting and retaining customers. Implementing new product models with accuracy and efficiency enables GEICO to continue to be a leader in the competitive auto insurance ...

  • Progressive Technology Solutions

    Data Scientist

    1 week ago


    Progressive Technology Solutions Washington, United States

    **Data Scientist**: · **Remote but need to visit the office once a month (Washington, DC)** · **Responsibilities**: · - Develop AI and Generative AI models and solutions using AWS Sagemaker. · - Evaluate, select, implement, and support an enterprise data science toolkit, ensure t ...


  • iO Associates - US Reston, United States

    An IT consultancy is looking for a talented Senior Data Scientist specializing in Artificial Intelligence and Machine Learning Engineering to join their team on a Perm basis. The firm is headquartered in Washington DC and has a hybrid model. · The firm are looking for a Data scie ...

  • AVM Consulting Inc

    Senior Data Engineer

    2 weeks ago


    AVM Consulting Inc Reston, United States

    Sr. Data Engineer · In 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 ...


  • IBM Alexandria, United States

    Introduction · A Technology Sales Representative role (what we internally call a, 'Brand Sales Specialist') in IBM's Data & AI brand means accelerating enterprises' success by improving their ability to understand their data. It means providing solutions that enable people across ...


  • The Consortium Reston, United States

    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 · React js · SnowFlake · SQL · Team: Team focus on data · Profil ...

  • CapTech Consulting

    Lead Data Engineer

    1 week ago


    CapTech Consulting Reston, United States

    Job Description · Job DescriptionCompany Description · CapTech is an award-winning consulting firm that collaborates with clients to achieve what's possible through the power of technology. At CapTech, we're passionate about the work we do and the results we achieve for our clien ...


  • Diverse Lynx Reston, United States

    Job Description · Responsibilities: · Deep expertise in Big Data, data warehouse, data analytics projects, and/or any Information Management related projects · Prior experience building large scale enterprise data architectures using commercial and/or open source Data Analytics ...

  • Applied Information Sciences

    Data Architect

    5 days ago


    Applied Information Sciences Reston, United States

    As a Data Architect , you will use cutting-edge cloud and data technologies to help global brands and federal agencies solve challenging problems through innovative technology solutions. Work on exciting projects, future-proof your skills, and grow into your dream job alongside s ...


  • Diverse Lynx Reston, United States

    Job Description · Responsibilities: · Deep expertise in Big Data, data warehouse, data analytics projects, and/or any Information Management related projects · Prior experience building large scale enterprise data architectures using commercial and/or open source Data Analytics ...

  • Applied Information Sciences

    Data Architect

    2 days ago


    Applied Information Sciences Reston, United States Permanent

    Intro: · As a Data Architect, you will use cutting-edge cloud and data technologies to help global brands and federal agencies solve challenging problems through innovative technology solutions. Work on exciting projects, future-proof your skills, and grow into your dream job al ...


  • Comcast Corporation Reston, United States Full time

    FreeWheel, a Comcast company, provides comprehensive ad platforms for publishers, advertisers, and media buyers. Powered by premium video content, robust data, and advanced technology, we're making it easier for buyers and sellers to transact across all screens, data types, and s ...

  • Demo - Maximus

    Data Science Analyst

    2 weeks ago


    Demo - Maximus Reston, United States

    Job SummaryThe SOA-PAX Data Science team consists of highly skilled Data Scientists working together following an agile methodology and design thinking. We are a "start-up" department within SOA-PAX with driven and creative attitudes. We take the time to understand our internal a ...

  • ECS

    Data Engineer

    2 weeks ago


    ECS Fairfax, United States

    ECS is seeking a Data Engineer to work in our Fairfax, VA office. · Job Description: · ECS is a leading mid-sized provider of technology services to the United States Federal Government. We focus on people, values, and purpose. Every day, our 4000+ employees provide their technic ...


  • ICF Reston, United States

    ICF is a mission-driven company filled with people who care deeply about improving the lives of others and making the world a better place. Our core values include Embracing Difference; we seek candidates who are passionate about building a culture that encourages, embraces, and ...

  • Team Velocity

    Senior Data Engineer

    3 weeks ago


    Team Velocity Herndon, United States

    Job Description · Job DescriptionFast-paced, high-growth, technology-driven marketing company serving the digital marketing automotive industry seeks hard working Senior Data Engineer. Strong MSSQL experience, a must · The ideal candidate has very strong knowledge of the Microso ...