Important Note:

• This is a full-time opportunity with one of our confidential clients. The client name will be shared during the initial screening call with us/recruiter (after your profile is reviewed).
• In this posting, “we,” “us,” and “our” refer to the hiring client."Candidate" refer to you

Company Size: Startup / Small Enterprise

Experience Required: 5 - 17 years

Working Days: 5 days/week

No. of Positions: 1

Outstation Candidates: Allowed

Max Notice Period: 30

Office Location: Maharashtra, Mumbai/ Karnataka, Bengaluru / Telangana, Hyderabad / Haryana, Gurugram

Role & Responsibilities

You will be responsible for architecting, implementing, and optimizing Dremio-based data lakehouse environments integrated with cloud storage, BI, and data engineering ecosystems. The role requires a strong balance of architecture design, data modeling, query optimization, and governance enablement in large-scale analytical environments.

• Design and implement Dremio lakehouse architecture on cloud (AWS/Azure/Snowflake/Databricks ecosystem).
• Define data ingestion, curation, and semantic modeling strategies to support analytics and AI workloads.
• Optimize Dremio reflections, caching, and query performance for diverse data consumption patterns.
• Collaborate with data engineering teams to integrate data sources via APIs, JDBC, Delta/Parquet, and object storage layers (S3/ADLS).
• Establish best practices for data security, lineage, and access control aligned with enterprise governance policies.
• Support self-service analytics by enabling governed data products and semantic layers.
• Develop reusable design patterns, documentation, and standards for Dremio deployment, monitoring, and scaling.
• Work closely with BI and data science teams to ensure fast, reliable, and well-modeled access to enterprise data.

Ideal Candidate

• Bachelor’s or Master’s in Computer Science, Information Systems, or related field.
• 5+ years in data architecture and engineering, with 3+ years in Dremio or modern lakehouse platforms.
• Strong expertise in SQL optimization, data modeling, and performance tuning within Dremio or similar query engines (Presto, Trino, Athena).
• Hands-on experience with cloud storage (S3, ADLS, GCS), Parquet/Delta/Iceberg formats, and distributed query planning.
• Knowledge of data integration tools and pipelines (Airflow, DBT, Kafka, Spark, etc.).
• Familiarity with enterprise data governance, metadata management, and role-based access control (RBAC).
• Excellent problem-solving, documentation, and stakeholder communication skills.

Preferred:

• Experience integrating Dremio with BI tools (Tableau, Power BI, Looker) and data catalogs (Collibra, Alation, Purview).
• Exposure to Snowflake, Databricks, or BigQuery environments.
• Experience in high-tech, manufacturing, or enterprise data modernization programs.

Mandatory

• Strong Dremio / Lakehouse Data Architect profile
• Mandatory (Experience 1) – 5+ years of experience in Data Architecture / Data Engineering, with minimum 3+ years hands-on in Dremio
• Mandatory (Experience 2) – Strong expertise in SQL optimization, data modeling, query performance tuning, and designing analytical schemas for large-scale systems
• Mandatory (Technical Skills 1) – Deep experience with cloud object storage (S3 / ADLS / GCS) and file formats such as Parquet, Delta, Iceberg along with distributed query planning concepts
• Mandatory (Technical Skills 2) – Hands-on experience integrating data via APIs, JDBC, Delta/Parquet, object storage, and coordinating with data engineering pipelines (Airflow, DBT, Kafka, Spark, etc.)
• Mandatory (Architecture) – Proven experience designing and implementing lakehouse architecture including ingestion, curation, semantic modeling, reflections/caching optimization, and enabling governed analytics
• Mandatory (Governance) – Strong understanding of data governance, lineage, RBAC-based access control, and enterprise security best practices
• Mandatory (Stakeholder Management) – Excellent communication skills with ability to work closely with BI, data science, and engineering teams; strong documentation discipline
• Mandatory (Company) – Candidates must come from enterprise data modernization, cloud-native, or analytics-driven companies

Preferred

• Preferred (Nice-to-have) – Experience integrating Dremio with BI tools (Tableau, Power BI, Looker) or data catalogs (Collibra, Alation, Purview); familiarity with Snowflake, Databricks, or BigQuery environments

Screening Questions: (You must answer this along with the professional summary of the application):

• How many years of experience you have with Dremio?
• Which is your preferred job location (Mumbai / Bengaluru / Hyderabad / Gurgaon)?
• Are you okay with 3 Days WFO?
• Virtual Interview requires video to be on, are you okay with it?
• Do you have hands-on configuration and setup experience using Dremio? (If yes, this experience must be clearly mentioned in your CV.)