Data Architect (contract)

Location: Charlotte, NC (Onsite)

Schedule: 3+ days per week in office

Required Experience & Skills

• 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 Compare

• Mart-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

The ideal candidate already understands the structure and relationships within wireless operational data and can quickly contribute without extensive domain onboarding.

Experience modeling data within the following areas is highly preferred:

• 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

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 Qualifications

• 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

The pay range that the employer in good faith reasonably expects to pay for this position is $44.85/hour - $70.07/hour. Our offered benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis.

Tundra Technical Solutions is among North America’s leading providers of Staffing and Consulting Services. Our success and our clients’ success are built on a foundation of service excellence. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers: we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.