Business Intelligence - Data Engineer
Posted Updated
Summary
Builds and maintains business reporting and data solutions in the Microsoft ecosystem: Power BI reports, dashboards, and semantic models fed by ERP, SharePoint, Excel, and third-party data, using DAX, Power Query/M, SQL, Microsoft Fabric, and Power Automate, while automating manual reporting tasks and documenting logic.
Responsibilities
- Build and maintain reporting and data solutions used across the business.
- Work with data from ERP systems, Excel files, SharePoint, Microsoft Lists, third-party platforms, and other operational sources.
- Prepare, clean, combine, and validate data before it is used for reporting.
- Build and maintain Power BI reports, dashboards, semantic models, and KPIs.
- Create and maintain data pipelines and transformation processes.
- Automate repetitive reporting and operational tasks.
- Troubleshoot data issues and reconcile differences between systems.
- Support recurring reporting as well as ad hoc business requests.
- Work with different departments to understand their needs and turn them into useful reporting or automation solutions.
- Improve existing processes by simplifying them, removing unnecessary manual work, and finding more reliable ways of doing things.
- Document important processes, business rules, and reporting logic.
- Take ownership of projects from understanding the problem through implementation and validation.
Tools and Technical Skills
The role works primarily within the Microsoft data and reporting ecosystem.
Main tools
- Power BI
- Microsoft Fabric
- Power Query / M
- DAX
- SQL
- Power Automate
- SharePoint
- Microsoft Lists
- Excel
Additional useful skills
- Python / Pandas
- Data modeling
- ETL / ELT
- External data sources
- Forecasting and statistical analysis
- Microsoft Power Platform