BI Lead

EXL

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

Posted 10/16/2026full-timeJersey City • New Jersey • United StatesSenior💰 $140,000 - $160,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in BI architecture, Power BI and Tableau design, and data governance frameworks. Proficient in advanced DAX, SQL, and M/Power Query transformations to deliver scalable and optimized BI solutions.

Highest-signal resume keywords

Power BI Semantic Model DesignAdvanced DAX ProficiencySQL Query OptimizationData Governance FrameworksTableau Dashboard Design

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Power BIDAXM/Power QuerySQLData Warehouse ModellingETL/ELTDimensional ModellingData Quality DiagnosisCI/CD PipelinesData Governance

Soft Skills

MentoringRequirements GatheringClient Presentation

Tools & Technologies

Power BI ServiceTableauSnowflakeSigma Computing

Industry Keywords

Data AnalyticsBusiness IntelligenceInsurance Domain

Tech Stack

Tools & technologies

ETLSQLTableau

About the role

Key responsibilities & impact

Lead BI architecture and solution design conversations with clients 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 DAX measures, M/Power Query transformations, and SQL queries
Diagnose and resolve data model, relationship, cardinality, and upstream data quality issues
Architect dimensional data models and semantic layers across multiple BI tools
Drive self-service BI by certifying datasets, defining governed metrics, and enabling business teams
Define BI deployment standards, CI/CD pipelines, and release governance
Partner with data engineering teams on analytics-ready data structures and source data issues
Establish data governance frameworks for data quality, metadata, access controls, and KPI standardisation
Mentor BI developers through code and model reviews and share best practices

Requirements

What you’ll need

Bachelor's degree in engineering or related field
Advanced Power BI semantic model design and optimisation
Advanced DAX, including evaluation context, CALCULATE, iterator functions, and time intelligence patterns
Advanced M / Power Query transformations, query folding, incremental refresh, and parameter-driven pipelines
Power BI Service governance, including certified datasets, deployment pipelines, workspaces, row-level security, gateways, and refresh scheduling
Tableau dashboard and data source design, governance, and performance optimisation
Strong SQL, including complex queries, CTEs, window functions, query optimisation, and execution plans
Data warehouse and dimensional modelling, including fact/dimension design, schema validation, and data lineage
ETL/ELT understanding and upstream data issue diagnosis
Ability to present architecture, data strategy, and roadmaps to client executives and technical leaders
Requirements gathering from non-technical stakeholders and translation into scalable BI solutions
Experience leading architecture reviews, discovery workshops, and solution design sessions
Snowflake, Sigma Computing, and insurance-domain knowledge are good to have

Benefits

Comp & perks

Benefits information provided at https://www.exlservice.com/us-careers-and-benefits