Analytics Engineer / BI & Data Engineer

CoolPeople Technology; Mannheim; Vor Ort; EUR 70.000 - 100.000; Vollzeit

Zusammenfassung

Unknown company is seeking an Analytics Engineer to lead migration and modernization of reporting within IFS Cloud. You will analyze SQL-based logic, design new BI solutions and work extensively with Power BI including advanced DAX. Build robust data models, optimize performance, and ensure reporting continuity during migration phases.

The role requires strong SQL, Power BI and data modeling skills, plus translating business requirements into technical solutions for ERP data structures.

Qualifikationen

• Analyze existing SQL-based reports, views, queries, start pages and business tools in IFS Applications 10.
• Identify embedded business logic, data dependencies and transformation rules for migration to IFS Cloud.
• Develop interim solutions to ensure reporting continuity during migration phases.
• Maintain and develop Power BI reports and dashboards for management and departments.
• Build semantic models, DAX measures and reusable data structures replacing legacy SQL reporting.
• Optimize refresh times, data volume, model structure and report performance.
• Model ERP master and transactional data for reporting and analytics.
• Document data sources, transformation logic, KPI assumptions and dependencies.
• Reduce dependency on undocumented expert knowledge.
• Collaborate with ERP, IT and business teams; translate requirements into BI solutions.
• Communicate technical constraints, risks and options to business and management.
• Advanced DAX knowledge for complex KPI logic.
• Very strong SQL skills including refactoring and recreating complex queries.
• Solid understanding of data modeling principles and ERP data structures.
• Understanding of BI model performance optimization.
• Good understanding of business processes and KPI logic.
• Experience with IFS Applications 10 and/or IFS Cloud.

Aufgaben

• Analyze existing SQL-based reports, views, queries, start pages and business tools in IFS Applications 10.
• Identify embedded business logic, data dependencies and transformation rules for redesign or migration to IFS Cloud.
• Develop interim or fallback solutions to ensure reporting availability during migration phases.
• Maintain, adapt and develop Power BI reports and dashboards for management and departments.
• Build semantic models, DAX measures and reusable data structures replacing legacy SQL reporting.
• Optimize refresh times, data volume, model structure and report performance.
• Model ERP master and transactional data for reporting and analytics.
• Document data sources, transformation logic, KPI assumptions and dependencies.
• Reduce dependency on undocumented expert knowledge hidden in SQL or workarounds.
• Collaborate with ERP, IT and business teams and translate requirements into BI solutions.
• Communicate technical constraints, risks and solution options to business and management.
• Advanced DAX knowledge with ability to design and optimize complex KPI logic.
• Very strong SQL skills including refactoring and recreating complex queries.
• Solid understanding of data modeling principles and ERP data structures.
• Understanding of BI model performance optimization.
• Good understanding of business processes and KPI logic.
• Experience with IFS Applications 10 and/or IFS Cloud.

Kenntnisse

SQL

Power BI

DAX

Data modeling

KPI logic

Requirements translation

Tools

REST APIs

JSON

Jobbeschreibung

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.

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

Nice to have

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