Overview

vConstruct, a Pune-based Construction Technology company is seeking a Data Engineer for its AI Engineering team, a close-knit group of analysts and engineers supporting all data aspects of the business.

Responsibilities

• Design, develop, and maintain robust, scalable data pipelines and ETL/ELT processes to efficiently ingest, transform, and store data from diverse sources.
• Collaborate with cross-functional teams to design, implement, and sustain data-driven solutions that optimize data flow and system integration.
• Develop and maintain pipelines to move data in real-time (streaming), on-demand, and batch modes—whether inbound to a central data warehouse, outbound to other systems, or point-to-point—focusing on security, reusability, and data quality.
• Implement pipelines with comprehensive error-handling mechanisms that are visible to both technical and functional teams.
• Ensure optimized pipeline performance with timely data delivery, including appropriate alerts and notifications.
• Adhere to data engineering best practices for code management and automated deployments, incorporating validation and test automation across all data engineering efforts.
• Perform debugging, application issue resolution, root cause analysis, and assist in proactive/preventive maintenance.
• Collaborate with the extended data team to define and enforce standards, guidelines, and data models that ensure data quality and promote best practices.
• Write and execute complete testing plans, protocols, and documentation for assigned portions of the data system or components; identify defects and create solutions for issues with code and integration into data system architecture.
• Work closely with data analysts, business users, and developers to ensure the accuracy, reliability, and performance of data solutions.
• Monitor data performance, troubleshooting issues, and optimize existing solutions.
• Create and maintain technical documentation related to data architecture, integration flows, and processes.
• Organize and lead discussions with business and operational data stakeholders to understand requirements and deliver solutions.
• Partner with analysts, developers, and business users to build data solutions that are scalable, maintainable, and aligned with business objectives.

Qualifications

• 3 to 6 years of experience as a Data Engineer, with a focus on building scalable data solutions.
• Over 3 years of experience in scripting languages such as Python for data processing, automation, and ETL development.
• 3+ years of hands-on experience working with Snowflake.
• 3+ years of experience with data integration tools such as Azure Data Factory, Fivetran, or Matillion.
• Strong experience in writing complex, highly optimized SQL queries on large datasets (3+ years).
• Deep expertise in SQL, with a focus on database performance tuning and optimization.
• Experience working with data platforms like Snowflake, Azure Synapse, or Microsoft Fabric.
• Proven experience integrating APIs and handling diverse data sources.
• Ability to understand, consume, and utilize APIs, JSON, and web services for building data pipelines.
• Experience designing and implementing data pipelines using cloud platforms such as Azure or AWS.
• Familiarity with orchestration tools like Apache Airflow or equivalent.
• Experience with CI/CD practices and automation in data engineering workflows.
• Knowledge of dbt or similar tools for data transformation is a plus.
• Familiarity with Power BI or other data visualization tools is a plus.
• Strong problem-solving skills with the ability to troubleshoot complex data issues.
• Excellent communication skills and a collaborative mindset to work effectively in team environments.
• Integrity is Integral
• People are Pivotal
• Ever Forward Spirit

Education

• Bachelor’s or Master’s degree in Computer Science/Information technology or related field.
• Equivalent academic and