Senior Data Engineer

vConstruct, a Pune-based Construction Technology company is seeking a Senior Data Engineer for its Data Science and Analytics 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

• Act as the SME for data warehousing architecture, overseeing the design patterns, data transformation processes, and operational functions of the data warehouse.
• Provide hands-on support for performance tuning, monitoring, and alerting, specifically within the Snowflake environment.
• Manage all facets of Snowflake administration, including role-based access control, environment monitoring, and performance optimization.
• Analyze complex data patterns to design and implement scalable, efficient data storage solutions in Snowflake.
• Define and document best practices for creating data models (source and dimensional), ensuring consistency across the organization.
• Mentor team members in data modeling techniques and work with business users to capture and implement data requirements.
• Architect and implement scalable, efficient data pipelines using Snowflake and DBT to support data processing and transformation.
• Build and optimize data models, warehouses, and data marts to drive business intelligence and analytics initiatives.
• Write clean, efficient, and reusable SQL queries within DBT to manage data transformations and ensure high-quality results.
• Establish and enforce data quality checks, validation processes, and continuous monitoring using DBT to maintain data integrity.
• 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.
• Organize and lead discussions with business and operational data stakeholders to understand requirements and deliver solutions.
• Collaborate with data analysts, developers, and business users to ensure data solutions are accurate, scalable, and efficient.

Qualifications

• 8 to 10 years of experience in data engineering, with a focus on building data solutions at scale.
• 5+ years of experience in data warehousing and data modeling techniques (both relational and dimensional).
• 5+ years of hands-on experience in writing complex, highly optimized SQL queries across large data sets.
• 4+ years of hands-on experience working with Snowflake.
• 4+ years of experience in scripting languages like Python etc.
• 2+ years of experience using DBT (Data Build Tool) for data transformation.
• Expertise in SQL with a strong focus on database optimization and performance tuning.
• Proven experience in data warehousing technologies such as Snowflake including administration, performance tuning, and implementation of best practices.
• Extensive hands-on experience with DBT (Data Build Tool) for data transformation, including developing and maintaining modular, reusable, and efficient DBT models.
• Strong ability to write and optimize DBT SQL models for transformation layers and data pipelines.
• Hands-on experience with data integration tools like Azure Data Factory, FiveTran, or Matillion with a preference for FiveTran.
• Proven experience with API integrations and working with diverse data sources.
• Ability to understand, consume and use API’s, JSON, Webservices for data pipelines.
• Experience in designing and implementing data pipelines using cloud platforms such as AWS, GCP, or Azure.
• Proficient in Python for data transformation and automation.
• Experience with CI/CD processes and automation in data engineering.
• Knowledge of Power BI or similar data visualization tools is a plus.
• Excellent communication skills, with the ability to work collaboratively in a team environment.

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 specializes in providing high quality Building Information Modeling and Construction Technology services geared towards construction projects. vConstruct is a wholly owned subsidiary of DPR Construction.vConstruct has 100+ team members working on Software Development, Data Analytics, Data Engineering and AI/ML. We have matured Data Science practice and growing at accelerated pace.

For more information, please visit www.vconstruct.com

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