Back
Login to See Your Match Score
Create a free account or log in to unlock your CV match score across:
Mid-level experience, metro location, and common BI skillset make competition moderate.
BI and SQL skills are transferable, but agency professional-services finance context adds moderate domain specificity.
Mandatory 5-7 years plus required Power BI/DAX/Power Query/SQL/data-modeling makes filters strict.
Lead developer responsible for end-to-end management of Power BI dashboards covering project profitability, resource utilization/capacity, client finance, pipeline, and FP&A.
Design and maintain star-schema data models, develop and troubleshoot DAX and Power Query (M) pipelines integrating multiple source systems (CRM, finance/ERP, time-tracking, resourcing).
Perform detailed variance and reconciliation analyses ensuring data quality and reliability to inform leadership decision-making across Finance, Operations, Sales, and HR.
5-7 years of experience in data analysis or BI development with significant hands-on Power BI expertise.
Strong skills in DAX, Power Query (M), data modeling fundamentals (star schema), and advanced Excel including reconciliation/variance analysis.
Experience integrating data from multiple source systems like CRM (HubSpot), finance/ERP (Workday), and project/time-tracking systems.
Strong SQL skills and familiarity with cloud data warehouses and ELT tools.
Highly proficient technically with deep experience building and maintaining complex Power BI models and scalable BI solutions in enterprise or multi-entity environments.
Demonstrated ability to collaborate across Finance, Operations, Sales, and HR to shape enterprise analytics strategy and data governance.
Prefer candidates with experience in professional services finance, marketing/digital agency or consulting industries, and familiarity with AI-enabled analytics environments.