- Islandwide (Singapore) Singapore
工作地点
职位描述
岗位职责
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.
重要安全守则
申请工作时,切勿提供您的银行或信用卡详细资料。不要转账或完成无关的在线调查问卷。如果您发现可疑内容,请举报此招聘广告。