Alteryx Automation Data Analyst

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.