Job Description
Overview:
TekWissen is a global workforce management provider headquartered in Ann Arbor, Michigan that offers strategic talent solutions tour 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: Data Architect
Location: St. Louis, Mo
Duration: 6 Months
Job Type: Temporary Assignment
Work Type: Onsite
Location: St. Louis, Mo
Duration: 6 Months
Job Type: Temporary Assignment
Work Type: Onsite
Job Description:
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.
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 intconceptual, 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 tidentify 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 twork directly with business stakeholders and translate requirements inttechnical 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.
Numbers & Facts
| Location | Saint Louis, MO |
| Industry | Computer/IT Services |
| Salary | $57.14 |
| Company Size | 100 to 499 employees |
| Year Founded | 2009 |
| Website | http://www.tekwissen.com/ |
About Company
WE THE TEKWISSEN PEOPLE
TekWissen offers you a broader portfolio of services, industry-leading solutions, and the meaningful innovations that give you greater flexibility and speed to respond to market dynamics, reduced costs and risk to improve enterprise performance, and increased productivity to enable growth.
To keep pace with global market demands, TekWissen keeps its finger on the pulse of change. Our organized approach to guiding a project from its inception to closure. Managing projects is becoming more and more important as we enter the digital era. To cope with the pace that this transition demands, a method is required to manage projects so they can yield quality work, while incorporating efficient use of time and resources.
Project involves identifying which quality standards are relevant to the project and determining how to satisfy them.
It is important to perform quality planning during the Planning Process and should be done alongside the other project planning processes because changes in the quality will likely require changes in the other planning processes, or the desired product quality may require a detailed risk analysis of an identified problem. It is important to remember that quality should be planned, designed, then built in, not added on after the fact.
Capabilities and accomplishments in one TekWissen business enhance the opportunity for success in the others. Put simply, TekWissen's unique combination of attributes promotes success.Skills
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesFree resume builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Free resume builder