The consultant will be expected to combine technical delivery capabilities , business analysis skills , and project support experience , with the objective of translating business requirements into effective, maintainable, and compliant technical solutions.

The role is intended to support both application and data-related initiatives , with a strong focus on Microsoft technologies used across the data integration, analytical, and reporting landscape, including Microsoft SQL Server , SQL Server Integration Services (SSIS) , Azure Data Factory , Azure SQL , and Power BI . The referenced architecture explicitly describes a layered solution including an integration layer, data warehouse layer, analytical layer, and presentation layer based on these technologies.

Role Scope

The consultant will provide professional services in the following areas:

- Support Market IT in the analysis, delivery, enhancement, and maintenance of solutions.
- Work with business stakeholders to collect, clarify, and formalize requirements, and convert them into functional and technical implementation proposals.
- Support technical delivery across data integration, reporting, and business application domains.
- Contribute to project execution and coordination in accordance with Customer policies, procedures, governance, and development standards . Customer development standards explicitly require consistency, governance, maintainability, security, scalability, and compliance with standard development patterns and controls.
- The consultant will provide support to the Italian and Greece market.

Required Service Profile

1. Technical Competencies

The consultant must demonstrate strong hands-on capability in the following technologies:

- Microsoft SQL Server
- SQL Server Integration Services (SSIS)
- Microsoft Azure Data Factory
- Visual Basic / C# Scripting and Development
- T-SQL , DAX , Power Query and Power BI Data Flows




- Power Apps development
- Power BI data model / dataset maintenance and development
- Data source connection and dataset publishing
- Data modelling in Power BI Desktop
- Power BI report development (an asset but not required)
- The relevant Customer architecture explicitly includes SQL Server Database , SSIS , Azure Data Factory , Azure SQL , Power BI , Power App and Power Automate as core technologies supporting the integration, warehouse, and presentation layers.

2. Business Analysis Competencies and Project Management

The consultant must have solid experience as an IT Business Analyst , including:

- Eliciting and documenting business requirements
- Performing impact and gap analysis
- Translating business needs into functional and technical solutions
- Preparing clear and structured documentation
- Working effectively with both IT and business stakeholders
- Project Management for small and medium projects
- Knowledge of agile approaches in Development and Project Management

Key Responsibilities

The consultant will be expected to:

- Collaborate closely with Market business stakeholders to understand business requirements and translate them into technical solutions.
- Design, develop, maintain, and optimize ETL / integration solutions using SQL Server , SSIS , T-SQL , and Azure Data Factory .
- Maintain and enhance Power BI data models / datasets , ensuring consistency, usability, and maintainability.
- Design and develop Power Apps solutions where required to support business processes.




- Support testing, troubleshooting, correction, enhancement, and controlled deployment activities.
- Produce or maintain functional and technical documentation.
- Support project execution and coordination in line with internal governance requirements.
- Support application portfolio maintenance through the use of the ServiceNow system.

Governance and Ways of Working

The consultant is expected to work according to Customer delivery principles and standards, including:

- Compliance with documented development standards and governance
- Structured and controlled implementation practices
- Alignment with security and access management expectations
- Use of approved tooling and architecture patterns
- Support for maintainability, scalability, and robustness of the delivered solutions

Preferred Professional Background

Suitable vendors should propose consultants with:

- Strong experience in data integration , business intelligence , and business application support/development
- Proven delivery experience in business-facing IT environments
- Experience working with distributed stakeholders and market-facing teams
- Ability to combine technical delivery with business analysis and project support responsibilities
- Strong communication and collaboration skills
- Proficiency in English , both written and spoken, to effectively interact with international stakeholders

Expected Deliverables

Depending on assignment scope, deliverables may include:

- Functional requirement analysis and supporting documentation
- Technical solution designs
- SQL / SSIS / Azure Data Factory development and maintenance
- Power Apps components or solutions
- Power BI data models/datasets development and enhancements
- Testing support and defect resolution
- Deployment support and knowledge transfer
- Project coordination and progress follow-up

📌 Business Solution manager/Business Analyst (Milano)
🏢 Dacomat
📍 Milano