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