The posting
Roles & Responsibilities
- Engage with business and regulatory reporting stakeholders across APAC regions to understand reporting requirements, business rules, calculations, validations and submission processes.
- Document existing As-Is reporting processes, including Excel spreadsheets, VBA/macros, manual adjustments, data transformations, reconciliations and dependencies.
- Translate regulatory and business requirements into detailed functional and data requirements for automation.
- Identify common and country-specific reporting requirements across APAC markets.
- Perform detailed data profiling across source systems, databases, files and reporting datasets.
- Analyze data structures, formats, completeness, quality, consistency, duplicates and anomalies.
- Identify data gaps and work with business and technology teams to resolve data quality issues.
- Validate source data against existing regulatory reports and business expectations.
Skills and Requirements
- Strong experience as a Data Analyst, Business Data Analyst, or Alteryx Developer/Analyst.
- Hands-on experience with Alteryx Designer and development of complex data preparation and automation workflows.
- Strong experience in: Data profiling Data mapping Data transformation Data reconciliation Data quality analysis Requirements gathering
- Advanced knowledge of Microsoft Excel, including complex formulas, pivot tables, lookups and macros/VBA.
- Ability to understand and reverse-engineer complex Excel-based reporting processes.
- Strong SQL skills for data extraction, profiling, analysis and validation.
- Experience working with structured and semi-structured datasets from databases, Excel, CSV, flat files and other enterprise data sources.
- Ability to translate business and regulatory requirements into technical transformation logic.



