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.