BI Lead

Ex; Jersey City (NJ); On-site; USD 140,000 - 160,000; Full time

Job summary

EXL Service in Jersey City seeks a senior BI lead to drive architecture conversations and act as the technical authority on data and analytics platforms. You will design, build, and optimise Power BI semantic models and Tableau data sources for enterprise-scale performance and maintainability.

You will write complex DAX, M/Power Query and SQL queries to support accurate reporting, diagnose data model issues, and guide governance and CI/CD practices across the BI stack.

Qualifications

• Experience leading BI architecture discussions with stakeholders.
• Proven ability to design scalable BI solutions using Power BI and Tableau.
• Strong SQL, DAX, and M/Power Query skills for data transformations.
• Experience with dimensional modeling (star schema).

Responsibilities

• Lead BI architecture conversations with clients and act as primary technical authority.
• Design, build, and optimise semantic models and data sources for enterprise-scale performance.
• Write and optimise DAX, M/Power Query and SQL queries for accurate reporting.
• Diagnose and resolve data model issues and data quality problems.
• Define BI deployment standards, CI/CD pipelines, and governance.

Skills

BI architecture

Power BI

Tableau

DAX

Power Query

SQL

Data modeling

CI/CD

Data governance

Tools

Power BI

SQL Server

Job description

Lead BI architecture and solution design conversations with clients, acting as the primary technical authority on data and analytics platforms.

Design, build, and optimise Power BI semantic models and Tableau data sources for enterprise-scale performance and maintainability.

Write and optimise complex DAX measures, M/Power Query transformations, and SQL queries to support accurate, high-performance reporting.

Diagnose and resolve data model issues - slow DAX, broken relationships, cardinality problems, and upstream data quality issues - quickly and systematically.

Architect dimensional data models (star schema, fact/dimension design) and semantic layers consumed across multiple BI tools.

Drive self-service BI capability: certify datasets, define governed metrics, and build enablement programmes so business teams can explore data independently.

Define BI deployment standards, CI/CD pipelines, and release governance to ensure reliable and secure analytics deliver

Base Compensation Range: 140,000 - 160,000

The posted range is the hiring range for this role - a subset of the broader range available to employees over time - and reflects base salary across our national hiring scale. Final offers are based on several factors, including the candidate's skills and experience, internal pay equity, work location, market conditions for the role, and the specific scope and responsibilities of the position. The top of the range is reserved for candidates who notably exceed the requirements; the lower end applies to those with less experience or fewer preferred qualifications. For positions based in higher-cost zones (e.g., California, New York, New Jersey), actual compensation may exceed the posted range; your recruiter will share specifics during the process.

For more information on benefits and what we offer please visit us at https://www.exlservice.com/us-careers-and-benefits