Data Engineering

Job Title: Data Engineer
Role: Full Time
Location: Mumbai 
Experience: 2+ years

About Us: As India's fastest-growing D2C brand, we are at the forefront of innovation and transformation in the market. We’re a well-funded, rapidly growing (we have recently launched our 100th store), omnichannel D2C brand with a passionate and innovative team.

Job Summary: We are seeking a Data Engineer to help us design, build and maintain our BigQuery data warehouse by performing ETL operations and creating unified data models. You will work across various data sources to create a cohesive data infrastructure that supports our omnichannel D2C strategy.

Key Responsibilities:

ETL Operations: Design, implement, and manage ETL processes to extract, transform, and load data from various sources into BigQuery

Data Warehousing: Build and maintain a robust data warehouse in BigQuery, ensuring data integrity, security, and performance

Data Modeling: Create and manage flat, unified data models using SQL and DBT to support business analytics and reporting needs

Performance Optimization: Optimize ETL processes and data models to ensure timely data delivery for reporting and analytics

Collaboration: Work closely with data analysts, product managers, and other stakeholders to understand data requirements and deliver actionables

Documentation: Maintain comprehensive documentation of data workflows, ETL processes, and data models for reference and onboarding

Troubleshoot: Monitor and troubleshoot data pipeline issues, ensuring timely resolution to minimize disruption to business operations.

Skills and Qualifications:

1. Proficiency in SQL and experience with BigQuery
2. Minimum 2 years of experience in data engineering or a similar role
3. Experience with data pipeline and ETL tools (e.g., Apache Airflow, Talend, AWS Glue)
4. Familiarity with cloud platforms (e.g., AWS, Google Cloud, Azure) and their data services
5. Experience with data warehousing solutions (e.g., Amazon Redshift, Google BigQuery, Snowflake)
6. Knowledge of data modeling, data architecture, and data governance best practices.
7. Excellent problem-solving skills and attention to detail
8. Knowledge of DBT (Data Build Tool) for data transformation
9. Self-motivated, proactive, and highly accountable
10. Excellent communication skills to effectively convey technical concepts and solutions

Bonus point - Prior experience in E-commerce or D2C space