Lead Analytics Engineer Enterprise BI & Analytics
On-siteChennai, Tamil Nadu, India
Job Summary
Own Power BI dashboards end-to-end across project profitability, resource utilization, pipeline, and FP&A by designing star-schema models, writing DAX, and building Power Query pipelines. Integrate and model data from HubSpot, finance/ERP, and Workday into clean, consistent schemas while debugging measure issues and diagnosing relationship ambiguities. Produce recurring reconciliations and variance analyses for leadership, audit source-data quality across systems, and build well-documented deliverables for US-based stakeholders. This role directly influences the data foundation for a company-wide analytics transformation within an AI-native digital agency.
Required Qualifications
- 5-7 years in data analysis or BI development
- significant hands-on Power BI work
- Strong, demonstrable skills in DAX
- Strong, demonstrable skills in Power Query (M)
- ability to build a model from raw exports to finished dashboard independently
- Solid data modeling fundamentals (star schema, fact vs. dimension tables, grain)
- ability to combine data from several source systems
- Advanced Excel
- comfort with reconciliation/variance work
- Strong attention to detail
- ability to explain technical results to non-technical stakeholders
- Strong SQL
- working familiarity with cloud data warehouses
- working familiarity with ELT tooling
Desired Qualifications
- Python (pandas) for data matching and reconciliation
- Experience with project profitability, utilization/capacity, or professional-services finance data
- CRM (especially HubSpot) data experience
- project/time-tracking data experience
- finance/ERP data experience (Workday)
- Experience reporting across multiple entities or business units
- Experience working in an AI-enabled environment, including using AI tools in day-to-day analytics/BI work
- Experience in integrated marketing, digital agency, marketing services, or consulting environments
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.