Senior BI Analyst & Reporting Strategist

Ex; New Jersey; On-site; USD 95,000 - 130,000; Full time

Job summary

Ex is seeking a senior Business Intelligence professional in New Jersey to lead BI initiatives, design dashboards in Amazon QuickSight, and coordinate with clients and data teams. The role emphasizes requirements gathering, KPI modeling, and data reconciliation to deliver high-quality reporting solutions.

The candidate will run workshops with stakeholders, define priorities, create wireframes, and ensure successful UAT, sign-off, and production deployment with robust testing and documentation.

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 report demonstrations, UAT, defect resolution, and business sign-off.
• Coordinate production deployment and post-production validation.

Skills

BI

SQL

Data analysis

Dashboard design

Requirements gathering

Stakeholder mgmt

Tools

Amazon QuickSight

Job description

Ex is seeking a senior Business Intelligence professional in New Jersey to lead BI initiatives, design dashboards in Amazon QuickSight, and coordinate with clients and data teams. The role emphasizes requirements gathering, KPI modeling, and data reconciliation to deliver high-quality reporting solutions.

The candidate will run workshops with stakeholders, define priorities, create wireframes, and ensure successful UAT, sign-off, and production deployment with robust testing and documentation.