Data Architect (Dremio Lakehouse)

Job description: Data Architect – Databricks / AWS

Job Summary

We are looking for an experienced Data Architect to define and drive the target data architecture for the Horizon MVP and its future evolution. The role will be responsible for designing a scalable, secure, governed cloud data platform covering ingestion, storage, processing, analytics, APIs, and downstream data consumption.

The architect will work closely with Data Engineering, Backend, DevOps, QA, and business stakeholders to establish architecture standards and ensure the platform is ready for advanced analytics, AI/ML, vector storage, and future LLM-based capabilities.

• Job Title: Data Architect
• Experience: 8+ Years
• Relevant Architecture Experience: 3+ Years in Data Architecture
• Location: Chennai / Pune
• Work Mode: Hybrid – 3 Days WFO
• Budget: Up to 24 LPA
• Payroll: Haparz
• Notice Period: Immediate Preferred

Key Responsibilities

• Define the target data architecture for the Horizon MVP and establish an architecture roadmap for future scalability.
• Design end-to-end architecture covering data ingestion, storage, processing, serving, reporting, APIs, and downstream applications.
• Establish canonical data models and schemas for travel signals, corridors, sources, evidence, scores, and generated insights.
• Define data normalization strategies for structured, semi-structured, and unstructured data from multiple external sources.
• Design and govern the Databricks platform architecture, including Unity Catalog, data schemas, access controls, and governance standards.
• Establish data-retention, lineage, data-quality, security, privacy, and compliance controls.
• Define secure integration patterns between Databricks, AWS PRODIGY, SharePoint, external APIs, and downstream applications.
• Design scalable data processing for 30-day signal windows, convergence/divergence scoring, corridor ranking, and spike detection.
• Define architecture patterns that support future vector storage, embeddings, LLM integration, and multi-year analytics.
• Design reliable batch and API-driven ingestion frameworks for structured and unstructured data.
• Review technical designs, identify architectural risks, and provide technical direction to engineering teams.
• Guide backend, data engineering, DevOps, and QA teams in implementing architecture standards.
• Ensure architecture decisions align with enterprise security, RBAC, PII handling, privacy, and operational requirements.
• Communicate architecture decisions, trade-offs, and technical recommendations effectively to technical and business stakeholders.
• 
  

What We’re Looking For

• 8+ years of experience in data engineering, data platforms, or data architecture, with at least 3+ years in a Data Architect capacity.
• Strong hands-on experience designing cloud-based data platforms, lakehouses, or analytical platforms.
• Advanced knowledge of Databricks, Apache Spark/PySpark, Delta Lake, and Unity Catalog.
• Strong understanding of AWS data services, IAM, networking, and secure cloud integration patterns.
• Strong expertise in data modelling, metadata management, data lineage, data quality, retention, and governance.
• Experience architecting batch and API-based ingestion pipelines for structured, semi-structured, and unstructured data.
• Understanding of AI/ML workloads, feature pipelines, vector databases, embeddings, and LLM integration patterns.
• Experience designing APIs and downstream data-serving architectures.
• Strong knowledge of PII protection, RBAC, data privacy, and enterprise security controls.
• Excellent architectural communication and stakeholder-management skills.

Strong Databricks Architect Profile with end-to-end Lakehouse ownership

2

Mandatory (Experience 1) – Must have 10+ years of software engineering experience with atleast 5+ years in Data Engineering with hands on exposure to Databricks and strong ownership of end-to-end data pipeline development.

3

Mandatory (Experience 2) – Must have atleast 5+ years of expertise across the Databricks ecosystem — Delta Lake, Delta Live Tables, Autoloader, Structured Streaming, Workflows, Unity Catalog

4

Mandatory (Tech skill 1) – Must have worked at architecture level, owning end-to-end design through deployment

5

Mandatory (Tech skill 2) – Must have strong experience with Python and SQL for data processing and Apache Spark for performance tuning & scalability

6

Mandatory (Tech skill 3) – Must have experience in large-scale data warehousing & advanced data modeling (3NF and dimensional) across batch and real-time systems

7

Mandatory (AI Exposure) – Must have at least a basic working understanding of how AI services or tools work

8

Mandatory (Communication) – Must have strong stakeholder management & requirement-gathering experience with US or UK clients

9

Mandatory (Company) – Must come from a B2B IT services or IT consulting background

10

Mandatory (Note) – CTC is inclusive of 5% variable

11

Preferred (Tech skill 1) – Azure Databricks or Azure data services experience (project runs on Azure DevOps)

12

Preferred (Tech skill 2) – MLflow or MLOps practices and AI use cases (RAG, AI/BI)

13

Preferred (Tech skill 3) – CI/CD, Databricks Asset Bundles (DABs) or equivalent packaging, Terraform or IaC, reusable deployment templates

14

Preferred (Integrations) – ServiceNow or enterprise system integrations

15

Preferred (Certifications) – Databricks (Data Engineer Associate or Professional, ML or GenAI tracks), Azure or AWS cloud certifications

Example:

We are looking for an experienced Data Architect to design, develop, and manage the organization's enterprise data architecture. The candidate will be responsible for building scalable data platforms, ensuring data quality and governance, and supporting business analytics through modern data solutions.

Experience Required

Mention the minimum years of experience.

Example:

• Minimum 12 years of experience in Data Architecture, Data Engineering, or related fields.
• 5+ years of experience in the Banking/Financial Services domain is preferred.

Educational Qualification

Mention the required degree.

Example:

• BE/BTech in Computer Science, Information Technology, Software Engineering, Electronics & Communication Engineering, or equivalent.
• OR MCA/MTech/MSc in Computer Science, IT, or related disciplines.
• MBA is preferred.

Technical Skills

List the skills the candidate must have.

Example:

• AWS, Azure, or GCP
• Data Warehousing (DWH)
• ETL/ELT
• Database Management
• Data Modeling
• Data Analytics
• Data Lakes
• Data Governance

Key Responsibilities

Convert the points you received into simple action statements.

Example:

• Design and maintain enterprise data architecture.
• Develop data warehouses and data lakes.
• Define data standards and governance policies.
• Ensure data quality and security.
• Design ETL/ELT processes.
• Integrate data from multiple systems.
• Plan and execute data migration projects.
• Review existing data architecture and recommend improvements.
• Provide technical guidance to project teams.
• Evaluate new data technologies and tools.

Preferred Skills

These are not mandatory but are an advantage.

Example:

• Banking domain experience
• Strong analytical and problem-solving skills
• Good communication skills
• Leadership and stakeholder management
• Experience mentoring technical teams

Solution Architect – AZURE Data Engineering

Job Overview

We are looking for an experienced Solution Architect – Data Engineering with strong expertise in designing data solutions and hands-on experience with Azure, Synapse, PySpark, Data Warehousing, and Data Lakes. The ideal candidate should have strong architectural and data engineering knowledge.

Key Responsibilities

• Design and implement scalable data architecture and solutions.
• Develop and manage Data Warehouse and Data Lake architectures.
• Design data platforms using Medallion Architecture.
• Lead Data Engineering and ETL activities.
• Work with Azure Synapse Analytics for data processing and analytics.
• Develop data solutions using PySpark / Apache Spark.
• Define and implement data validation and data quality processes.
• Collaborate with business, data, and technology teams to deliver effective data solutions.

Required Skills

• Strong experience in Solution Architecture / Data Architecture.
• Strong knowledge of Data Warehouse and Data Lake architecture.
• Good understanding of Medallion Architecture.
• Strong experience in Data Engineering and ETL.
• Hands-on experience with Microsoft Azure and Azure Synapse Analytics.
• Strong knowledge of PySpark / Apache Spark.
• Experience with Data Validation and Data Quality.
• Good communication and stakeholder management skills.
• 
  

Experience

8+ Years

Hiring : Senior Databricks AI Architect

Exp : 15 - 18 yrs

Work Location : Pune WFO

Skills :

10 +years of experience in Data Engineering, Data Architecture, Analytics, or Software Engineering.

Minimum 5 years of hands-on experience with Databricks (Mandatory).

Strong expertise in designing and implementing enterprise-scale data platforms on Databricks.

Hands-on experience with AI-powered engineering tools such as Databricks Genie, Cursor, GitHub Copilot, or similar AI platforms.

Strong proficiency in Python, SQL, Spark, Delta Lake, and Databricks notebooks.

Excellent communication, stakeholder management

10+ years of experience in Data Architecture, Data Engineering, or Data Platforms

• Strong expertise in IBM DB2 / On-Prem Relational Databases

• Strong expertise in PostgreSQL

• Hands-on experience with the Azure Data Ecosystem, including:

▪ Azure Data Factory (ADF)

▪ Azure Data Lake Storage Gen2 (ADLS Gen2)

▪ Azure Databricks / Synapse Analytics

▪ Azure Event Hub / Service Bus

▪ Azure Functions

Data Engineer

Data Lakehouse & Platform Engineering 

About the Role

We are hiring Data Engineer to own the lifecycle of our enterprise Data Lakehouse platform. We are looking for engineers who think in systems, make platform-level design decisions, and can build and operate a production-grade, multi-source lakehouse from the ground up, covering ingestion through consumption across a complex, multi-cloud source landscape.

You will be the technical authority for a platform that consolidates data from 18+ enterprise products (Costpoint, GovWin, Specpoint, Vantagepoint, and others) into a governed, medallion-architected data lake on AWS S3 with Apache Iceberg table format, orchestrated via AWS Step Functions, and queryable through AWS Athena and Trino. This role is end-to-end: you own ingestion, transformation, quality, orchestration, ML data supply, and BI consumption.

Key Responsibilities

•      Architect and evolve the full medallion lakehouse — Bronze, Silver, and Gold layers — on AWS S3 with Apache Iceberg; own schema design, partitioning, compaction, and retention policies.

•      Design and implement scalable Glue ETL (PySpark) pipelines for bronze_to_silver and silver_to_gold transformations, incorporating dbt for SQL-layer transformations where appropriate.

•      Own and extend CDC ingestion via Fivetran; manage schema evolution, connector health, and sync reliability across 18+ source products.

•      Build and maintain AWS Step Functions state machines and EventBridge schedules for end-to-end pipeline orchestration; implement Lambda-based quality and drift monitors.

•      Govern the Glue Catalog and Lake Formation policies; enforce column-level security, row-level access controls, and audit logging to meet SOC2 and regulatory requirements.

•      Architect the query layer — optimize Athena workgroups and partition pruning; plan and execute Trino-on-EKS deployment for sub-second analytics workloads.

•      Partner with data science teams on SageMaker data supply: feature engineering pipelines, training dataset preparation, and model registry integration.

•      Implement real-time and near-real-time streaming solutions using Kafka or Kinesis where sub-13-minute latency is required.

•      Lead platform modernization initiatives: evaluate emerging formats (Iceberg vs. Delta Lake vs. Hudi), tooling, and cost optimization strategies.

•      Establish and enforce data engineering best practices: code reviews, CI/CD for pipeline code, IaC (Terraform / CloudFormation), and incident response runbooks.

•      Mentor and level up junior and mid-level data engineers; define team standards for pipeline design, testing, and documentation.

Required Qualifications

•      Software or data engineering experience, with at least 4 years in an architect or technical lead capacity designing large-scale cloud data platforms.

•      Deep, hands-on expertise with AWS data services: S3, Glue (PySpark ETL), Athena, Step Functions, Lambda, EventBridge, Lake Formation, SageMaker, and CloudWatch.

•      Production experience with Apache Iceberg (or Delta Lake / Hudi) table formats — compaction, snapshot management, schema evolution, and time travel.

•      Strong PySpark and Python skills; ability to write, review, and optimize distributed data processing jobs at scale.

•      Hands-on experience with CDC-based ingestion platforms (Fivetran, Debezium, or equivalent) across heterogeneous source systems.

•      Proven experience designing and implementing medallion (Bronze/Silver/Gold) or equivalent multi-hop lakehouse architectures.

•      Experience with data pipeline orchestration: AWS Step Functions, Apache Airflow, or equivalent; event-driven pipeline design patterns.

•      Strong SQL skills; experience with Athena, Trino, Presto, or equivalent query engines for large-scale analytical workloads.

•      Familiarity with data governance tooling: catalog management (Glue Catalog, Apache Polaris/Iceberg REST), data lineage, access controls, and audit frameworks.

•      Experience with Infrastructure as Code (Terraform or CloudFormation) for data platform provisioning and drift management.

•      Solid understanding of dimensional modeling, schema design (star/snowflake), and data normalization for BI and analytics workloads.

•      Bachelor's degree in Computer Science, Engineering, or a related field; or equivalent professional experience.

Preferred Qualifications

•      Experience operating Trino or PrestoDB on Kubernetes (EKS); tuning for sub-second query latency and multi-tenant workloads.

•      Familiarity with streaming platforms (Kafka, Kinesis, or Pub/Sub) and real-time lakehouse patterns.

•      Experience with Apache Polaris or other Iceberg REST catalog implementations.

•      Exposure to SageMaker MLOps pipelines, Model Registry, and feature store patterns for ML data supply.

•      Experience with dbt (data build tool) for SQL-layer transformation and documentation in lakehouse environments.

•      Government contracting or ERP domain knowledge (Costpoint, Deltek, Oracle, or similar enterprise platforms) is a strong plus.

•      AWS certifications: Data Engineer Associate, Solutions Architect Professional, or equivalent.

What You Will Build

You will be a founding architect of a strategic, cross-product data platform that serves 18+ enterprise applications and their analytics, ML, and AI workloads. The decisions you make on schema, storage format, query layer, governance, and orchestration will shape the data foundation of the company for years. This is a high-impact, high-ownership role with direct visibility to senior leadership.

Role Summary

We are looking for an accomplished PowerBi Solution architect to architect and drive scalable, insight-rich analytics solutions across the enterprise. This role sits at the intersection of data engineering, business intelligence, and solution architecture—ideal for a candidate with mastery of modern visualization tools, modeling strategies, and end-to-end data integration.

Key Responsibilities

● Architect and implement scalable Power BI solutions that span data modeling, integration, visualization, and performance tuning

● Design and lead the development of enterprise-grade data models using Star, Snowflake, and composite architecture

● Lead the integration of cloud-based data warehouse platforms including Oracle ADW and Snowflake

● Lead the development of scalable, interactive dashboards using Power BI, driving self-service analytics across business units

● Develop ETL and ELT pipelines to ingest and transform structured, semi-structured, and API-driven data sources

● Implement automated data ingestion and transformation using Python and shell scripting for performance and reliability

● Handle and harmonize data from diverse API sources across applications, platforms, and third-party services

● Deliver interactive dashboards and storytelling experiences tailored for executives, analysts, and operational teams

● Optimize semantic layers, DAX calculations, and deployment pipelines for reusability and governance

● Mentor BI developers and analysts, setting architectural standards and fostering collaboration across analytics teams

● Collaborate with cross-functional teams to translate strategic business goals into robust analytics solutions

Required Qualifications

● 8+ years in Power BI development and analytics Engineering, with 3+ years in architecture leadership roles

● Strong command of DAX, M Query, and performance tuning best practices

● Deep experience in data modeling (Star, Snowflake, composite) and cross-platform architecture

● Hands-on expertise in Oracle ADW, Snowflake, and API-based data ingestion

● Proficiency in Python, shell scripting, and automation of analytics pipelines

● Strong background in ETL/ELT development, data quality assurance, and deployment orchestration

● Demonstrated success in solution architecture across cloud ecosystems such as Azure, Oracle OCI

Preferred Skills

● Experience with Power BI Premium capacity management and deployment pipelines

● Experience with DAX, M language, and performance tuning technique

● Experience integrating third-party BI tools, data lakehouses, and stream processing services

● Effective communicator capable of translating technical architecture into business value

● Exposure to MS Fabric and Azure Data Factor

Job Description:

Position: Senior Data Engineer

Location: Chennai / Pune / Bangalore / Hyderabad

Working Type: WFO

Shift: UK Shift (2:00 – 11:00 PM)

Experience : 7+ years overall

Interviews: Assessment || 2 Interview rounds.

Notice Period: Immediate Joiner

Key Responsibilities

Implement ingestion, transformation, and optimization of enterprise data sources into Microsoft Fabric Lakehouse environments.

Configure and optimize Fivetran connectors (Oracle, SQL DB, etc.)

Manage large-volume ingestion and backfill operations

Implement Bronze to Silver transformation pipelines

Develop incremental load and CDC logic

Optimize Lakehouse performance and storage patterns

Implement monitoring (record counts, load duration, failure tracking)

Support Dev/Test/Prod promotion processes

Required Qualifications

7+ years of data engineering experience

Hands-on experience with Microsoft Fabric or Azure Synapse/Data Factory

Strong experience with Fivetran or similar ELT tools

Experience handling high-volume datasets (hundreds of millions of records)

Proficiency in SQL, Python, and data modeling concepts

Strong understanding of Medallion architecture.

Job Description

• Design and Implement Data Solutions: Lead the design, development, and implementation of scalable and secure Azure-

based data platforms, ensuring integration with various data sources and business systems. Deliver at least 2 major

projects every year with a focus on data engineering best practices.

• Optimize Data Pipelines: Build and optimize end-to-end data pipelines using Azure Data Factory, Azure Databricks, and

Azure Synapse, with an emphasis on automating data workflows. Achieve a 20% reduction in pipeline execution times

within the first 6 months.

• Cloud Infrastructure Management: Manage and maintain the Azure data environment, ensuring high availability, disaster

recovery, and cost optimization. Track and improve system uptime to exceed 99.9% reliability.

• Collaborate with Cross-Functional Teams: Partner with data scientists, data analysts, and business stakeholders to translate

business requirements into efficient data solutions. Facilitate at least 3 collaborative sessions per quarter to address key

business use cases.

• Ensure Data Security & Compliance: Implement data security measures, ensuring compliance with industry regulations

(GDPR, HIPAA, etc.) and company policies. Achieve and maintain full compliance in all data environments within the first

quarter of onboarding.

• Continuous Learning & Knowledge Sharing: Stay up-to-date with emerging Azure technologies, and mentor junior

engineers to promote knowledge sharing. Complete 1 Azure certification annually and conduct at least 2 internal

knowledge-sharing sessions per year.

• Sound knowledge of data governance practices, data quality management, and data security principles.

• Play a pivotal role in shaping our organization's data-driven journey, driving innovation through data analytics and insights.

• Optimize data storage, processing and retrieval mechanisms for performance, cost, and scalability using data storage

services (such as Azure Data Lake Storage, Azure SQL Database, etc.), data processing services (such as Azure Data Bricks,

Azure Synapse, etc.) and data visualization (PowerBI, Qlik, etc.) & integration services (Data API builder, logic apps, etc.)

• Monitor and troubleshoot data platform performance, identify and resolve issues, and provide recommendations for

continuous improvement.

• Collaborate with DevOps teams to automate deployment, configuration, and monitoring processes using Azure DevOps,

PowerShell, or other relevant tools.

• Stay up to date with the latest trends and advancements in cloud data services and provide recommendations on adopting

new technologies or features to enhance the data platform.

• Document technical designs, procedures, and guidelines for data platform engineering and operations

Knowledge, Skills & Experience

Job Experience • Bachelor's degree in Computer Science, Engineering, or a related field. Advanced

degree preferred.

• Proven 6-10 years experience in playing platform engineer or admin role

• Experience with big data technologies such as Apache Spark, Hadoop, or similar

frameworks.

• Solid understanding of cloud computing concepts and experience with cloud

infrastructure management and provisioning.

• Solid understanding of network security concepts and technologies (such as

firewalls, VPNs, intrusion detection/prevention systems, etc.) and data security

concepts and technologies (such as access controls, encryption, observability,

privacy laws/regulations, etc.)

• Experience in a Retail setup is preferred.

Required Skills The position will require someone with the following:

• Strategic Planning

Public

• Communication and Collaboration

• Problem Solving Skills A/B testing & experimentation

• SQL, BI tools, and storytelling with data