1970740-Lead Assistant Manager

EXL; Gurugram District; On-site; INR 900,000 - 1,600,000; Full time

Job summary

EXL Services in Gurgaon is seeking a Consultant/Senior Consultant with strong SQL, Hive, Python and Tableau skills to transform data into actionable insights. You will design and maintain Tableau dashboards, write complex queries, and collaborate with stakeholders and data teams to deliver BI solutions.

Experience with Payments and Fraud domain is a plus; familiarity with machine learning concepts such as random forest or XGBoost is beneficial.

Qualifications

• Experience with SQL, Hive, Python and Tableau for BI tasks.
• Ability to design and develop Tableau dashboards.
• Experience transforming raw data into actionable insights.
• Payments and fraud domain exposure preferred.
• Familiarity with ML concepts is a plus.

Responsibilities

• Collaborate with stakeholders to understand data needs and translate them into Tableau dashboards and reports.
• Perform adhoc analysis based on business trends and recommend actions.
• Develop and maintain Tableau visualizations, dashboards, and reports for business users.
• Design and optimize data models and structures to support efficient retrieval.
• Write complex SQL queries to extract, transform, and load data into Tableau.
• Use Hive and Python for data manipulation and automation tasks.
• Test and debug Tableau solutions to ensure accuracy and performance.
• Stay updated with Tableau features and best practices to enhance reports.
• Collaborate with data engineers and data scientists to align Tableau solutions with the data ecosystem.

Skills

SQL

Hive

Python

Tableau

Machine Learning

Job description

Job Title: Consultant/Senior Consultant

Location: Gurgaon

Job Description

We are hiring consultant/senior consultant with expertise in SQL, Hive, Python, Tableau and good exposure to Machine Learning would be an advantage. Must be able to work independently with multiple stakeholders. For BI task, you will design, develop, and maintain excel and Tableau solutions, transforming raw data into actionable insights and work independently. Collaborate with stakeholders, write SQL queries, and utilize Hive and Python for data manipulation. Ensure data accuracy, provide technical support, and stay updated with the latest Tableau features. Strong problem-solving skills and attention to detail required. Prior experience with Payments and fraud domain is preferred.

Responsibilities

• Collaborate with stakeholders to understand their data requirements and translate them into Tableau dashboards and reports.
• Conduct adhoc analysis basis the business trends and recommend the next action items
• Develop and maintain Tableau visualizations, interactive dashboards, and reports to provide actionable insights to business users.
• Design and optimize data models and data structures to support efficient data retrieval and analysis.
• Write complex SQL queries to extract, transform, and load data from various data sources into Tableau.
• Utilize Hive and Python for data manipulation, transformation, and automation tasks.
• Conduct thorough testing and debugging of Tableau solutions to ensure data accuracy and dashboard performance.
• Stay updated with the latest Tableau features, techniques, and best practices, and apply them to enhance existing reports and dashboards.
• Collaborate with data engineers and data scientists to ensure seamless integration and alignment of Tableau solutions with the overall data ecosystem.

Requirements

• Tableau Developer
• Strong Proficiency in SQL, Hive
• Prior experience in SQL for data extraction, manipulation, and analysis.
• Proficiency in Python
• Understanding of Big Data Ecosystem
• Strong problem-solving and attention to detail
• Payments and Fraud prior experience good to have
• Added advantage to those with understanding of Machine Learning algorithms in classification such as random forest, XGBoost etc ;