Avesoro
Data & BI Analyst (FP&A)
AvesoroTurkey1 day ago
Full-timeResearch, Analyst +1
Role Summary

We are seeking a hands-on Data & BI Analyst to own the data pipeline from our ERPs into a governed DWH, model the data for analytics, and deliver executive-grade Power BI dashboards. You will work primarily on Microsoft Fabric (Lakehouse / Data Warehouse, Dataflows Gen2, Pipelines) with strong SQL and data modeling skills, and provide on-demand Excel extracts when needed. The ideal candidate has prior project experience delivering end-to-end BI solutions (data ingestion → modeling → visualization → rollout).

Key Responsibilities
  • Data ingestion & DWH: Build/maintain ELT pipelines from ERPs (e.g., SAP / Microsoft Dynamics / Logo) into Microsoft Fabric (Lakehouse/DWH).
  • Data modeling: Design robust star schemas (facts/dimensions), semantic models, and DAX measures aligned to FP&A definitions (Revenue, OPEX/CAPEX, Cost Centers, BvA, Cash Flow).
  • Power BI development: Deliver scalable, well-documented reports and executive dashboards; optimize performance (model size, aggregations, incremental refresh).
  • Data quality & governance: Implement validation rules, reconciliation checks to source, lineage & documentation; enforce KPI definitions and security/row-level security.
  • Automation & scheduling: Orchestrate refreshes with Fabric Pipelines / Dataflows Gen2; monitor failures and SLAs.
  • Stakeholder enablement: Partner with FP&A, Site Finance, Operations; collect requirements, run UAT, create how-to guides and training.
  • Ad-hoc analytics & Excel support: Provide curated Excel extracts and self-serve datasets where appropriate.
  • Project delivery: Manage BI work items (backlog, milestones, releases), track issues, and communicate progress.
Must-Have Qualifications
  • Bachelor’s degree in Engineering (IE/CE/SE), Information Systems, Statistics, Economics, or similar.
  • 3–5+ years in Data/BI roles delivering end-to-end analytics projects.
  • Strong SQL and data modeling (star schema, dimensions/facts, surrogate keys, slowly changing dimensions).
  • Solid Power BI (Power Query, DAX, model optimization) and Microsoft Fabric experience (Lakehouse/DWH, Dataflows Gen2, Pipelines).
  • Experience integrating data from ERPs (SAP, Dynamics, Logo or similar).
  • Proven track record in data quality, reconciliation, and documentation.
  • Fluent English (written & spoken); strong communication with finance stakeholders.
Preferred Qualifications
  • Experience in FP&A analytics (BvA, forecasting, cost & unit-cost KPIs, cash-flow analytics).
  • Knowledge of Git/version control, Dev/Test/Prod promotion, and release management.
  • Performance tuning (DirectQuery/Import/Composite models, aggregations, partitioning).
  • Exposure to Power BI governance (RLS/OLS, workspace/app lifecycle, deployment pipelines).
  • Familiarity with Python for data tasks and REST/ODBC connectivity.
  • Sector experience in mining, energy, or industrial environments; French is a plus.


Key Skills

Ranked by relevance
Apply