Data Architect
- Data Architecture
- Oracle
- Python
- PL/SQL
- Data Modeling
- Temporal
Data Architect
Location: Charlotte, NC β Hybrid
Work Arrangement: Onsite 3+ days/week
Β
Job Summary
We are seeking an experiencedData Architect / Data Modeler with 10+ years of experience in data architecture and modeling, primarily focused onOLTP and transactional systems. The ideal candidate will have expert-level Oracle skills, strong normalization expertise, Python experience, and telecom/wireless domain knowledge.
Key Responsibilities
-
Design and maintainlogical and physical data models for large-scale transactional systems.
-
Define data domains, naming standards, and modeling best practices.
-
Performforward/reverse engineering, Complete Compare, and Mart-based version control.
-
Design highly normalized3NF OLTP models and determine when denormalization is appropriate.
-
Develop and optimizeOracle PL/SQL for high-volume transactional workloads.
-
UsePython for data automation and manipulation.
-
Conduct requirements sessions with business stakeholders and translate requirements into technical specifications.
-
Support schema scalability, performance, replication, and version-control strategies.
Telecom / Mobile Domain Experience
Hands-on experience modeling data related to:
-
Subscriber and account lifecycle, including account hierarchies and multi-line accounts.
-
Product catalogs, offers, rate plans, features, entitlements, and eligibility rules.
-
Order management, activation, and provisioning.
-
Device/equipment data and device financing or installment plans.
-
MSISDN, IMSI, ICCID/SIM, and IMEI lifecycle management.
-
Number portability, including port-in and port-out.
-
BSS/OSS system landscapes.
Required Skills
-
10+ years in Data Architecture/Data Modeling.
-
Strong majority of experience withOLTP/transactional systems.
-
Current hands-onData Modeling expertise.
-
Expert-levelOracle and PL/SQL, including performance tuning.
-
Strong3NF normalization and OLTP schema design.
-
Python for automation and data manipulation.
-
Strong stakeholder and requirements-gathering skills.
-
Telecom, wireless, or mobile domain experience.
Preferred Skills
-
TM Forum SID or equivalent telecom canonical data models.
-
Experience withAmdocs, Netcracker, Ericsson, CSG, or similar BSS platforms.
-
Oracle Exadata.
-
Oracle GoldenGate or comparable replication technologies.
-
Supertype/subtype and temporal/history modeling.
-
Schema change automation and version control.
-
Capacity planning and scalability modeling for high-volume transactional systems.
Data Architect Β· Apolis