MIS Analyst

Description

Job Summary: Commission Scheme Settlement Analyst responsible for validating, building, and automating calculation models, ensuring data integrity, and proposing process improvements. Key Highlights: 1. Analyze and validate commission schemes with accuracy and traceability. 2. Automate calculation processes using analytical tools. 3. Propose improvements in data quality and process efficiency. **Job Description** ---------------------- Analyze, calculate, and validate commission schemes based on reliable data, ensuring accuracy, traceability, and consistency. Build and execute calculation models for commission scheme settlements based on sales, premium, and validity databases. Analyze, cleanse, and validate data sources used in settlement processes. Implement business rules, exceptions, and adjustments in data models, ensuring correct application. Validate results through cross-checks, reconciliations, and total controls to ensure information integrity. Automate calculation and validation processes using analytical tools (SQL, Excel, Power BI, Python, or others). Generate datasets, reports, and dashboards supporting the review and approval of commission settlements. Analyze discrepancies, claims, or deviations in commissions, identifying root causes from the data. Document assumptions, rules, transformations, and versions of settlement models for auditing and traceability. Propose improvements in data quality, process efficiency, and standardization of commission schemes. **Candidate Requirements** -------------------------- * Education: Statistics; Mathematics; Computing and Informatics; Systems Engineering; or related field * Experience: 3\+ years in big data * Knowledge: Databases (NoSQL), Data Modeling, ETL, Database Management * Knowledge of commission scheme calculations **Compensation** ---------------- 3612000**Selection Process** ------------------------ The selection process is conducted via Aira — a recruitment platform designed to enhance your application experience. To apply, you only need: 1\. Apply to the position 2\. Check your email 3\. Log in to Aira and answer the requested questions and/or tests Then, if we determine your profile matches our requirements, we will contact you by email (via Aira) to proceed to the in-person stage. **About Us** ------------------ We are over 88,000 people who work every day toward our firm Purpose — Simplify and Enjoy Life More. We operate in 9 countries and consist of five major brands positioned across diverse industries: Falabella Retail, Sodimac, Banco Falabella, Tottus, and Mallplaza. Each of these brands shapes who we are, and together — as One Team — we strive daily to reinvent ourselves and exceed our customers’ expectations. A team full of dreams that makes things happen. We dare to launch initiatives and innovate, take risks, and create opportunities enabling us to remain at the forefront — driving us to continuously reinvent ourselves to deliver the best shopping experience at every touchpoint with us.