Business Intelligence - Data Engineer

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