Data Architect (contract)

Requirements

• 10+ years of experience in data architecture and data modeling, with the majority focused on OLTP (transactional) systems.
• Hands-on Data Modeler with current experience and the ability to discuss:
  • Logical vs. physical data models
  • Domain management
  • Naming standards
  • Forward and reverse engineering
  • Complete CompareMart-based version control
• Strong normalization expertise, including:
  • Designing large-scale 3NF data models
  • Defining key strategies
  • Understanding when and why to denormalize OLTP schemas
  • Maintaining data consistency after denormalization
• Oracle expertise, including:
  • Advanced PL/SQL development
  • Performance tuning for transactional workloads
• Python for automation and data manipulation.
• Telecommunications, wireless, or mobile industry experience (strong preference and a key requirement).
• Ability to facilitate requirements-gathering sessions with business stakeholders and translate business needs into technical specifications.
• Telecommunications / Mobile Domain Expertise: understanding of structure and relationships within wireless operational data; experience modeling data within:
  • Subscriber and account lifecycle management, including account hierarchies and multi-line accounts
  • Product catalog management: offers, rate plans, features, entitlements, eligibility and compatibility rules
  • Order management, activation, and provisioning processes
  • Device and equipment management, including financing and installment plans
  • Network and subscriber identifiers and their lifecycle management: MSISDN, IMSI, ICCID/SIM, IMEI, recycling and reassignment processes
  • Number portability (port-in / port-out)
  • BSS/OSS ecosystems and integrations

Qualifications

• Preferred:
  • Familiarity with TM Forum SID or other telecom canonical data models
  • Experience with commercial BSS platforms such as Amdocs, Netcracker, Ericsson, CSG, or similar telecommunications platforms
• Nice-to-Have:
  • Oracle Exadata
  • Oracle GoldenGate or comparable replication technologies and their impact on schema design
  • Supertype/subtype modeling patterns
  • Temporal and historical data modeling in high-volume transactional environments
  • Schema change automation and version control best practices
  • Capacity planning and scalability modeling for growing transactional systems

Benefits

Medical, dental, vision and retirement benefits.

Pay

$44.85/hour - $70.07/hour.

Schedule

Location: Charlotte, NC (Onsite). Schedule: 3+ days per week in office.