Analytics Engineer / Bi & Data Engineer

Job DescriptionI am looking for an experienced Analytics Engineer to join a reporting migration and modernization project within IFS Cloud. You will analyze existing SQL-based logic, design new BI solutions and work extensively with Power BI, including advanced DAX. Your responsibilities will include building robust data models, optimizing performance and ensuring reporting continuity. I expect strong expertise in SQL, Power BI and data modeling, along with the ability to translate business requirements into technical solutions.\ NProject

analyze existing SQL-based reports, views, queries, start pages and business tools in IFS Applications 10\ N identify embedded business logic, data dependencies and transformation rules for redesign or migration to IFS Cloud\ N develop interim or fallback solutions to ensure reporting availability during migration phases\ N maintain, adapt and develop Power BI reports and dashboards for management and departments\ N build semantic models, DAX measures and reusable data structures replacing legacy SQL reporting\ N optimize refresh times,data volume, model structure and report performance\ N model ERP master and transactional data for reporting and analytics\ N document data sources, transformation logic, KPI assumptions and dependencies\ N reduce dependency on undocumented expert knowledge hidden in SQL or workarounds\ N collaborate with ERP, IT and business teams and translate requirements into BI solutions\ N communicate technical constraints, risks and solution options to business and management\ N

Skills

strong hands-on expertise in Microsoft Power BI (semantic modeling, report development, Power Query)\ N advanced DAX knowledge with ability to design and optimize complex KPI logic\ N very strong SQL skills including refactoring and recreating complex queries\ N solid understanding of data modeling principles and ERP data structures\ N understanding of BI model performance optimization\ N good understanding of business processes and KPI logic\ N experience with IFS Applications 10 and/or IFS Cloud\ N

Nice to have

\ N experience with data warehouse concepts (staging, transformation, semantic layers)\ N basic knowledge of RESTAPIs, JSON and integration logic in cloud ERP environments\ N experience in manufacturing, logistics, finance, quality or project-based environments\ N experience with ERP migration, reporting modernization or transformation programs\ N

Anzeige melden