BI Lead

Inizio Partners Corp•Jersey City, NJ

4d•Hybrid

About The Position

We are seeking multiple BI Leads (Power BI / Tableau) to join our team in Jersey City, NJ. This is a hybrid role with 5 positions available (3 Architects & 2 Leads). The BI Lead will be responsible for leading BI architecture and solution design conversations with clients, acting as the primary technical authority on data and analytics platforms. They will design, build, and optimize Power BI semantic models and Tableau data sources for enterprise-scale performance and maintainability. Responsibilities include writing and optimizing complex DAX measures, M/Power Query transformations, and SQL queries, as well as diagnosing and resolving data model issues. The role involves architecting dimensional data models and semantic layers, driving self-service BI capabilities, defining BI deployment standards, and partnering with data engineering teams. Establishing data governance frameworks and mentoring BI developers are also key aspects of this position.

Requirements

Power BI Semantic model design and optimization: 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 optimization.
Strong SQL: complex queries, CTEs, window functions, query optimization, 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.
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.

Responsibilities

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 optimize 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 programs 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.