Start searching
Back to Jobs
Recently postedTechnology

Data Architect Onsite

RapidIT, IncDallas, TX🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeHybrid
LocationDallas, TX, United States
Stakeholder ManagementMongoDBOraclePL/SQLSQLETLSnowflakeHadoop

Job description

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

Similar jobs

Apply