WNS

Alteryx Designer -( Excel / SQL/Alteryx Macros, BI Visualization )

WNS  •  Republic of India (Onsite)  •  1 hour ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description

Company Description

WNS, part of Capgemini, is an Agentic AI-powered leader in intelligent operations and transformation, serving more than 700 clients across 10 industries, including Banking and Financial Services, Healthcare, Insurance, Shipping and Logistics, and Travel and Hospitality. We bring together deep domain excellence – WNS’ core differentiator – with AI-powered platforms and analytics to help businesses innovate, scale, adapt and build resilience in a world defined by disruption.Our purpose is clear: to enable lasting business value by designing intelligent, human-led solutions that deliver sustainable outcomes and a differentiated impact. With three global headquarters across four continents, operations in 13 countries, 65 delivery centers and more than 66,000 employees, WNS combines scale, expertise and execution to create meaningful, measurable impact.

Job Description

  1. Job OverviewThis job requires hands-on experience in Alteryx Designer, Alteryx Server, Alteryx Macros, Tableau, SQL, and Advanced Excel to manage data automation, workflow development, reporting and Business process automation.2. Required Technical SkillsA. Alteryx Designer – AdvancedStrong hands-on experience with Alteryx Designer.Developing and maintaining complex workflows for data extraction, transformation and automation.Working with multiple data sources, including CSV, Excel, databases, and SharePoint.Experience with Dynamic Input, Directory, Formula, Filter, Join, Union and other transformation tools.Workflow optimization and troubleshooting.Experience developing and maintaining Standard, Batch and Iterative Macros.Creating reusable workflows to minimize repetitive development.Implementing macros for automated data consolidation and processing.B. Alteryx ServerExperience working with Alteryx Server.Publishing and Scheduling Workflows.Monitoring Scheduled workflow executions.Troubleshooting workflow failures and execution issues.Managing workflow dependencies, data connections and output locations.Understanding Server environments and workflow deployment.C. TableauExperience developing and maintaining Tableau dashboards and reports.Connecting Tableau with different data sources.Creating calculated fields, filters, parameters and interactive dashboards.Understanding Live connections and data extracts.Working with Tableau Server for publishing and maintaining dashboards.Automating data refresh and reporting processes.D. SQLStrong knowledge of SQL queries for data extraction and analysis.Experience with Join, functions, CTE, Aggregate functions and date/time functions.Data validation, reconciliation, and troubleshooting.Understanding database structures, tables and relationships.E. Advanced Microsoft ExcelStrong knowledge of advanced Excel functions.Experience with VLOOKUP, XLOOKUP, INDEX-MATCH, Conditional statements and Text functions.Pivot Tables and Pivot Charts.Data cleaning and formatting.Power query for data transformation and consolidation.Handling large datasets and performing data reconciliation.3. Key Roles and ResponsibilitiesDevelop, maintain, and optimize automated workflows using Alteryx Designer.Build and maintain reusable Alteryx Macros for recurring business processes.Manage workflow deployments, scheduling, and monitoring through Alteryx Server.Automate manual data extraction, consolidation, transformation, and reporting activities.Develop and maintain Tableau dashboards based on business requirements.Extract and validate data using SQL queries.Perform data reconciliation between source files, databases, and reporting outputs.Troubleshoot workflow failures, data discrepancies, and automation issues.Handle multiple file formats and dynamic input structures.Coordinate with business stakeholders and technical teams to understand requirements and deliver automation solutions.Maintain existing workflows and ensure business continuity.Document automation processes, dependencies and technical logic.

Qualifications

Graduate or above

WNS

About WNS

WNS, part of Capgemini, is an Agentic AI-powered intelligent operations and transformation company. WNS combines deep industry knowledge with technology, analytics, and process expertise to co-create innovative, digitally-led transformational solutions with over 700+ clients across various industries. WNS delivers an entire spectrum of transformative solutions that entail industry-specific offerings, customer experience services, finance and accounting, human resources, procurement, and data-led analytics solutions to solve operational challenges and drive strategic growth journeys for businesses. As of June 30, 2025, WNS has 66,000+ professionals across 64 delivery centers worldwide, including facilities in the United States, the United Kingdom, Canada, Turkey, Poland, Romania, China, Costa Rica, Malaysia, the Philippines, South Africa, Sri Lanka, and India.

Industry
Consulting & Advisory
Company Size
10,000+ employees
Headquarters
New York
Year Founded
1996
Website
wns.com
Social Media