UniData/UniVerse Data Engineer
Summary
A data engineer builds and maintains commission-processing and distributor-hierarchy systems on UniData/UniVerse (Rocket U2) multivalue databases, handling ETL, batch runs, reconciliation, and integrations with external applications. Core stack: UniBasic, UniQuery, SQL, and APIs, in a direct-selling/MLM business context.
Responsibilities
- Design, develop, maintain, and optimize applications and data processes using UniData / Universe
- Develop and maintain commission-processing logic including sales commissions, bonuses, and rank-based compensation
- Manage distributor/member hierarchies, genealogy structures, and organizational trees
- Develop and optimize UniQuery, UniBasic, dictionaries, stored procedures, and batch processes
- Perform data extraction, transformation, validation, reconciliation, and loading
- Troubleshoot commission-processing issues and investigate discrepancies
- Support month-end/pay-period commission runs
- Integrate UniData / Universe data with external applications, databases, and APIs
- Maintain technical documentation for data structures and compensation rules
Requirements
- 8+ years of experience in UniData / Universe development and data engineering
- Hands-on experience with UniBasic / UniQuery and UniData or Universe databases
- Proven experience in the direct-selling, MLM, network-marketing, or distributor-based business domain
- Strong experience working with commission-processing, compensation, or incentive systems
- Strong SQL and relational database skills
- Experience with data integration, ETL/ELT, and batch processing
Preferred Qualifications
- Experience with Rocket U2 / Rocket UniData / Universe environments
- Experience migrating or integrating UniData / Universe with modern cloud or relational data platforms
- Experience with APIs, web services, or middleware integrations
- Experience with Python, scripting, or other modern data-engineering technologies
- Experience with reporting and BI platforms
- Knowledge of financial reconciliation and audit controls
- Experience working in Agile/Scrum environments