Data Engineer (ETL for Power BI)

Scope of Work / Responsibilities:

* Understand business and reporting requirements by working with our project team and stakeholders.
* Transform existing operational reports (mainly in Excel format) into Power BI dashboards that follow the same structure and logic.
* Translate business logic and KPIs into effective data visualizations that support operational and strategic decision-making.
* Connect Power BI to our staging data warehouse (which extracts data from Integral and other sources).
* Ensure data accuracy and consistency by performing validation, thorough testing, and reconciliation against legacy reports, while incorporating feedback from stakeholders as needed.
* Optimize dashboard performance and apply necessary filters, drilldowns, and security access (RLS, if needed).
* Collaborate with our internal ETL team to ensure required data is made available in the data warehouse.
* Assist in troubleshooting and refining dashboards throughout the development cycle.
* Provide support during UAT, respond to user feedback, and incorporate changes as required.
* Document report definitions, data sources, logic, and calculations for future maintenance and knowledge sharing.
* Train users and provide walkthroughs to ensure smooth transition from legacy reports to Power BI dashboards.

Required Knowledge and Skills:

* Solid hands-on experience in Power BI development.
* Strong knowledge of data modeling, data warehousing, and business intelligence principles.
* Experience integrating with Microsoft SQL Server and other structured data sources.
* Able to understand and migrate logic from Excel-based reports to Power BI dashboards.
* Familiar with working in environments that involve ETL pipelines and staging databases.
* Detail-oriented with strong analytical, troubleshooting, and data validation skills.
* Experience in similar reporting transformation or migration projects is highly preferred.