Databricks Architect with P&C

Job Description

Title: Databricks Architect

Duration: Long Term

Location: Michigan - Onsite

Overview

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.

Key Responsibilities

• 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.

Desired Skills & Experience

Core Experience

• 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.

Regards,

Manoj Goud

Derex Technologies INC

Contact : 973-834-5005 Ext 206

Additional Information

All your information will be kept confidential according to EEO guidelines.