Alteryx Designer -( Excel / SQL/Alteryx Macros, BI Visualization )
Gurugram, HR, India11h ago
Key details
- Location
- Gurugram, HR, India
- Work style
- Onsite
- Job type
- Full-time
- Function
- Design & Creative
- Focus area
- other
- Posted
- 11h ago
Skills
About the role
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
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.
How well do you match this job?
Free account needed to apply or save. It takes a minute, and we'll bring you right back to this job.