Databricks Architect with P&C
Role details
Job location
Tech stack
Job description
We are seeking an experienced Data & Analytics Architect to lead the design and delivery of modern cloud-native data platforms and analytics solutions for clients in the Commercial Property & Casualty (P&C) Insurance domain. This role requires deep expertise in AWS-based data architectures, modern data platforms, enterprise data strategy, and insurance business processes.
The ideal candidate will act as a trusted advisor to business and technology stakeholders, helping organizations leverage data as a strategic asset through scalable data platforms, advanced analytics, and business intelligence solutions., * Partner with customers to position data as a strategic business asset, enabling them to differentiate through modern data platforms, BI, and advanced analytics solutions.
- Engage with business stakeholders, IT leadership, and enterprise architects to design and implement scalable, cloud-native data architectures, with a strong focus on AWS-based solutions.
- Define and drive enterprise data strategies and technology roadmaps, including architecture design, data modeling, and stepwise execution of modern data platforms supporting diverse analytics use cases.
- Lead Data & Analytics maturity assessments and strategy workshops, ensuring alignment with business goals around performance, scalability, flexibility, and cost optimization.
- Provide thought leadership on modern data and analytics technologies, enabling innovation in BI, advanced analytics, and predictive modeling.
- Design, prototype, and deliver end-to-end cloud data solutions, enabling new digital capabilities, especially in the Property & Casualty (P&C) Insurance domain.
Requirements
Do you have experience in System tuning?, * 15+ years of IT experience, including 4+ years in architecting and delivering cloud-native data solutions.
- Minimum 3+ years of hands-on experience in the Commercial P&C Insurance domain (mandatory).
- Strong expertise in implementing end-to-end Modern Data Platforms on AWS, using advanced processing frameworks such as Databricks
- Provide production support for Databricks-based data pipelines and workflows
- Monitor jobs, clusters, and data pipelines to ensure smooth operations
- Handle P1/P2 incidents, perform troubleshooting, and ensure timely resolution
- Perform root cause analysis (RCA) and implement preventive measures
- Support batch and streaming data pipelines built using Databricks (PySpark/SQL)
- Manage and optimize Databricks clusters for performance and cost
Technical Skills
Data Platforms & Cloud
- Deep understanding of cloud-native data architectures, data engineering pipelines, and data management frameworks.
- Hands-on experience with AWS services (e.g., S3).
- Expertise in data warehouse design, dimensional modelling, and columnar database architectures.
Database & Programming (Mandatory)
- Strong hands-on expertise in Oracle PL/SQL (must-have) including performance tuning, complex query optimization, and stored procedure development.
- Experience working with relational and distributed databases across enterprise environments.
ETL / ELT & Data Integration
- Strong knowledge of ETL/ELT concepts and tools, including:
- Oracle Data Integrator (ODI) - preferred
- Experience with modern ETL frameworks and pipelines
- Exposure to streaming and real-time data processing, including technologies like Kafka (Confluent).
BI & Reporting
- Hands-on experience with BI and reporting tools, with preference for:
- WebFOCUS (added advantage)
- Other BI tools such as Tableau / Power BI
- Ability to translate business requirements into actionable dashboards and analytics solutions.