Data Engineer
Evangelical Lutheran Church in America22 days ago
Palermo, ItalyMid Level
Responsibilities
- Execute iterative data migration cycles and analyze errors, rejections, and reconciliation gaps across data layers.
- Identify root causes of data issues and fix 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 from functional specifications using versioned and tested transformation models.
- Investigate and resolve data defects found during testing and production support.
- Improve and industrialize data migration processes through Git-based workflows, code reviews, CI/CD pipelines, and technical documentation.
- Collaborate with business analysts, developers, product teams, and other stakeholders in an international environment.
Requirements
- Strong SQL expertise, including complex queries, set-based transformations, and performance optimization.
- Good knowledge of Microsoft SQL Server and T-SQL.
- Hands-on experience building and maintaining ELT/ETL data pipelines.
- Experience with dbt is highly appreciated.
- Experience with SSIS or comparable data integration technologies is 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 environments and tools such as JIRA and Confluence.
- Ability to work autonomously and analytically with complex, high-volume datasets.
- English proficiency at B2 level or above.
- Knowledge of French is advantageous.
- Experience with Python or PowerShell for automation and data analysis is advantageous.
- Knowledge of Liquibase or other database change-management tools is advantageous.
- Previous data migration or complex data-transformation experience is advantageous.
Benefits
- Temporary employment contract for one year.
- Gross annual salary of €28,000–€33,000, depending on experience and qualifications.
- International and collaborative working environment.
- 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.
- Collaboration with multidisciplinary and international teams.
About Evangelical Lutheran Church in America
The Evangelical Lutheran Church in America is a U.S. Christian denomination that coordinates churchwide programs, theological resources, and ministries for congregations, synods, and partners. Founded in 1988 and headquartered in Chicago, it serves about 3.3 million members in more than 9,000 worshiping communities across all 50 states and the Caribbean, funded primarily by congregational benevolence, donations, and endowments, and operating initiatives in leadership development, education, disaster response, and global mission.