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:
- Superior analytical and problem-solving skills.
- Should be able to work on a problem independently and prepare client ready deliverable with minimal or no supervision.
- Excellent communication skill for client interaction
- Application development Skillsets:
- Proven experience designing cloud‑native and hybrid data architectures.
- Understanding of security, access controls, encryption, and compliance in cloud environments.
- Ability to handle ambiguous requirements and drive architectural clarity.
- Strong computer science fundamentals such as algorithms, data structures, multithreading, object-oriented development, distributed applications, client-server architecture
- Strong expertise in SQL (advanced joins, window functions, performance tuning).
- Hands on experience with Oracle Databases (Autonomous DB, Oracle 19c/21c preferred).
- Solid knowledge of Oracle Cloud Infrastructure (OCI) components including:
- OCI Object Storage
- Networking and IAM
- Compute and Database services
- Experience designing enterprise data models (dimensional, relational, reporting focused).
- Familiarity with ETL / data integration tools and batch data pipelines.
- Strong understanding of data migration, reconciliation, and validation strategies.
- Experience supporting reporting and analytics platforms (BI tools, data marts).
- Experience in web services, streaming and messaging technologies is a plus.
- Proven ability to optimize database performance through query tuning, indexing and stored procedure optimization.
- Strong leadership and mentoring skills, with the ability to guide and inspire a team.
- Experience with collaborating with cross-functional teams and managing client and stakeholder expectations.
- 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.
Originally posted on