Oracle Cloud Data Architect Philadelphia, Pennsylvania, United StatesRole 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.
