Senior Business Analyst- BI Reporting Amazon QuickSight

EXL Talent Acquisition Team; New Jersey; On-site; USD 90,000 - 150,000; Full time

Job summary

EXL is seeking an experienced BI professional to lead reporting analytics in the United States. The role focuses on defining the scope of QuickSight dashboards, gathering requirements, and coordinating with data engineering to deliver high-quality reports.

The candidate will conduct workshops with business stakeholders, validate data, and ensure timely delivery with sign-off from clients. Strong SQL and client-facing skills are essential for success.

Qualifications

• Approximately 8–12 years of experience in business intelligence, reporting, business analysis, or data analytics.
• Strong experience gathering and documenting dashboard and reporting requirements.
• Strong SQL and data-analysis skills.
• Working knowledge of Amazon QuickSight datasets, analyses, dashboards, calculated fields, parameters, filters, SPICE, direct query, and security.
• Strong understanding of KPIs, dimensional data models, aggregations, data granularity, and reconciliation.
• Experience preparing report specifications, source-to-report mappings, wireframes, and acceptance criteria.
• Strong client-facing, workshop-facilitation, documentation, and communication skills.

Responsibilities

• Conduct workshops with business users, product owners, data owners, and technology stakeholders.
• Understand business objectives, reporting use cases, user personas, KPIs, and analytical requirements.
• Define the scope and priority of each new QuickSight report or dashboard.
• Prepare report wireframes or mock-ups and obtain client approval.
• Identify source tables, views, fields, joins, filters, and data granularity.
• Document source-to-report mappings and transformation rules
• Coordinate with the client’s data-engineering team in lieu of Reporting Data requirements
• Maintain the reporting backlog, priorities & RAID
• Perform functional testing and data reconciliation.
• Coordinate report demonstrations, UAT, defect resolution, and business sign-off.
• Coordinate production deployment and post-production validation.

Skills

SQL

BI

Dashboard requirements gathering

Workshop facilitation

Data reconciliation

Stakeholder communication

Tools

Amazon QuickSight

Job description

Key Responsibilities

• Conduct workshops with business users, product owners, data owners, and technology stakeholders.
• Understand business objectives, reporting use cases, user personas, KPIs, and analytical requirements.
• Define the scope and priority of each new QuickSight report or dashboard.
• Prepare report wireframes or mock-ups and obtain client approval.
• Identify source tables, views, fields, joins, filters, and data granularity.
• Document source-to-report mappings and transformation rules
• Coordinate with the client’s data-engineering team in lieu of Reporting Data requirements
• Maintain the reporting backlog, priorities & RAID
• Perform functional testing and data reconciliation.
• Coordinate report demonstrations, UAT, defect resolution, and business sign-off.
• Coordinate report demonstrations, UAT, defect resolution, and business sign-off.
• Coordinate production deployment and post-production validation.

Required Skills and Experience:

• Approximately 8–12years of experience in business intelligence, reporting, business analysis, or data analytics.
• Strong experience gathering and documenting dashboard and reporting requirements.
• Strong SQL and data-analysis skills.
• Working knowledge of Amazon QuickSight datasets, analyses, dashboards, calculated fields, parameters, filters, SPICE, direct query, and security.
• Strong understanding of KPIs, dimensional data models, aggregations, data granularity, and reconciliation.
• Experience preparing report specifications, source-to-report mappings, wireframes, and acceptance criteria.
• Strong client-facing, workshop-facilitation, documentation, and communication skills.