Data Architect

JD 10+ years of experience in data architecture, data modeling, or database engineering, including prior experience as a senior/lead data modeler, solution architect or data architect. Deep, hands-on expertise with Erwin Data Modeler at an enterprise scale (model mart, subject areas, complex compare/merge, versioning across large teams). Strong expertise in Oracle Database (on-premise), including advanced SQL/PL-SQL, schema design, partitioning, indexing strategy, and performance tuning at the architectural level. Demonstrated experience architecting and modeling for large data volumes (GB to multi-TB scale) with a track record of designs that scaled successfully in production. Strong command of data modeling theory (normalization/denormalization, cardinality, keys, referential integrity) and dimensional modeling (star/snowflake) for analytics. Experience defining enterprise data standards, governance frameworks, and metadata/lineage practices. Extensive working knowledge of all aspects of Data Movement and Processing, including Middleware, ETL, API, OLAP and best practices for data tracking Proven ability to operate at the intersection of technical architecture and executive stakeholder management i.e., translating business strategy into data architecture and communicating trade-offs to leadership. Strong written and verbal communication skills, with experience producing architecture documentation, ER diagrams, and data dictionaries for both technical and business audiences. Preferred Qualifications Experience in a regulated industry (utilities, financial services, insurance, healthcare) with associated data governance and compliance obligations. Experience leading or mentoring a team of data modelers/architects. Previous experience working with PostGres and MongoDB and big plus. Familiarity with complementary data modeling tools such as ER/Studio, Power Designer, Collibra, Alation Exposure to hybrid on-prem/cloud data strategies, even where the primary platform remains Oracle on-premise. Experience with Target Operating Model (TOM) design for data functions. Relevant certifications (OCI, DAMA, CDMP, etc.) is a plus. Experience with Hadoop/MongoDB is a plus Working experience with Denodo is a plus