Databricks Architect with P&C

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.

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.

Derex Technologies Inc specializes in providing IT consulting, staffing solutions and software services. Globally headquartered in Harrison New Jersey since 1996 Derex delivers the highest quality technology professionals and an array of customized IT talent solutions designed to improve productivity and drive results to global clients throughout North America.

With over two decades of unparalleled experience, Derex provides supports to its clientele, across such industries as Systems Integration, Banking and Finance, Telecommunications, Pharmaceutical and Life Sciences, Energy, Healthcare, Technology, Transportation, and local and federal Government agencies.