Lead BI architecture and solution design; build and optimize Power BI and Tableau semantic models; write and tune DAX, Power Query, and SQL; architect dimensional data models; define governance, CI/CD, and deployment standards; partner with data engineering; drive self-service BI and mentor BI developers.
We are seeking a skilled BI Lead with 10+ years of experience in designing, developing, and supporting business intelligence solutions. The ideal candidate will have strong expertise in Power BI, Tableau, SQL, and data modeling, with the ability to translate business requirements into impactful dashboards and reports. Experience working with modern cloud data platforms and insurance analytics is a plus.
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.
Qualifications
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.
- Bachelor's degree in Computer Science, Information Systems, Data Analytics, Statistics, Business Analytics, or a related field.
- 7+ years of experience in Business Intelligence, Reporting, Data Analytics, or a related role.
- Strong passion for data visualization, analytics, and delivering business insights through data.
Base Compensation Range: $100-135k
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.
About Us EXL (NASDAQ: EXLS) is a leading data analytics and digital operations and solutions company. We partner with clients using a data and AI-led approach to reinvent business models, drive better business outcomes and unlock growth with speed. EXL harnesses the power of data, analytics, AI, and deep industry knowledge to transform operations for the world’s leading corporations in industries including insurance, healthcare, banking and financial services, media and retail, among others. EXL was founded in 1999 with the core values of innovation, collaboration, excellence, integrity and respect. We are headquartered in New York and have more than 54,000 employees spanning six continents. For more information, visit www.exlservice.com.
What you need to know about the Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
