Alteryx Automation Data Analyst
Purview Asia Pacific · Singapore
Roles & ResponsibilitiesEngage 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 RequirementsStrong 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 profilingData mappingData transformationData reconciliationData quality analysisRequirements gatheringAdvanced 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.