Officer - Quality Control

Responsibilities

1. Advanced VDP Data Engineering & Batch Processing : Accountability: Engineer and validate complex VDP data structures by converting raw, unformatted Excel spreadsheets into optimized, high-speed print batches. This involves utilizing advanced Excel formulas (lookup functions, PIVOT Tables, arrays, power querry and Power BI) and Dynamic Arrays to perform sophisticated deduplication, record-splitting, and logical validation.
2. Automated Data Transformation & Visualization (Power Query/BI) : Accountability: Architect and maintain automated ETL (Extract, Transform, Load) pipelines using Power Query (M language) and VBA Macros to standardize the cleaning of recurring data feeds. Leverage Power BI to translate these production metrics into interactive dashboards for real-time quality oversight.
3. 4. Advanced Reporting & Quality Visualization : Design and maintain interactive Power BI dashboards and PivotCharts to track re...