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