3pillar Global

Senior Data Engineer with Exp in Snowflake & Amazon QuickSight(5+ Years of Exp)

Apply Now

Job Description

At 3Pillar, our focus is on leveraging cutting-edge technologies that revolutionize industries by enabling data driven decision making. As a Senior Data Engineer, you will hold a crucial position within our dynamic team, actively contributing to thrilling projects that reshape data analytics for our clients, providing them with a competitive advantage in their respective Industries. if your passion for data analytics solutions that make a real-world impact, consider this your pass to the captivating world of Data Science and Engineering! 🔮🌐


Key Responsibilities
  • Design, develop, and optimize scalable ETL/ELT pipelines for enterprise data platforms
  • Build and maintain robust data solutions using Snowflake, Python, and AWS services
  • Develop advanced SQL queries using CTEs, window functions, query tuning, and performance optimization techniques
  • Work with Snowflake warehouses, tasks, streams, and data pipelines for efficient data processing
  • Create and maintain data transformation workflows using dbt (data build tool)
  • Develop reporting datasets and support dashboarding solutions using Amazon QuickSight
  • Perform data validation, data integrity checks, and root cause analysis to ensure data accuracy and reliability
  • Integrate and manage data across platforms including DynamoDB, S3, AWS Glue, Lambda, and Rockset
  • Collaborate with cross-functional teams including analytics, product, and clinical stakeholders to support reporting requirements
  • Monitor pipeline performance and troubleshoot production data issues

    • Required Skills
  • Strong experience in SQL including:
    • CTEs
    • Window Functions
    • Query Optimization
    • Performance Tuning
    • Hands-on experience with Snowflake:
      • Warehouses
      • Streams
      • Tasks
      • Data Loading and Optimization
      • Experience in Python for data processing and pipeline development
      • Experience with AWS services:
        • AWS Glue
        • Lambda
        • S3
        • Good knowledge of dbt (Data Build Tool)
        • Experience in creating dashboards and reports using Amazon QuickSight
        • Knowledge of Rockset analytical engine
        • Experience with DynamoDB and NoSQL databases
        • Basic to intermediate knowledge of JavaScript

    • Apply Now
    Job Summary

    Senior Analytics Engineer

    Location: RemoteSalary: £75,000 - £80,000About usAt Arbor, we’re on a mission to transform the way schools work for the better. We believe in a future of work in schools

    • Senior
    • Remote United Kingdom
    • 26 days ago

    Senior Analytics Engineer

    Senior Analytics Engineer Data Prolific Prolific is not just another player in the AI space—we are the architects of the human data infrastructure

    • Remote United Kingdom
    • 6 days ago

    Oracle Data Engineer (with German Language)

    Who we are:Soname Solutions is a group of enthusiasts who are in love with data analytics and big data. We help our clients in becoming data-driven companies.Our team kee

    • Remote Georgia
    • one month ago

    Data Engineer, Customer Engineering

    Who We AreClaritas Rx is a venture-backed digital health startup that brings clarity to the challenges of specialty biopharmaceutical products in the marketplace. In toda

    • Remote USA
    • 9 days ago