Job Title: Data Architect & Technical Engineering Lead
Location: Preferred - Gurgaon, Noida; Secondary - Bangalore, Mumbai, Hyderabad, Pune, Chennai - India (Hybrid - Up to 3 days a week in-office)
Why Join Us
- Architect the Core: Lead the foundational data strategy for a transformative platform reshaping advertising, media, and retail.
- Lead a Multi-Disciplinary Team: Act as the technical North Star for Front-End Engineers, UI/UX Designers, Data Engineers, and BI Experts.
- Innovation at Scale: Work within a high-growth consulting environment that combines startup agility with enterprise impact.
- Global Collaboration: Partner with a creative, forward-thinking global team to build a world-class Retail Media Network Accelerator.
Role Description
We are seeking a visionary Data Architect & Engineering Lead to spearhead the technical direction of our data-driven platforms. You will be responsible for the end-to-end data lifecycle - from ingestion and sophisticated modeling to seamless visualization. As a lead, you won't just design schemas; you will mentor a diverse engineering squad (covering UI/UX, Front-end, and Data) to ensure that the data layer powers a high-performance, scalable SaaS application.
Key Responsibilities
- Engineering Leadership: Serve as the primary technical lead for a cross-functional team, ensuring architectural alignment between the backend data structures and the front-end/UI implementations.
- Data Modeling & Strategy: Design and maintain scalable data models (Landing, Cleansed, Staging, and Golden layers) that support complex retail media analytics.
- Pipeline Orchestration: Architect and oversee the development of robust ETL/ELT pipelines using Airflow/Composer, ensuring efficient incremental and full-load processing.
- System Integration: Oversee the integration of Firebase for real-time application needs and BigQuery for heavy-duty analytical processing.
- Technical Governance: Define best practices for SQL Stored Procedures (SPs), UDFs, and Python-based data processing scripts to optimize performance and cost.
- Stakeholder Management: Translate high-level business objectives into technical roadmaps, bridging the gap between Experience Designers and Data Engineers.
- Performance Optimization: Ensure high-speed data delivery for Looker and Power BI dashboards, enabling real-time decision-making for clients.
Must-Have Skillset
- Cloud Expertise: Deep proficiency in Google Cloud Platform (GCP), specifically BigQuery (BQ), Google Cloud Storage (GCS), and Cloud Composer.
- Orchestration & Code: Expert-level knowledge of Airflow/DAGs and Python for data engineering.
- Advanced SQL: Mastery of complex SQL, including Stored Procedures, Functions, and query optimization for large-scale datasets.
- Data Modeling: Proven experience in dimensional modeling, data vault, or schema-on-read architectures within a cloud environment.
- App Integration: Strong understanding of Firebase (Firestore/Realtime Database) and how it interacts with analytical data warehouses.
- ETL/ELT Logic: Comprehensive understanding of Ingestion, Data Processing, and handling both Incremental and Full-load scenarios.
- Leadership: Experience leading/mentoring a team of Data Engineers, Front-End Developers, and BI Specialists.
- Education: Bachelor's or Master's degree in Computer Science, Data Science, or a related technical field.
Tech Stack
- Data Warehouse: Google BigQuery
- Orchestration: Apache Airflow / Google Cloud Composer
- Languages: Python, SQL (Advanced)
- App/Backend: Firebase, Google Cloud Functions
- Storage: GCS (Google Cloud Storage)
- BI/Visualization: Looker, Power BI
- DevOps: GIT, BitBucket, CI/CD Pipelines
Preferred Experience
- Retail/MarTech: Prior experience building Retail Media Networks or Customer Data Platforms (CDPs).
- Identity Resolution: Knowledge of matching and merging data for unified customer views.
- Design Literacy: Familiarity with UI/UX workflows (Figma) to better lead the design-to-data integration.
- Agile: Experience leading sprints in a fast-paced, asynchronous, multi-geographic environment.
