Quick overview
Job description
*Only Local to Texas candidates are applicable*
- Define and own the enterprise data architecture strategy, including target-state data models, subject area models, and reference architectures across the Oracle on-premise estate.
- Establish enterprise-wide data modeling standards, naming conventions, and governance policies within Erwin, and ensure consistent adoption across data modeling and engineering teams.
- Own the enterprise Erwin model repository/mart: subject area organization, model versioning, complex merges, and cross-model consistency at scale.
- Partner with stakeholders (Application Teams, Enterprise Architecture, business unit leaders) to translate business strategy into a coherent, long-term data architecture roadmap.
- Evaluate and architect for scalability, performance, and maintainability of Oracle databases handling large data volumes (GB to multi-TB scale), including partitioning, indexing, and storage strategy at the architectural level.
- Assist in promoting the Data Architecture function to increase the adoption of Data Virtualization (Denodo) across the enterprise.
- Design and review conceptual, logical, and physical data models for the most complex, cross-functional, and high-volume domains in the enterprise.
- Provide architectural review and approval of data models produced by senior/staff data modelers, ensuring alignment with enterprise standards, referential integrity, and downstream performance implications.
- Lead reverse-engineering and rationalization efforts for large, legacy Oracle schemas, consolidating and simplifying where architecturally sound.
- Guide both OLTP/3NF and dimensional (star/snowflake) modeling approaches, selecting the right pattern for transactional, operational, and analytical workloads.
- Assist in enriching the enterprise data governance artifacts tied to the architecture: business glossary, data lineage, metadata repository, and data dictionary standards.
- Lead capacity planning and performance architecture for large Oracle databases anticipating growth in data volume and ensuring the model and physical design scale accordingly.
- Assess and mitigate architectural risk in schema changes at enterprise scale, including impact analysis across integrated systems.
- Ensure data architecture practices meet regulatory, security, and compliance requirements applicable to the industry.
- Establish policies, procedures and guidelines regarding all aspects of Data Governance
- Assist in establishment of policies, procedures and guidelines regarding all aspects of Master Data Management
- Ensure Architectural rules and design of the MDM process are documented and best practices are adhered to.
- Developing a strategic roadmap for MDM, and assisting in developing a roadmap and its implementation
- Mentor and provide technical direction to data modelers, ETL developers, and DBAs on modeling best practices, Erwin usage, and Oracle architecture patterns.
- Act as the primary architectural liaison between business stakeholders, application teams, DBAs, and infrastructure teams.
- Present architecture decisions, trade-offs, and roadmaps to senior leadership and non-technical stakeholders.
- Provide mentorship to Data Analysts to ensure data management and design best practices are adhered to.
- Collaborate with support teams to ensure consistent and proactive support methodologies are in place for all aspects of data movement and data transformation.
- 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.
- 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
- FM

Engineering Data Architecture & Analytics LeadRecently posted Auto Apply
Ford Motor Company · Dearborn · Hybrid · Posted 16 Nov 2026 🇺🇸
TableauPythonMachine Learning+2Technology$112.7k - $212.8k/yr - ID

Data Governance LeadRecently posted
IDR, Inc. · Salem, OR · Hybrid · Posted 14 Nov 2026 🇺🇸
Salary not listed - IT
Senior Investment Data ArchitectRecently posted
InvestM Technology LLC · United States · Hybrid · Posted 14 Nov 2026 🇺🇸
GitETLSnowflake+2TechnologySalary not listed - AS
Snowflake ArchitectRecently posted
Apex Systems · Tampa, FL · Remote · Posted 14 Nov 2026 🇺🇸
AWSETLSnowflake+3Technology$80 - $90/hr - AE

Senior Data ArchitectRecently posted
Aerospace Corporation · El Segundo, CA · Remote · Posted 11 Nov 2026 🇺🇸
MongoDBNeo4jSQL+13Technology$120.3k - $202.8k/yr - CT

Lead Data ArchitectRecently posted
Conch Technologies · Charlotte, NC · On-site · Posted 13 Nov 2026 🇺🇸
AWSGoogle CloudAzureTechnologySalary not listed - AT
Senior Business Intelligence ArchitectRecently posted
Aroha Technologies · Washington, DC · On-site · Posted 14 Nov 2026 🇺🇸
TechnologySalary not listed - TT
Data ArchitectRecently posted
Tbright Technologies · United States · Remote · Posted 13 Nov 2026 🇺🇸
SQLGitApache Spark+8TechnologySalary not listed - DT
Data Warehouse Architect - Lansing, MIRecently posted
Digital Technology Solutions · Lansing, MI · Hybrid · Posted 12 Nov 2026 🇺🇸
DockerSQLGit+16TechnologySalary not listed - CS

Lead Azure Data ArchitectRecently posted
Cynet Systems · Raritan, NJ · Hybrid · Posted 13 Nov 2026 🇺🇸
SOC 2DatabricksAzure+4Technology$60 - $65/hr - HT
Data ArchitectRecently posted
Horizontal Talent · Chicago, IL · Hybrid · Posted 14 Nov 2026 🇺🇸
DockerNeo4jSQL+15Technology$49 - $85/hr - OS

Power BI Data Architect with Security ClearanceRecently posted
OneZero Solutions, LLC · Herndon, VA · Hybrid · Posted 13 Nov 2026 🇺🇸
ETLAzurePower BITechnologySalary not listed