Junior Business Intelligence and Process Analyst

ATG Europe; Frascati; On-site; EUR 28,000 - 36,000; Full time

Job summary

ATG Europe is seeking a Junior Business Intelligence and Process Analyst in Frascati/Rome area to support data analysis, reporting, and process documentation. You will maintain Excel, Power Query, and Power BI solutions, validate data, and help end users understand reports and tools with clear communication.

The role offers growth as you learn business processes and build technical skills. The position requires a degree in a relevant field and at least 2 years of experience, along with strong

Qualifications

• Bachelor’s or Master’s degree required; recent graduates encouraged to apply.
• At least 2 years of relevant practical experience gained through internships, academic projects, or professional roles.
• Working knowledge of Microsoft Excel, including formulas, tables, PivotTables, and data validation.
• Practical knowledge of Power Query for preparing, cleaning, combining, and transforming data.
• Basic practical knowledge of Power BI, including data modelling and reporting.
• Understanding of basic data analysis, reporting, and business process documentation.
• Fluency in English, both written and spoken.
• Candidates must be eligible to work in the EU.

Responsibilities

• Prepare, maintain, and validate data using Excel, Power Query, and related tools.
• Support the development, testing, and maintenance of Power BI dashboards and reports.
• Document data sources, transformations, and validation rules.
• Assist with process analysis, mappings, and user guides.
• Collaborate with Operations, Finance, IT, and other departments to understand reporting needs.
• Provide user-friendly explanations of dashboards and reporting tools.

Skills

Excel

Power Query

Power BI

Data analysis

Documentation

Communication

Attention to detail

Problem solving

Education

Bachelor’s or Master’s degree in Business Analytics, Data Science, Information Systems, Business Administration, Engineering, Economics, or another relevant discipline

2 years of relevant experience

Tools

SQL

Power Apps

Power Automate

SharePoint

Python

VBA

Job description

We are looking for a Junior Business Intelligence and Process Analyst on behalf of and in support to our client for their location in Frascati, Italy.

We are looking for a Junior Business Intelligence and Process Analyst to join the Quality & Information Management Department at ATG Italy in Rome. The role will support data analysis, operational reporting, the maintenance of business intelligence solutions, and the documentation and improvement of business processes.

The successful candidate will initially focus on maintaining existing Excel, Power Query, and Power BI solutions, preparing and validating data, maintaining structured datasets and operational records, and supporting recurring and ad hoc reporting. Responsibilities will expand progressively as the candidate develops technical skills and familiarity with the business processes.

The role involves working with colleagues and end users to understand their needs, clarify requirements, and help them use reports and related tools effectively. We are looking for an early-career professional with analytical thinking, strong attention to detail, curiosity, and clear communication skills, who can patiently support users with varying levels of familiarity with data analysis.

Please note, the successful candidate will be employed by ATG Europe (or one of its subsidiaries). Furthermore, upon selection, they will be subject to a general security screening performed by an external provider (further information will be provided at interview stage).

The successful candidate will be tasked with, but not limited to:

Data Preparation and Maintenance:

• Collect, clean, transform, and validate data from multiple sources using Excel, Power Query, and related tools;

• Maintain structured datasets, databases, and operational records, ensuring accuracy, consistency, and completeness;

• Identify missing data, errors, duplicates, and inconsistencies, and resolve or elevate them as appropriate;

• Maintain clear documentation of data sources, transformations, assumptions, and validation rules.

Business Intelligence and Reporting:

• Support the development, testing, maintenance, and documentation of Power BI dashboards and reports;

• Maintain and troubleshoot existing Excel and Power Query solutions used for recurring data preparation and reporting;

• Create and update visualisations, datasets, and basic DAX measures based on agreed requirements and reporting standards;

• Prepare recurring and ad hoc reports, checking their accuracy and ensuring timely delivery;

• Support the definition, documentation, and tracking of KPIs and performance metrics.

Process Analysis and Documentation:

• Support the analysis of business processes to identify inefficiencies, bottlenecks, and improvement opportunities;

• Collect information from stakeholders and translate it into clear process descriptions and business requirements;

• Prepare and maintain process maps, workflow documentation, and user guides;

• Assist with the implementation, testing, and monitoring of agreed process improvements and automation initiatives.

Stakeholder Collaboration and User Support:

• Work with colleagues from Operations, Finance, IT, HRM, and other departments to understand their reporting and process need;

• Participate in requirement-gathering sessions, clarify requests, and document agreed actions and expected outcomes;

• Help users understand and use dashboards, reports, and related Microsoft 365 tools, adapting explanations to their level of technical knowledge;

• Provide patient, clear support and collect user feedback to improve the usability of reporting solutions;

• Escalate unclear requirements, data-quality issues, technical problems, or delivery risks to the responsible team member.

Continuous Improvement and Development:

• Contribute ideas to improve data quality, reporting workflows, and team processes;

• Build technical and business knowledge through practical assignments, feedback, and training;

• Apply agreed standards for documentation, validation, and responsible handling of data;

• Develop increasing independence in routine activities while seeking guidance when needed.

Project Support:

• Provide analytical, reporting, and process-documentation support to internal ATG initiatives and client-related projects;

• Contribute to temporary project or client assignments with clearly defined responsibilities, priorities, and appropriate guidance.

ATG is dedicated to diversity and inclusion and is an equal opportunity employer. Regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, handicap (categorie protette L.68/99 art.1), or any other reason protected by relevant state or municipal legislation, we are pleased to consider all eligible candidates for employment.
Please ensure that your CV clearly explains how you meet the mandatory requirements. If it doesn’t align completely with the essential criteria, it could result in rejection.

• Bachelor’s or Master’s degree in Business Analytics, Data Science, Information Systems, Business Administration, Engineering, Economics, or another relevant discipline; recent graduates are encouraged to apply;

• At least 2 years of relevant practical experience gained through internships, academic projects, or professional roles, typically within the first two years of a career;

• Working knowledge of Microsoft Excel, including formulas, tables, PivotTables, and data validation;

• Practical knowledge of Power Query for preparing, cleaning, combining, and transforming data;

• Basic practical knowledge of Power BI, including data modelling, report creation, and basic DAX measures, gained through academic or professional projects;

• Understanding of basic data analysis, reporting, and business process documentation;

• Strong attention to detail when maintaining datasets, checking results, and identifying errors or inconsistencies;

• Good analytical, organisational, and problem-solving skills, with the ability to follow agreed priorities and meet deadlines;

• Clear written and verbal communication skills, including the ability to understand end-user needs and patiently explain concepts to users with limited knowledge of data analysis;

• Willingness and ability to learn new tools and business processes, apply feedback, and work collaboratively;

• Familiarity with SharePoint, Power Apps, or Power Automate is an asset;

• Experience creating dashboards, reports, or process documentation through academic, internship, volunteer, or professional work is an asset;

• Basic knowledge of SQL for querying and validating data is an asset;

• Familiarity with Python or VBA for data preparation, analysis, or automation is an asset;

• Awareness of data quality, data governance, and information-management principles is an asset;

• Experience preparing user guides or helping users understand reporting tools is an asset;

• An interest in process improvement, automation, and designing reports that are clear and useful to end users is an asset;

• Fluency in English, both written and spoken;

• Candidates must be eligible to work in the EU.

The salary range advertised reflects our initial expectations for the role and our internal salary scheme. However, we encourage applications from candidates whose experience may fall outside the target profile. Any offer made will be tailored to the candidate’s qualifications, professional achievements, technical expertise, and other objective criteria relevant to the position. Salary, benefits, and other employment conditions will be discussed openly during the recruitment process.

• CCNL Level: Level 4
• CCNL Type: CCNL Terziario, Distribuzione e Servizi
• Due date: 2026-11-13