Alteryx Data Analyst

EXL; Pune District; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

EXL is seeking an experienced Senior Data Analyst to work on complex datasets from multiple sources. You will perform data mapping, data preparation, and data quality validation using SQL, Python, PySpark, and Alteryx. Banking domain exposure in Credit & Lending or Retail Credit is highly preferred.

You will design Alteryx workflows, connect to diverse data sources, automate repetitive tasks, and ensure accurate data models while contributing to dashboards and business insights.

Qualifications

• Experience in data mapping across multiple sources to define mappings and joins.
• Experience in data preparation and data quality validation across large datasets.
• Exposure to Big Data frameworks such as Hadoop, Hive and Spark.
• Ability to perform complex data transformations using PySpark and Alteryx.

Responsibilities

• Strong hands-on experience in SQL, Spark SQL/HQL, Python and PySpark for data exploration, transformation, analysis and validation.
• Hands-on experience in Alteryx, including designing and building workflows from scratch for extraction, transformation, loading and automation.
• Experience in setting up Alteryx workflows, connecting to multiple data sources, identifying source systems and automating repetitive data tasks.
• Working knowledge of Big Data frameworks such as Hadoop, Hive and Spark.
• Ability to perform complex data transformations using PySpark and Alteryx across large datasets.
• Strong exposure to data mapping, including defining mappings required to join datasets across multiple sources.
• Experience in data cleansing, data preparation, schema analysis and data quality validation.
• Understanding of ER diagrams, data modelling concepts, logical-to-physical mapping and data processing flows.
• Experience supporting data asset design and build activities by identifying critical data elements and defining reusable data asset mappings.
• Ability to create and maintain documentation for data mappings, subsystem design, technical design, business requirements, Alteryx workflows, processes and methodologies.
• Experience in dashboarding, visualization or reporting to support business analysis and insight generation.
• Ability to identify automation and process improvement opportunities to improve efficiency and productivity.
• Exposure to Agile delivery frameworks and tools such as Jira and Confluence.
• Banking domain knowledge, preferably in Credit & Lending, Retail Credit or Traded Credit.

Skills

SQL

Python

PySpark

Alteryx

Big Data

Data mapping

Data cleansing

Data modelling

Data quality validation

Dashboarding

Jira

Confluence

Banking domain knowledge

Tools

Hadoop

Hive

Spark

Job description

Role Summary

We are looking for an experienced senior Data Analyst with strong hands-on expertise in SQL, Python, PySpark and Alteryx. The ideal candidate should have experience working with large and complex datasets, performing data mapping, data preparation, data quality validation and data analysis across multiple sources. Exposure to Banking, Credit & Lending, Retail Credit or Traded Credit domains will be highly preferred.

1. Strong hands-on experience in SQL, Spark SQL/HQL, Python and PySpark for data exploration, transformation, analysis and validation.


2. Hands-on experience in Alteryx, including designing and building workflows from scratch for extraction, transformation, loading and automation.


3. Experience in setting up Alteryx workflows, connecting to multiple data sources, identifying source systems and automating repetitive data tasks.


4. Working knowledge of Big Data frameworks such as Hadoop, Hive and Spark.


5. Ability to perform complex data transformations using PySpark and Alteryx across large datasets.


6. Strong exposure to data mapping, including defining mappings required to join datasets across multiple sources.


7. Experience in data cleansing, data preparation, schema analysis and data quality validation.


8. Understanding of ER diagrams, data modelling concepts, logical-to-physical mapping and data processing flows.


9. Experience supporting data asset design and build activities by identifying critical data elements and defining reusable data asset mappings.


10. Ability to create and maintain documentation for data mappings, subsystem design, technical design, business requirements, Alteryx workflows, processes and methodologies.


11. Experience in dashboarding, visualization or reporting to support business analysis and insight generation.


12. Ability to identify automation and process improvement opportunities to improve efficiency and productivity.


13. Exposure to Agile delivery frameworks and tools such as Jira and Confluence.


14. Banking domain knowledge, preferably in Credit & Lending, Retail Credit or Traded Credit.