Data Analyst & BI Specialist

Exor International S.P.A.; Bologna; Hybrid; EUR 35,000 - 40,000; Full time

Job summary

Exor International S.P.A. in Bologna, Italy, seeks a Data Analyst/BI Specialist to transform data from MES, ERP and other systems into insightful dashboards that drive operational improvements.

The role focuses on designing Power BI reports, building robust data models with DAX, managing ETL pipelines, ensuring data quality, and enabling decision-making across production and quality domains. Remote work up to two days per week is available.

Qualifications

• 3+ years of experience in BI/Data Analytics in manufacturing or similar.
• Expertise in Power BI Desktop and Service.
• Strong knowledge of DAX and data modeling concepts.
• Experience building and optimizing ETL pipelines.

Responsibilities

• Design, develop, and maintain Power BI dashboards and reports for KPIs in production and quality.
• Collaborate with MES team to translate needs into data models and reporting.
• Implement and optimize Power BI data models with DAX and best practices.
• Manage report refresh, publishing, and security.
• Develop ETL pipelines from MES, SQL databases, and APIs.
• Ensure data quality and traceability for decision making.
• Provide documentation and user training.

Skills

Power BI

DAX

Data modeling

ETL

SQL

Azure

Education

Degree in Computer Science, Management Engineering, Computer Engineering, Statistics, Mathematics

Tools

SQL Server

Apache NiFi

Grafana

Prometheus

Azure

MES integration

Job description

The Data Analyst/BI Specialist is responsible for collecting, integrating, modeling, and leveraging data from company systems (MES, ERP, quality and production systems), transforming it into useful information to support decision-making and improve operational performance.

Responsibilities

• Leading sales and business development in the designated region.

Key Responsibilities and Activities:

• Design, develop, and maintain Power BI dashboards and reports to monitor KPIs related to production, quality, efficiency, and operational performance.
• Collaborate with the MES application development team to define metrics and translate operational needs into data models and structured reporting.
• Implement and optimize Power BI data models using DAX, modeling best practices, and performance tuning strategies.
• Manage report refresh and publishing processes, ensuring reliability, security, and performance.
• Develop and maintain ETL pipelines for ingesting and transforming data from MES, SQL databases, and corporate APIs.
• Ensure the quality, consistency, and traceability of data used in decision-making processes.
• Monitor and support data loading processes and Business Intelligence services, identifying and resolving any anomalies.
• Draft technical and functional documentation and provide training support to end users.

Required Skills and Knowledge:

At least 3 years of experience in the role and in the specific context required.

Business Intelligence and Reporting

Excellent knowledge of Power BI Desktop and Power BI Service.

Experience designing management and operational dashboards.

Advanced knowledge of the DAX language.

Experience in data modeling (star schema, dimensions, facts).

Experience in performance optimization and incremental refresh management.

Data Integration and Database

Knowledge of Apache NiFi or equivalent data integration tools.

Good knowledge of SQL Server and the SQL language.

Experience integrating data from MES and REST API services.

Monitoring and Automation

Knowledge of automation processes and refresh scheduling.

Familiarity with monitoring tools such as Grafana and Prometheus.

Preferred factors:

Experience in manufacturing or industrial environments.

Knowledge of production processes, quality, OEE, and factory KPIs.

Experience with MES systems.

Familiarity with Microsoft Azure cloud environments.

Experience in multinational and multi-site environments.

Analytical skills and problem-solving attitude.

Ability to interact with technical and business stakeholders.

Ability to organize work independently.

Structured approach to documentation and standardization.

Good communication and user training skills.

Education:

Degree in Computer Science, Management Engineering, Computer Engineering, Statistics, Mathematics, or related disciplines.

Working hours:

Full-time with the option of remote working two days a week.

Classification:

CCNL Tertiary Trade.

Approximate salary:

€35,000-€40,000 (defined based on objective and gender-neutral criteria).