Data Engineer - DSA

Data Engineer – AI Engineering

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. You will be responsible for designing, developing, and maintaining our data infrastructure, ensuring data integrity, and supporting various data-driven projects. You will work closely with cross-functional teams to integrate, process, and manage data from various sources, enabling business insights and enhancing operational efficiency.

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

Education

Bachelor’s or Master’s degree in Computer Science/Information technology or related field.

Equivalent academic and work experience can be considered.

About vConstruct: vConstruct is a wholly owned subsidiary of DPR Construction and specializes in providing high quality Building Information Modeling and Construction Technology services geared towards construction projects. vConstruct presently constitutes of five business units: 1. Virtual designing and construction 2. Project Admin Services 3. Software Development 4. Accounting Services for Projects and 5. Data Science and Analytics

Core Values of vConstruct are:

• Integrity is Integral
• People are Pivotal
• Ever Forward Spirit

About DPR Construction:

DPR Construction is a national commercial general contractor and construction manager specializing in technically challenging and sustainable projects for the advanced technology, biopharmaceutical, corporate office, and higher education and healthcare markets. With the purpose of building great things—great teams, great buildings, great relationships—DPR is a truly great company. For more information, please visit www.dpr.com.

Customer Relationship

Personal Evolution

Autonomy

Administrative Work

Technical Expertise