Data Engineer – UniData, UniVerse

This is a fully remote position, open to applicants in United States.

📋 Description

• Design, develop, maintain, and enhance applications and data processes utilizing UniData / Universe.

• Collaborate with business and functional teams to convert direct-selling compensation-plan requirements into technical solutions.

• Create and sustain logic for processing commissions based on sales, orders, ranks, bonuses, incentives, volumes, overrides, residuals, adjustments, reversals, clawbacks, and period-end calculations.

• Manage distributor/member hierarchies, genealogy structures, sponsor relationships, and organizational trees.

• Develop and optimize UniQuery, UniBasic, dictionaries, stored procedures, and batch processes.

• Conduct data extraction, transformation, validation, reconciliation, and loading across operational and reporting systems.

• Diagnose commission-processing issues and analyze discrepancies between source transactions and calculated payouts.

• Assist with month-end and pay-period commission runs.

• Establish reconciliation and audit processes for commission calculations and financial outputs.

• Evaluate and enhance the performance of large UniData / Universe files and batch processes.

• Integrate UniData / Universe data with external applications, databases, APIs, reporting platforms, and downstream systems.

• Engage in production support, root-cause analysis, incident resolution, and performance tuning.

• Maintain technical documentation for data structures, compensation rules, interfaces, and processing workflows.

• Work alongside QA teams to develop test scenarios for intricate compensation-plan rules and edge cases.

⛳️ Requirements

• 8+ years of experience in UniData / Universe development and data engineering.

• Practical experience with UniBasic / UniQuery and UniData or Universe databases.

• Demonstrated expertise in the direct-selling, MLM, network-marketing, or distributor-based business sectors.

• Significant experience with commission-processing, compensation, incentive, or payout systems.

• Familiarity with distributor hierarchies, sales volumes, qualifications, ranks, bonuses, and compensation plans.

• Proficient SQL and relational database skills.

• Experience with data integration, ETL/ELT processes, batch processing, and data reconciliation.

• Strong analytical and problem-solving abilities.

• Experience in supporting production systems and resolving data/commission discrepancies.

• Capability to comprehend complex business rules and transform them into dependable technical solutions.

• Preferred: Experience with Rocket U2 / Rocket UniData / Universe environments.

• Preferred: Experience migrating or integrating UniData / Universe with contemporary cloud or relational data platforms.

• Preferred: Experience with APIs, web services, or middleware integrations.

• Preferred: Experience with Python, scripting, or other modern data-engineering technologies.

• Preferred: Experience with reporting and BI platforms.

• Preferred: Knowledge of financial reconciliation, audit controls, and payout processing.

• Preferred: Experience working in Agile/Scrum environments.

🏝️ Benefits

• Remote work.

• Full-time employment.