Skip to content
CV Rocket
Get started
How it worksThe enginePricingBlogContactSign in

Open nowPosted yesterday

BI Lead

EXL82 open roles

Where
Jersey City, New Jersey, United States
Work mode
Hybrid
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowBI LeadEXL · Jersey City, New Jersey, United States

  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on EXL's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

10.5% of postings close within 7 days. Measured by our own scanner across the market. EXL postings stay open a median of 5 days.

Share of postings closed within
  1. 2.1%1 day
  2. 4.3%3 days
  3. 10.5%7 days
  4. 15.9%14 days
  5. 34.1%30 days
This job: posted yesterday

EXL median: 5 days open

The posting

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

Responsibilities

KEY RESPONSIBILITIES

  • 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 delivery.
  • Partner with data engineering teams to design analytics-ready data structures and resolve data issues at source.
  • Establish data governance frameworks covering data quality standards, metadata management, access controls, and KPI standardisation across business units.
  • Mentor BI developers through code and model reviews, sharing DAX, SQL, and design best practices to raise overall team capability.

MUST-HAVE SKILLS

Power BI

  • Semantic model design and optimisation: star-schema modelling, reducing cardinality, managing relationships, aggregations, and composite models.
  • Advanced DAX: efficient, reusable measures; evaluation context; CALCULATE; iterator functions; time intelligence patterns.
  • M / Power Query: advanced transformations, query folding, incremental refresh, parameter-driven pipelines.
  • Power BI Service governance: certified datasets, deployment pipelines, workspaces, row-level security, gateways, and refresh scheduling.
  • Self-service BI: promoting dataset reuse and enabling business users to build their own reports without IT dependency.

Tableau

  • Dashboard and data source design for enterprise-scale reporting.
  • Tableau Server / Tableau Cloud governance, published data sources, and performance optimisation.

SQL & Data Architecture

  • Strong SQL: complex queries, CTEs, window functions, query optimisation, and reading execution plans.
  • Data warehouse and dimensional modelling: fact/dimension design, schema validation, and data lineage.
  • ETL/ELT understanding: diagnosing and resolving upstream data issues that affect BI layers.

Communication & Stakeholder Engagement

  • Comfortable presenting architecture, data strategy, and roadmaps to client executives and technical leaders.
  • Skilled at requirements gathering from non-technical stakeholders and translating them into scalable BI solutions.
  • Experience leading architecture reviews, discovery workshops, and solution design sessions.

GOOD TO HAVE

  • Snowflake: query optimisation, warehouse sizing, and integrating Snowflake with Power BI or Tableau via DirectQuery or native connectors.
  • Sigma Computing: cloud-native self-service analytics on Snowflake; governed metrics, semantic model integration, and business user enablement.
  • Experience connecting Sigma Computing with existing Power BI and Tableau ecosystems without creating governance gaps or data duplication.
  • Working knowledge of policy lifecycle, claims, underwriting, premiums, loss ratios, and combined ratio.
  • Ability to translate insurance business questions into structured KPIs, metrics hierarchies, and dashboard designs.

Qualifications

bachelors in engineering or related field

From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against EXL's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.

  3. We apply on EXL's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.

  4. Every reply, sorted

    EXL's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.

  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

Get the CV for this job
By hand5–10
With CV Rocket100
applications a day

Nearby

Live postings like this one

Same employer first, then the same role elsewhere.

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.