Back to Jobs

Data Architect

Not Disclosed

Job Description & Details

Data architecture is the backbone of modern enterprises, ensuring data is organized, accessible, and secure. With the rapid shift toward data‑driven decision‑making, skilled architects who master both modeling tools and enterprise databases are in high demand. This Data Architect role in St Louis offers a hands‑on opportunity to shape critical data solutions on‑site.

Job Summary

We are seeking an experienced Data Architect to design, implement, and govern enterprise‑wide data models using Erwin Data Modeler and Oracle databases. The role involves collaborating with cross‑functional teams, establishing best practices, and ensuring data integrity and performance across all business domains.

Top 3 Critical Skills Table

Skill Why it's critical Mastery Level
Erwin Data Modeler Enables precise logical/physical data modeling and documentation Senior
Oracle Database Core platform for data storage, performance tuning, and security Senior
Data Architecture Principles Guides the creation of scalable, governed, and interoperable data ecosystems Mid

Interview Preparation

  1. Explain how you would use Erwin Data Modeler to create a logical data model for a new business domain.
    What the interviewer is looking for: Understanding of Erwin workflow, entity‑relationship design, and documentation standards.
  2. Describe the steps you take to optimize Oracle database performance for large‑scale reporting.
    What the interviewer is looking for: Knowledge of indexing, partitioning, query optimization, and monitoring tools.
  3. How do you ensure data governance and compliance in your data architecture designs?
    What the interviewer is looking for: Experience with data lineage, metadata management, and regulatory frameworks.
  4. What is the difference between a physical and logical data model, and when would you choose each?
    What the interviewer is looking for: Conceptual clarity and ability to translate business requirements into technical designs.
  5. Can you walk us through a challenging data integration project you led and the architectural decisions you made?
    What the interviewer is looking for: Problem‑solving skills, stakeholder collaboration, and impact on data quality.

Resume Optimization

  • Data Architect
  • Erwin Data Modeler
  • Oracle Database
  • Data Modeling
  • Logical Data Model
  • Physical Data Model
  • Data Governance
  • Data Integration
  • Performance Tuning
  • On‑site Implementation

Application Strategy

When reaching out to the recruiter, send a concise email that starts with a friendly greeting, attaches your resume, and clearly highlights your top relevant skills. Make sure to mention related skills you possess, such as Erwin Data Modeler, Oracle database expertise, and proven data architecture experience. Reference specific projects where you applied these skills and align them with the responsibilities outlined in the job description.

Career Roadmap

Current Role Typical Experience Core Focus Next Position
Data Architect (Entry/Mid) 3‑5 years in data modeling & Oracle Design & governance of data assets Senior Data Architect
Senior Data Architect 5‑8 years, lead complex initiatives Strategy, cross‑team leadership Data Architecture Manager
Data Architecture Manager 8‑12 years, managing teams & budgets Enterprise data strategy, stakeholder alignment Director of Data & Analytics