Data Engineer

Ashirvad Pipes; Bengaluru; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Ashirvad Pipes is seeking a data warehousing Architect/Lead with 3–5 years in data analytics and digital solutions, including 2+ years in analytics and Lakehouse exposure. You will guide the data engineering team, design ETL/ELT pipelines, and implement Snowflake-based solutions integrated with Cortex AI/AWS Bedrock to drive business insights in finance, accounts, and manufacturing.

Key responsibilities include architecture leadership, data modeling, and ensuring data quality across sources

Qualifications

• Experience in data warehousing architecture, design and development.
• Hands-on with ETL/ELT, data integration, and data modeling.
• Exposure to Lakehouse architecture and modern analytics ecosystems.
• Knowledge of Cortex AI, AWS Bedrock, Copilot Studio is a plus.

Responsibilities

• Lead architecture, design and development of data warehousing solutions.
• Mentor data engineering team and provide technical guidance.
• Ensure best practices in ETL/ELT, data accuracy and integration.
• Design, develop and optimize ETL/ELT pipelines using industry-standard tools.
• Monitor and troubleshoot ETL/ELT processes for timely data loading.
• Implement and manage Snowflake data warehousing solutions and AWS Glue tasks.
• Leverage AI/ML to extract insights from large datasets.
• Collaborate with stakeholders to analyze business requirements.

Skills

Data warehousing

ETL/ELT pipelines

Snowflake

AWS Glue

Python

Java

SQL database design

Cortex AI

AWS Bedrock

Analytics

Cloud ETL/ELT

Education

BTech in Computer Science or IT

Job description

Responsibilities:

• Lead the architecture, design, and development of data warehousing solutions.

• Provide technical guidance and mentorship to the data engineering team.

• Ensure best practices in data warehousing, ETL / ELT processes, and data integration.

• Design, develop, and optimize ETL / ELT pipelines using industry-standard tools.

• Ensure data accuracy, integrity, and consistency across data sources.

• Monitor and troubleshoot ETL / ELT processes to ensure timely and accurate data loading.

• Implement and manage data warehousing solutions using Snowflake.

• Utilize AWS Glue for data integration and ETL / ELT tasks.

• Optimize data storage and retrieval processes to enhance performance.

• Apply AI/ML concepts to extract insights from large datasets.

• Integrate AI solutions like Cortex AI/AWS Bedrock into the data warehousing environment.

• Leverage knowledge in Finance, Accounts, and Manufacturing to understand business requirements.

• Develop data solutions that address specific needs within these domains.

• Collaborate with stakeholders to gather and analyse business requirements

Requirement:

• Overall, 3 to 5 years’ experience in which 2+ years of experience in Data Analytics and Digital solutions with exposure to Lake house architecture

• BTech in Computer Science or IT

• Technical expertise with data models, data mining, and segmentation techniques

• Knowledge of programming languages (e.g. Java and Python) and with hands‑on experience with SQL database design

• Exposure to Cortex AI, AWS Bedrock, Copilot studio (good to have)

• Strong analytical and problem‑solving skills. Strong influencing and communication skills (written, verbal, presentation) with the ability to be a thought partner/ coach to internal team

• Should have exposure to Cloud ETL/ ELT, Cloud DWH, AI and ML tools

• Domain expertise in Finance, Accounts, and Manufacturing.

• Exposure to agile software development, and/or development management

• Positive attitude and motivation to deliver and ensure highest quality deliverables. Able to respond positively and calmly to shifting priorities, demands and timelines

For additional details regarding submission eligibility and payment terms, please refer to your contract. Only submissions from agencies with current service contracts in place will be considered.