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.