Data Architect
Location - Dallas - 4 days in office
Required skills: Data Architecture, Data Strategy, Data Governance, performance, Risk, Collaboration, and Data Modelling, ETL Tool - Others, Oracle PL/SQL
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
