OCI Data Architecture

Role: OCI Data Architecture

Hybrid

Philadelphia, PA

Role Overview:

·        Seeking a highly skilled and experienced Oracle Cloud Data Architect / Engineer with deep expertise in SQL‑based data architecture and enterprise reporting platforms.

·        The role will be part of a team supporting a major insurance client, responsible for designing, developing, and maintaining scalable Oracle Cloud (OCI) data architecture and database solutions for analytics and reporting environments.

·        Play a critical role in architecting cloud‑based data platforms, optimizing database performance, and ensuring reliability, security, and scalability of reporting systems.

·        Collaborate within an agile, cross‑functional team comprising diverse technical backgrounds to solve complex data and cloud architecture challenges across Oracle Cloud and integrated platforms.

·        Actively participate in architecture discussions, design reviews, and brainstorming sessions, driving continuous improvement initiatives from concept through implementation.

·        Required to navigate ambiguous requirements and translate business needs into robust technical data models and cloud solutions.

·        Ideal candidate will have 8+ years of overall IT experience, including 5+ years in a Data Architect or Senior Data Engineering role with strong SQL expertise; experience in the life insurance domain is preferred but not mandatory.

Key Responsibilities & Skillsets:

·        Common Skillsets:

o   Superior analytical and problem-solving skills.

o   Should be able to work on a problem independently and prepare client ready deliverable with minimal or no supervision.

o   Excellent communication skill for client interaction

·        Application development Skillsets:

o   Proven experience designing cloud‑native and hybrid data architectures.

o   Understanding of security, access controls, encryption, and compliance in cloud environments.

o   Ability to handle ambiguous requirements and drive architectural clarity.

o   Strong computer science fundamentals such as algorithms, data structures, multithreading, object-oriented development, distributed applications, client-server architecture

o   Strong expertise in SQL (advanced joins, window functions, performance tuning).

o   Hands on experience with Oracle Databases (Autonomous DB, Oracle 19c/21c preferred).

o   Solid knowledge of Oracle Cloud Infrastructure (OCI) components including:

§  OCI Object Storage

§  Networking and IAM

§  Compute and Database services

o   Experience designing enterprise data models (dimensional, relational, reporting focused).

o   Familiarity with ETL / data integration tools and batch data pipelines.

o   Strong understanding of data migration, reconciliation, and validation strategies.

o   Experience supporting reporting and analytics platforms (BI tools, data marts).

o   Experience in web services, streaming and messaging technologies is a plus.

o   Proven ability to optimize database performance through query tuning, indexing and stored procedure optimization.

o   Strong leadership and mentoring skills, with the ability to guide and inspire a team.

o   Experience with collaborating with cross-functional teams and managing client and stakeholder expectations.

o   Demonstrated experience with data governance, data security and privacy regulations.

Candidate Profile:

·        Bachelor’s/master’s degree in computer science/engineering, operations research, or related analytics areas welcome to apply.

·        10+ years’ of IT experience with expertise in Oracle and Oracle Cloud based architectures, preferably in Life Insurance but not mandatory

·        Capability of designing complex data architecture solutions

·        Team Management

·        Superior analytical and problem-solving skills.

·        Outstanding written and verbal communication skills

·        Able to work in a fast paced and continuously evolving environment with the ability to take-up challenging tasks.

·        Can understand cross cultural differences and can collaborate with clients across the globe.