Data Programmer / Azure Data Factory

Description

Job Summary: We are seeking a Data Analyst/Programmer with experience in Azure environments to design, implement, monitor, and optimize data integration processes, and define ETL development methodologies. Key Highlights: 1. Design and maintenance of ETL/ELT pipelines in Azure Data Factory and SSIS. 2. Definition and implementation of development methodology and best practices. 3. Performance optimization and application of data governance. We seek a Data Analyst/Programmer with Azure environment experience, responsible for designing, implementing, monitoring, and optimizing data integration processes using Azure Data Factory and SSIS, as well as defining and consolidating a development methodology that establishes standards, best practices, and quality criteria for ETL processes. The role will coordinate with technical teams to ensure proper data integration, quality, and governance, guaranteeing the reliability of ETL processes and data platforms. **Key Responsibilities:** Design, develop, and maintain ETL/ELT pipelines in Azure Data Factory. Design, develop, maintain, and evolve ETL/ELT processes in SSIS. Define and implement a development methodology for SSIS and Azure Data Factory, including technical standards, best practices, naming conventions, version control, deployments, and documentation. Connect, transform, and orchestrate data from multiple sources (on-premises, cloud, APIs). Automate data flows and ensure their correct execution, monitoring, and incident management. Perform data quality analysis and validation at all stages of ETLs. Optimize pipeline performance and associated resources (storage, compute, etc.). Apply data governance, security, and regulatory compliance principles in data integration processes. Document developments and collaborate on continuous improvement of existing processes. **Technical Requirements:** Proven experience (2+ years) with Azure Data Factory and SSIS. Practical knowledge of related Azure services: Azure Synapse Analytics / SQL Data Warehouse, Azure Data Lake (Gen1/Gen2), Azure Storage Accounts, Azure Monitor / Log Analytics, Azure Purview. Solid SQL and T-SQL knowledge, including development and optimization of stored procedures in Microsoft SQL Server. Experience in ETL process optimization and performance analysis. Familiarity with Python for scripting and automation. Knowledge of data modeling, data warehousing, and relational and non-relational structures. Experience with version control tools (e.g., Git, Azure DevOps). Understanding of cloud architecture principles, scalability, and cost management. **Skills:** Analytical thinking and problem-solving orientation. Teamwork ability and effective communication with technical and business stakeholders. Organization and time management to handle multiple tasks simultaneously. Proactivity and focus on continuous process improvement. Employment Type: Full-time Salary: €45,000.00–€50,000.00 per year Work Location: On-site