2+ Dimensional modeling Jobs in Mumbai | Dimensional modeling Job openings in Mumbai

Visionyle is Hiring Senior Data Architect - Data Modeller for Capita

Job Details

Job Title : Senior Data Architect - Data Modeller

Job location : Initial - WFH after it may converted into Hybrid

Payroll firm : Visionyle Solutions ( www.visioyle.com)

Job Type: FTE

Job Description:

Mandatory

• Relevant Experience Required : 7+ years
• Experience in Third normal form, Data Vault, Dimensional (Kimball) data modelling
• Experience / certification in Databricks or Snowflake

Job Description

• Lead the design and implementation of efficient data solutions tailored to meet the specific needs of the clients.
• Design and optimise data architectures following standards and best practices.
• Provide technical leadership to architects, analysts and developers guiding them in the development of high-quality data solutions following best practices.
• Evaluate and recommend appropriate technologies, tools and platforms to support data architecture initiatives.
• Enforce data governance standards, data quality controls and best practices to maintain the accuracy, reliability and security of the data.
• Ensure compliance with regulatory, data privacy, security policies and requirements in Data Management.
• Collaborate with clients to understand requirements and provide guidance.
• Drive initiatives to enhance efficiency and effectiveness.
• Create and maintain comprehensive design documentation to support Project implementation and knowledge transfer.
• Keep up-to-date with industry trends, best practices, and emerging technologies.
• Contribute to proposals and sales efforts
• Mentor and provide guidance to junior team members

Recent Photo

Name as Per PAN

Current CTC :

Expected CTC :

Notice Period / LWD / Joining Time:

Offer in Hand Details (if any) :

Reason for change :

Ok for C2H :

ROLES AND 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.