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.

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

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

  • Senior Quality Assurance Test Engineer

    2 weeks ago

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

    Minimum of 6 years of progressive experience in the IT field, demonstrating comprehensive knowledge of testing strategies, methodologies, and automation in complex software development environments.3+ years of leadership experience in QA roles, with a proven track record of managing high-performing QA teams and leading large-scale testing initiatives.HANDS...

  • Senior Data Engineer

    2 weeks ago

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

    Experience: 5-10 years of experience in data engineering,Strong programming skills in Python and Linux Bash for automation and data workflows.Hands on experience in SNOWFLAKE(minimum 2 years of exp)Framework Proficiency: Hands-on experience with Luigi for orchestrating complex data workflows.Data Processing & Storage: Expertise in Hadoop ecosystem tools and...

  • Senior Data Engineer

    2 weeks ago

    Noida, Uttar Pradesh, India Chenoa Information And Software Services Pvt. Ltd 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...

  • ISenior Data Strategy Consultant

    2 weeks ago

    Noida, Uttar Pradesh, India NTT DATA Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Job Title: Senior Data Strategy Consultant Summary: Are you passionate about leveraging data to drive strategic decisions and innovation in a dynamic industry? As a Senior Data Strategy Consultant, you will play a pivotal role in our journey to become a data-driven organization. You will design and implement comprehensive data strategies that align with...

  • Data & AI Presales Consultant

    1 week ago

    Noida, Uttar Pradesh, India NTT DATA Global Delivery Services Ltd Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    Data & AI Presales Consultant - Management Consulting Req ID: 332897 NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Data & AI Presales Consultant - Management Consulting to...

  • Senior Software Engineer

    2 weeks ago

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

    Minimum Qualifications:A minimum of 5 years of experience/expertise in the following areas specified below*:Expertise in .Net core, ASP.Net, Entity Framework, Docker, SQLServer, Cloud GCP (or AWS)Proven experience in developing microservices and local environment setupExperience in exception handling, correct use of data structures, multi-threaded...

  • Senior Manufacturing Consultant

    2 weeks ago

    Noida, Uttar Pradesh, India NTT DATA Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Job Title: Senior Manufacturing Consultant - High-Tech Industry Summary: Are you a strategic leader with a proven track record of optimizing manufacturing processes in the high-tech sector? As a Senior Manufacturing Consultant, you will lead our manufacturing operations, ensuring the highest levels of efficiency, quality, and innovation. You will work...

  • Senior Data Strategy Consultant

    4 days ago

    Noida, Uttar Pradesh, India NTT DATA North America Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Job Title: Senior Data Strategy ConsultantSummary:Are you passionate about leveraging data to drive strategic decisions and innovation in a dynamic industry? As a Senior Data Strategy Consultant, you will play a pivotal role in our journey to become a data-driven organization. You will design and implement comprehensive data strategies that align with our...