3Pillar - Lead Data Engineer - Consultant

2 days ago

Greater Noida, Uttar Pradesh, India brickred (3pillar global) Full time ₹ 12,00,000 - ₹ 36,00,000 per year
Job Description

Lead Data Engineer - Consultant Noida

Product Development Product Development /
Contractor /
Hybrid

Embark on an exciting journey into the realm of data analytics with 3Pillar We extend an invitation for you to join our team and gear up for a thrilling adventure. As a Snowflake Data Architect you will be at the heart of the organization and support our clients to take control of their data and get value out of it by defining a reference architecture for our customers. This means that you will work closely with business leaders and information management teams to define and implement a roadmap on data management, business intelligence or analytics solutions.

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

Relevant Experience:
  • 10 years in Data Practice
Must have Skills:
  • Snowflake, Data Architecture, Engineering, Governance, and Cloud services
Responsibilities:
  • Lead the architecture and design of scalable, secure, and high-performing data solutions using Snowflake.
  • Design and implement robust data models (star, snowflake, normalized, and denormalized) for reporting and analytics use cases.
  • Develop and manage ETL/ELT pipelines using tools like Informatica, dbt, Talend, Matillion, or custom scripts.
  • Optimize Snowflake performance through clustering, caching, resource monitors, and query tuning.
  • Integrate Snowflake with diverse data sources including cloud storage (S3, Azure Blob), APIs, RDBMS, and real-time systems.
  • Implement security best practices including data masking, access controls, and role-based access (RBAC).
  • Collaborate with stakeholders including data engineers, analysts, BI developers, and business users to understand requirements and provide technical guidance.
  • Define and enforce data governance, data quality, and metadata management policies.
  • Stay updated on emerging Snowflake features and industry trends to continuously improve architecture and processes.
  • Coordinate with data scientists, analysts, and other stakeholders for data-related needs.
  • Help the Data Science & Analytics Practice grow by mentoring junior Practice members, leading initiatives, leading Data Practice Offerings.
  • Provide thought leadership by representing the Practice / Organization on internal / external platforms.
Qualification:
  • Translate business requirements into data requests, reports and dashboards.
  • Strong Database & modeling concepts with exposure to SQL & NoSQL Databases.
  • Strong data architecture patterns & principles, ability to design secure & scalable data lakes, data warehouse, data hubs, and other event-driven architectures.
  • Expertise in designing and writing ETL processes.
  • Strong experience with Snowflake, and its components.
  • Knowledge of Master Data management and related tools.
  • Strong exposure to data security and privacy regulations (GDPR, HIPAA) and best practices.
  • Skilled in ensuring data accuracy, consistency, and quality.
  • Experience of AWS services viz., AWS S3, Redshift, Lambda, DynamoDB, EMR, Glue, Lake formation, Athena, Quicksight, RDS, Kinesis, Managed Kafka, API Gateway, CloudWatch.
  • Ability to implement data validation processes and establish data quality standards.
  • Experience in Linux, and scripting.
  • Proficiency in data visualization tools like Tableau, Power BI or similar to create meaningful insights.
Additional Experience Desired:
  • Experience working with data ingestion tools such as Fivetran, Stitch, or Matillion.
  • AWS IoT solutions.
  • Apache NiFi, Talend, Informatica.
  • Knowledge of GCP Data services.
  • Exposure to AI / ML technologies.

  • 3Pillar - Senior Innovation Engineer

    5 days ago

    Greater Noida, Uttar Pradesh, India brickred (3pillar global) Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Job Description Senior Innovation Engineer - Noida Product Development Product Development / Full-time / Remote This is a senior-level, applied AI role for a resourceful and creative engineer who will build, deploy, and refine our consumer-facing AI applications. The successful candidate will lead the development of conversational AI agents and other...

  • Sr. Data Engineer

    2 weeks ago

    Noida, Uttar Pradesh, India 3Pillar Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Embark on an exciting journey into the realm of software development with 3Pillar We extend an invitation for you to join our team and gear up for a thrilling adventure. 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...

  • Senior Data Engineer

    7 days ago

    Noida, Uttar Pradesh, India 3Pillar Full time ₹ 8,00,000 - ₹ 24,00,000 per year

    Embark on an exciting journey into the realm of software development with 3Pillar We extend an invitation for you to join our team and gear up for a thrilling adventure. 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...

  • 3Pillar - Senior AI Engineer with GeAI, LangGraph, Agentic System (5 Yrs of Exp)

    1 week ago

    Greater Noida, Uttar Pradesh, India brickred (3pillar global) Full time ₹ 8,00,000 - ₹ 24,00,000 per year

    Job Description : Senior AI Engineer with GeAI, LangGraph, Agentic System (5 Yrs of Exp) Location: NoidaProduct Development: Product DevelopmentJob Type: Full-time / Remote This is a senior-level, applied AI role for a resourceful and creative engineer who will build, deploy, and refine our consumer-facing AI applications. The successful candidate will...

  • 3Pillar - Senior Software Engineer - Java & Spring boot

    2 days ago

    Greater Noida, Uttar Pradesh, India brickred (3pillar global) Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Job Description : Senior Software Engineer - Java & Spring Boot Location: NoidaDepartment: Product DevelopmentEmployment Type: Full-timeWork Arrangement: Remote About Us We are 3PILLAR GLOBAL. We build breakthrough software products that power digital businesses. We are an innovative product development partner whose solutions drive rapid revenue,...

  • 3Pillar - Senior Software Engineer - Java( Spring boot) RabbitMQ

    7 days ago

    Greater Noida, Uttar Pradesh, India brickred (3pillar global) Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    Job Description Senior Software Engineer - Java (Spring Boot) RabbitMQ Location: NoidaDepartment: Product Development / Full-time / Remote We are 3PILLAR GLOBAL We build breakthrough software products that power digital businesses. We are an innovative product development partner whose solutions drive rapid revenue, market share, and customer growth...

  • Lead AI ML Engineer

    4 hours ago

    Noida, Uttar Pradesh, India 3Pillar Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    We build breakthrough software products that power digital businesses. We are an innovative product development partner whose solutions drive rapid revenue, market share, and customer growth for industry leaders in Software and SaaS, Media and Publishing, Information Services, and Retail. Our key differentiator is our Product Mindset. Our development teams...

  • Senior AI Engineer with GeAI

    2 weeks ago

    Noida, Uttar Pradesh, India 3Pillar Full time

    This is a senior-level, applied AI role for a resourceful and creative engineer who will build, deploy, and refine our consumer-facing AI applications. The successful candidate will lead the development of conversational AI agents and other generative systems that will help redefine how users interact with solutions with AI features. This is a chance to move...

  • Senior Business Analyst/Product Owner

    2 days ago

    Noida, Uttar Pradesh, India 3Pillar Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Embark on an exciting journey into the realm of product development with 3Pillar We extend an invitation for you to join our team and gear up for a thrilling adventure. At 3Pillar, our focus is on crafting cutting-edge technologies that revolutionize industries. Minimum Qualifications:7+  years of experience as an IT Business Analyst or other relevant...

  • 3Pillar - Sr. AI Innovation Engineer (AgenticAI)

    7 days ago

    Greater Noida, Uttar Pradesh, India brickred (3pillar global) Full time ₹ 8,00,000 - ₹ 24,00,000 per year

    Job Description Sr. AI Innovation Engineer (AgenticAI) Location: NoidaDepartment: Product DevelopmentJob Type: Full-timeWork Model: Hybrid This is a senior-level, applied AI role for a resourceful and creative engineer who will build, deploy, and refine our consumer-facing AI applications. The successful candidate will lead the development of...