Solution Architect

Overview:

TekWissen is a global workforce management provider headquartered in Ann Arbor, Michigan that offers strategic talent solutions to our clients world-wide. Our client is an American multinational information technology services and consulting company and is a leading provider of information technology, consulting, and business process outsourcing services, dedicated helping the world's leading companies build stronger businesses.

Job Title: Solution Architect
Location: Saint Louis, MO
Duration: 6 Months
Job Type: Temporary Assignment
Work Type: Onsite

Job Description:

a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; }

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.

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.

Telecom/Wireless Domain Experience (Mandatory)

• Candidates should possess hands-on experience in one or more of the following areas:
  • Subscriber and account lifecycle management
  • Multi-line and hierarchical account structures
  • Product catalogs, rate plans, and offers
  • Features, entitlements, compatibility, and eligibility rules
  • Order management, activation, and provisioning workflows
  • Device and equipment management
  • Device financing and installment plans
  • Mobile subscriber identifiers:
    • MSISDN
    • IMSI
    • ICCID/SIM
    • IMEI
  • Number portability (Port-In/Port-Out)
  • Telecom BSS/OSS ecosystems

Preferred Qualifications

• TM Forum SID Data Model experience
• Telecom platforms such as:
  • Amdocs
  • Netcracker
  • Ericsson
  • CSG
• Oracle Exadata
• Oracle GoldenGate
• Schema version control and automation
• Temporal and history-based data modeling
• Supertype/Subtype modeling patterns
• Capacity planning and scalability modeling

Must-Have Skills

• OLTP Data Modeling
• Data Architecture
• Erwin Data Modeler
• Oracle Database
• Advanced PL/SQL
• Database Performance Tuning
• Python Automation
• Telecom/Wireless Domain Experience
• Data Governance & Standards

Nice-to-Have Skills

• TM Forum SID
• Oracle Exadata
• Oracle GoldenGate
• Amdocs / Netcracker / Ericsson / CSG
• Schema Automation & Version Control

Years of Experience:

• 14 Years of Experience

TekWissen Group is an equal opportunity employer supporting workforce diversity.