> Markdown version of [/jobs/ext/600380-bi-lead-power-bi-tableau](https://www.wearedevelopers.com/jobs/ext/600380-bi-lead-power-bi-tableau). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # BI Lead (Power BI/Tableau - **Company:** Marici Solutions - **Location:** Jersey City, NJ, United States - **Experience:** Expert - **Salary:** $135,200.0 - **Contract:** Permanent contract - **Skills:** Business Analytics Applications, Business Intelligence Development, Data Architecture, Information Engineering, Data Governance, Extract Transform Load (ETL), Data Structures, Data Warehousing, Meta-Data Management, Performance Tuning, Query Optimization, Power BI, Standard Sql, SQL Databases, Tableau (Software), Delivery Pipeline, Snowflake, Data Strategy, Powerquery, Data Layers, Data Lineage, Star Schema - **Published:** June 23, 2026 - **Apply:** https://www.dice.com/job-detail/4110122b-2f91-43ff-9cbd-db7e7859cab2 ## About the Role We have an urgent requirement for a Lead BI professional with strong expertise in both Power BI and Tableau. NOTE - The ideal candidate should have extensive hands-on experience with Power BI and a solid background in Tableau. In recent years, they should have been working in a Lead or Architect capacity, demonstrating both technical leadership and solution ownership. This role requires a balance of 70% hands-on development and architecture work and 30% leadership, stakeholder management, and team guidance. We are looking for someone who can actively contribute to BI solution delivery while also leading initiatives and mentoring team members., * 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. ## Description * Lead BI architecture and solution design conversations with clients, acting as the primary technical authority on data and analytics platforms. * Design, build, and optimize 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 standardization 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. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Blueprints for Success: Steering a Global Data & AI Architecture](https://www.wearedevelopers.com/videos/1577-blueprints-for-success-steering-a-global-data-ai-architecture) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)