We are seeking a skilled Data Architect with expertise in Azure and ADF to design and implement data solutions in the Motor Fleet Insurance domain.
Job Title: Data Architect – Azure & Databricks (Motor Fleet Insurance Domain) Role Overview We are seeking a highly skilled Data Architect with deep expertise in Azure and ADF, who can design and implement scalable data solutions, including data warehouses, lakehouses, and data pipelines. The ideal candidate will have extensive experience in data modeling (fact and dimension tables), data migration strategies, and hands-on knowledge of on-prem SQL warehouses (preferably Oracle PL/SQL). Domain expertise in Insurance is critical for this role to effectively align data architecture with business needs. Required Skills & Experience • 10+ years of experience in Data Architecture, Data Engineering, and Data Warehousing. • Strong expertise in Azure Data Platform (Azure Data Lake, Synapse Analytics, Azure Data Factory, Databricks). • Data Modeling Expertise – Fact/Dimension tables, star and snowflake schemas. • Experience designing and implementing Lakehouse architectures and hybrid data platforms. • Strong in SQL and Oracle PL/SQL for legacy warehouse management. • Proven track record of large-scale data migration projects. • Domain expertise in Insurance (Motor Claims Risk Insurance, Policy, Claims, Underwriting data models). • Strong understanding of ETL/ELT frameworks, performance tuning, and best practices. • Familiarity with Power BI or other BI tools for reporting and analytics enablement. • Azure certifications (e.g., Azure Data Engineer, Azure Solutions Architect) are a plus
Similar Jobs
Information Technology • Consulting
Lead design, development, and optimization of large-scale Azure data pipelines using Databricks, Synapse, and ADF. Build scalable solutions on ADLS Gen2, design ETL/ELT and data models, ensure data quality, security compliance, and implement CI/CD for data workflows via Azure DevOps. Mentor teams and maintain best practices for PySpark/SparkSQL and integration with Informatica/SQL.
Top Skills:
Adls Gen2Azure Data Factory (Adf)Azure DatabricksAzure DevopsCi/CdData ModelingInformaticaPysparkSparksqlSQLSynapse Analytics
Information Technology • Consulting
Design and optimize Snowflake cloud data warehouses using advanced Snowflake features (Cortex AI, Snowpark ML, MLOps, Horizon Catalog). Build scalable ETL/ELT pipelines with cloud-native AWS services (S3, Lambda, SQS, SNS) and Snowflake-native options (Snowpipe, stages, data sharing). Implement data modeling (star, snowflake, Data Vault) and use tools like dbt, Matillion, or Informatica Cloud. Familiarity with Kafka and Python is a plus.
Top Skills:
AWSCortex AiData SharingDbtHorizon CatalogInformatica CloudKafkaLambdaMatillionMlopsPythonS3SnowflakeSnowpark MlSnowpipeSnsSqsStagesStreamlit Apps
Information Technology • Consulting
Design and implement scalable cloud data platforms and pipelines. Build and maintain ingestion, transformation, orchestration workflows. Architect and optimize Snowflake data warehouses, tune SQL for large datasets, implement Terraform automation, and mentor developers while contributing hands-on to backend data processing.
Top Skills:
AzureJavaPythonSnowflakeSQLSsisTerraform
What you need to know about the Delhi Tech Scene
Delhi, India's capital city, is a place where tradition and progress co-exist. While Old Delhi is known for its rich history and bustling markets, New Delhi is defined by its modern architecture. It's clear the region places a strong emphasis on preserving its cultural heritage while embracing technological advancements, particularly in artificial intelligence, which plays a central role in shaping the city's tech landscape, fueled by investments in research and development.
