4423513-Lead Assistant Manager

EXL Talent Acquisition Team; Dadri; On-site; INR 900,000 - 1,300,000; Full time

Job summary

EXL Talent Acquisition Team is seeking an experienced Business Intelligence Analyst with 3–5 years in BI/analytics to design end-to-end BI solutions. You will develop ETL processes using AWS Glue and Lambda, work with AWS Redshift, and create data visualizations with AWS QuickSight or Power BI.

You will collaborate with IT, finance, and business stakeholders to deliver actionable insights. The role requires strong SQL skills, data analysis capabilities, and the ability to own projects

Qualifications

• 3–5 years of experience in business intelligence, analytics, or related roles.
• Minimum 2 year hands-on experience on AWS Glue, Lambda, RDS, RedShift, S3
• BS or MS degree in Engineering, Data & Analytics, Information Systems, or a related field (master's a plus)
• Excellent problem-solving and analytical skills
• Strong thought leadership and ability to translate data into actionable features

Responsibilities

• Visualization and Reporting: Design and develop dashboards and reports for stakeholders.
• Data Analysis: Analyze data, identify insights, and recommend actions.
• Solution Design: Translate requirements into scalable BI solutions.
• Data Asset Creation: Build data assets from warehouses and external datasets.
• ETL Development: Design ETL processes with automation and accuracy.
• Collaboration and Stakeholder Management: Work with cross-functional teams to ensure delivery.
• Documentation and Training: Document BI solutions and train users.

Skills

Analytical thinking

Problem solving

Thought leadership

Project management

Interpersonal skills

Education

BS or MS in Engineering, Data & Analytics, Information Systems, or related field

Tools

AWS QuickSight

Power BI

AWS Glue

AWS Lambda

PostgreSQL

AWS Redshift

SQL

Job description

Business Intelligence Analyst (Minimum Three years of total experience): We are seeking an experienced and highly skilled Business Intelligence Analyst who is passionate about transforming innovative ideas into effective, data-driven solutions. In this role, you will be responsible for designing and delivering business intelligence solutions, which include ETL (Extract, Transform, Load) processes, data visualization, and data analysis. You will collaborate with cross-functional teams, including IT, Finance, and business stakeholders, to understand their requirements, design scalable and efficient solutions, and ensure the availability of insightful visualizations and reports. Your expertise will play a crucial role in driving data-driven decision-making and empowering the organization with actionable insights. Success in this role will require creativity and the ability to work independently to analyze sales data and create business intelligence dashboards. This position entails complete end-to-end project ownership, which includes conducting discovery meetings with stakeholders, leveraging existing SQL queries, building new SQL queries, creating ETL processes using AWS Glue and Lambda, working with AWS Redshift, developing automation workflows, and utilizing data visualization tools such as AWS QuickSight and Power BI.

Key Responsibilities:

• Visualization and Reporting : Design and develop interactive dashboards, reports, and visualizations that provide actionable insights to business stakeholders using industry-leading tools and technologies.
• Data Analysis : Analyze data, identify insights, and collaborate with sales leaders to recommend business actions.
• Solution Design : Work closely with business stakeholders to understand their requirements and translate them into comprehensive and scalable business intelligence solutions.
• Data Asset Creation : Leverage internal data warehouses and external datasets to build new data assets for analysis and visualization.
• ETL Development : Design and implement ETL processes to extract, transform, and load data, focusing on automation, accuracy, and reusability.
• Collaboration and Stakeholder Management : Collaborate with cross-functional teams, including data analysts and sales leaders, to understand requirements, gather feedback, and ensure the successful delivery of solutions.
• Documentation and Training : Create comprehensive documentation of BI solutions (including ETL processes and visualizations) and provide training and support to users and stakeholders on the effective use of business intelligence dashboards and analytics.

Qualifications:

• Excellent problem-solving and analytical skills, with the ability to apply knowledge and creativity to resolve complex issues.
• Strong thought leadership and a quick understanding of how data and insights can be transformed into valuable features.
• Experience with:
  • Data Visualization Tools: AWS QuickSight (experience with Power BI or similar tools is also acceptable).
  • ETL Tools: AWS Glue and AWS Lambda.
  • Databases: SQL programming (experience with PostgreSQL and AWS Redshift).
• Exceptional project management skills, with the ability to organize and prioritize multiple tasks effectively.
• Strong interpersonal skills and the ability to collaborate with partners from various business units and levels within the organization.
• 3-5 years of experience in business intelligence, analytics, or related roles.
• Minimum 2 Year of hand-on experience on AWS Glue, Lambda, RDS, RedShift, S3
• A BS or MS degree in Engineering, Data & Analytics, Information Systems, or a related field (a master's degree is a plus).