4423637-Manager

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

Job summary

EXL Talent Acquisition Team seeks an experienced Business Intelligence Analyst to design and deliver BI solutions, including ETL using AWS Glue and Lambda, and dashboards with AWS QuickSight and Power BI. You will work across IT, Finance, and business stakeholders to translate requirements into scalable analytics and insights.

The role emphasizes end-to-end ownership of BI projects, leveraging existing SQL queries, building new ones, and delivering automation through data visualizations and

Qualifications

• Strong problem-solving and analytical abilities to translate data into insights.
• Ability to lead projects and collaborate with cross-functional teams.
• Experience designing scalable BI solutions and data assets.
• Proficient in SQL and data visualization tools such as AWS QuickSight or Power BI.

Responsibilities

• Visualization and Reporting: Design interactive dashboards and reports for stakeholders.
• Data Analysis: Analyze data, identify insights, and advise actions for sales leaders.
• Solution Design: Translate requirements into scalable BI solutions.
• Data Asset Creation: Build data assets from internal warehouses and external datasets.
• ETL Development: Design and implement ETL processes with a focus on automation.
• Collaboration: Work with data analysts and sales teams to gather feedback.
• Documentation and Training: Create docs and train users on BI dashboards.

Skills

Problem-solving

Analytical thinking

Leadership

Interpersonal skills

Education

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

Tools

AWS QuickSight

Power BI

AWS Glue

AWS Lambda

PostgreSQL

AWS Redshift

SQL

Job description

Business Intelligence Analyst (Minimum Five 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.
• 5-8 years of experience in business intelligence, analytics, or related roles.
• A BS or MS degree in Engineering, Data & Analytics, Information Systems, or a related field (a master's degree is a plus).