Data Engineer
ELCA · Palermo, Italy
At ELCA, we believe that high-quality data and strong data engineering capabilities are key drivers of successful digital transformation. We are looking for a Data Engineer to join our team in Italy and contribute to challenging data migration initiatives within a complex and international environment.
In this role, you will work on the execution and continuous improvement of large-scale data migration processes, with a strong focus on data quality, troubleshooting and transformation.
You will work closely with technical and functional teams, analyzing data migration results, identifying root causes of errors or inconsistencies, and implementing reliable solutions to ensure high-quality data throughout the migration lifecycle.
Your responsibilities
As a Data Engineer, you will:
- Execute iterative data migration cycles, analyzing errors, rejections and reconciliation gaps across different data layers.
- Identify the root causes of data issues and implement appropriate fixes in existing dbt and T-SQL transformation rules on Microsoft SQL Server.
- Implement and maintain automated data quality controls and reconciliation KPIs.
- Develop mapping and transformation rules based on functional specifications, translating business requirements into versioned and tested transformation models.
- Investigate and resolve data-related defects identified during testing and production support phases.
- Contribute to the continuous improvement and industrialization of data migration processes through Git-based workflows, code reviews, CI/CD pipelines and technical documentation.
- Collaborate closely with business analysts, developers, product teams and other stakeholders in an international environment.
Your profile
We are looking for someone who combines strong technical expertise with an analytical and structured approach to data.
You bring:
- Strong SQL expertise, including complex queries, set-based transformations and performance optimization.
- Good knowledge of Microsoft SQL Server and T-SQL.
- Hands-on experience in building and maintaining ELT/ETL data pipelines.
- Experience with dbt is highly appreciated. Experience with SSIS or comparable data integration technologies is also relevant.
- Solid understanding of data modelling, data quality and reconciliation principles.
- Experience with Git-based development workflows, code reviews and CI/CD practices.
- Familiarity with Agile working environments and tools such as JIRA and Confluence.
- A strong analytical mindset, autonomy and attention to detail.
- The ability to work confidently with complex and high-volume datasets.
- English level B2 or above, enabling you to work effectively in an international team.
Nice to have
The following would be considered an advantage:
- Knowledge of French.
- Experience with Python or PowerShell for automation and data analysis.
- Knowledge of Liquibase or other database change-management tools.
- Previous experience in data migration projects or other complex data-transformation environments.
What we offer
- Temporary employment contract (1 year).
- Gross annual salary (RAL) between €28,000 and €33,000, depending on experience and qualifications.
- An international and collaborative working environment.
- The opportunity to work on challenging data engineering and data migration initiatives.
- Hands-on experience with modern data technologies and engineering practices.
- Continuous learning and professional development.
- The opportunity to collaborate with multidisciplinary and international teams.
- A role with tangible impact on the quality, reliability, and continuous improvement of data-driven solutions.
If you are passionate about data, enjoy solving complex technical challenges, and want to contribute to innovative data engineering solutions in an international environment, we would love to hear from you.