Solution Architect

ReqRoute,Inc

St. Louis (MO)

On-site

USD 120,000 - 180,000

Full time

14 days+

Application generator

A complete application in a minute — tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

ReqRoute,Inc. seeks a seasoned Solution Architect in St. Louis (onsite) to lead OLTP data modeling and data architecture for telecom/mobile applications. You will design highly normalized transactional databases using Erwin, Oracle, PL/SQL, and Python.

Responsibilities include translating requirements into conceptual/physical models, governing standards, and ensuring performance in high-volume environments. Telecom domain experience is essential.

Qualifications

10+ years of Data Architecture and Data Modeling experience.
OLTP/transactional systems experience.
Expert with Erwin Data Modeler, Oracle Database, PL/SQL, Python.
3NF data modeling, normalization, governance.
Ability to work with business stakeholders and translate requirements into technical solutions.

Responsibilities

Data Architecture & Modeling: Translate requirements into conceptual, logical, and physical models; maintain highly normalized enterprise data models; create ERDs and data dictionaries.
Oracle Database Design: Design physical schemas, tables, keys, indexing, constraints, sequences, and partitioning; ensure scalability and performance.
Erwin Data Modeling: Develop and maintain models in Erwin; manage versioning; perform forward/reverse engineering; use Complete Compare; enforce governance.
PL/SQL Development & Performance Tuning: Develop and optimize complex PL/SQL; analyze execution plans; optimize queries and indexing; troubleshoot locking and concurrency.
Data Governance & Quality: Define standards, governance procedures, data dictionaries, quality controls, and compliance with security/privacy.
Python Automation: Build automation tools for model validation, metadata extraction, schema checks, data profiling, deployment support.

Skills

OLTP Data Modeling

Data Architecture

Erwin Data Modeler

Oracle Database

Advanced PL/SQL

Python Automation

Telecom/Wireless Domain Experience

Data Governance & Standards

3NF Modeling

Tools

Oracle Exadata

Oracle GoldenGate

Job description

Job Title: Solution Architect

Location: St. Louis, MO - Onsite

Position Overview

We are seeking an experienced Solution Architect with deep expertise in OLTP Data Modeling and Data Architecture within the Telecom/Wireless industry.
This role requires a hands-on architect capable of designing and governing highly normalized transactional databases that support customer-facing mobile applications, subscriber management systems, product catalogs, order management, and activation workflows.
The ideal candidate will have strong experience with Erwin Data Modeler, Oracle Database, PL/SQL, and Python, along with a proven track record of architecting scalable, high-volume transactional systems in a telecom environment.
Note: This is an OLTP-focused role. Candidates with primary experience in Data Warehousing, BI, Analytics Engineering, Reporting, or ETL/ELT development will not be considered.

Key Responsibilities

Data Architecture & Modeling

Translate business requirements into conceptual, logical, and physical data models.
Design and maintain highly normalized (3NF) enterprise data models.
Create conceptual Entity Relationship Diagrams (ERDs) and logical data models.
Establish and govern business data definitions, standards, and naming conventions.

Oracle Database Design

Design Oracle physical schemas, including:
- Tables and columns
- Primary and foreign keys
- Indexing strategies
- Constraints and sequences
- Partitioning structures
Ensure database scalability, integrity, and performance.

Erwin Data Modeling

Develop and maintain enterprise data models using Erwin Data Modeler.
Manage model versioning through Erwin Mart.
Perform forward and reverse engineering.
Utilize Complete Compare to identify and resolve schema differences.
Maintain naming standards, domains, and model governance.

PL/SQL Development & Performance Tuning

Develop and optimize complex PL/SQL code.
Analyze execution plans and identify performance bottlenecks.
Optimize indexing strategies and database queries.
Troubleshoot locking, contention, and concurrency issues in high-volume transactional environments.

Data Governance & Quality

Define data modeling standards, governance procedures, and review processes.
Develop data dictionaries and impact analysis documentation.
Establish controls for data quality, consistency, completeness, and integrity.
Ensure compliance with security and privacy requirements.

Python Automation

Develop automation tools for:
- Model validation
- Metadata extraction
- Schema compliance checks
- Data profiling
- Deployment support

Required Qualifications

10+ years of Data Architecture and Data Modeling experience.
Majority of experience focused on OLTP/transactional systems.
Strong hands-on expertise with:
- Erwin Data Modeler
- Oracle Database
- Advanced PL/SQL Development
- Python
Expert understanding of:
- 3NF data modeling and normalization
- Logical and physical data modeling
- Database performance tuning
- Data governance practices
Ability to work directly with business stakeholders and translate requirements into technical solutions.