Analytics Engineer / BI & Data Engineer

Job Description

I 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.

\n

Project

\n

- 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

\n

- 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 REST APIs, 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