AWS Data Engineer with BI Connector To snowflake migration Exp(6+ Yrs of Exp & Immediate Joiner looking for)

3Pillar is an AI transformation partner on a mission to help enterprises build the AI-native products and intelligent agents that will define the next era of business. With teams across North America, Europe, Latin America, and Asia, we work with the most ambitious companies in financial services, healthcare, media, and technology - helping them move faster, modernize boldly, and compete on their own terms. Our HelixAI platform and Helix Pods delivery model put our engineers at the center of real agentic transformation - doing work that is open, portable, and built to last. We are building the future of enterprise AI.

Job description

We are looking for a skilled Data Engineer with strong experience in AWS, SQL, Snowflake, BI Connector to snowflake migration. The candidate will be responsible for building data pipelines, migrating BI workloads to Snowflake, optimizing data solutions, and ensuring seamless connectivity between BI platforms and Snowflake.

Key Responsibilities

• Develop and maintain scalable ETL/ELT data pipelines using AWS services and Snowflake.
• Perform BI/reporting migration to Snowflake and support end-to-end data migration activities.
• Design and optimize data models, SQL queries, and Snowflake workloads.
• Configure and troubleshoot BI connectivity with Snowflake (Power BI/Tableau/Looker).
• Implement Snowflake best practices for performance, security, and cost optimization.
• Troubleshoot data pipeline failures and production issues.
• Collaborate with BI teams, architects, and stakeholders for successful delivery.

Mandatory Skills

• Strong hands-on experience with Snowflake Data Warehouse.
• Strong SQL and data engineering skills.
• Experience with AWS services:
  • S3
  • AWS Glue
  • Lambda
  • IAM
  • CloudWatch
  • Experience in ETL/ELT, data modeling, and data migration.
  • Experience integrating BI tools with Snowflake using connectors (JDBC/ODBC).

  Good to Have

  • SnowPro Core Certification.
  • Experience with Python/PySpark.
  • Experience with Airflow, Databricks, or Terraform.
  • Snowflake performance tuning and optimization experience.