Lead Analytics Engineer Enterprise BI & Analytics

Own our Power BI dashboards end-to-end across project profitability, utilization/capacity, pipeline/revenue, and FP&A — maintaining and improving the data model, relationships, DAX measures, and report layout.

Integrate and model data from multiple source systems — CRM (HubSpot), project/time-tracking, finance/ERP, and resourcing (Workday) — into clean, consistent star schemas that hold up across teams, entities, and our regional subsidiaries.

Build and debug Power Query (M) pipelines with typed column transformations, anti-join patterns for new-record ingestion, normalization, and refresh logic.

Develop and troubleshoot DAX measures (margin and profitability, utilization rates, coverage ratios, YTD totals, weighted pipeline, budget-vs-actual variance) and diagnose model issues like relationship ambiguity, filter propagation, and grain mismatches.

Produce the recurring reconciliations and variance analyses leadership relies on — project forecast-vs-actual, utilization vs. plan, and week-over-week pipeline snapshot comparisons.

Audit source-data quality across systems — flagging date problems, owner gaps, duplicates, and misclassified records before they reach a dashboard — and help strengthen our data governance and data-management standards.

Build clean, well-documented deliverables (multi-tab workbooks, reusable templates) and make the results clear to business partners and US-based leadership.