Data Office Engineer
About the Role:
We are looking for a Data Engineer / Data Warehouse Developer to support and enhance our corporate data platform.
The successful candidate will be responsible for developing and optimizing data integration and processing solutions, maintaining and enhancing the corporate Data Warehouse (DWH), building analytical models, and ensuring the reliability and availability of data for business intelligence and reporting.
Our current technology stack is primarily based on Microsoft SQL Server, SSIS, and SSAS Multidimensional, with opportunities to contribute to the future development of cloud-based data solutions using Microsoft Azure.
Main Responsibilities:
• Design, develop, implement, and maintain ETL/ELT processes and data pipelines to integrate data from various corporate systems.
• Develop and support data integrations across ERP, SFA, CRM, and other internal and external data sources.
• Develop, maintain, and optimize the corporate Data Warehouse (DWH), including data structures, data models, and analytical data marts.
• Develop and optimize SQL queries, stored procedures, views, functions, and other database objects.
• Develop, maintain, and optimize SQL Server Analysis Services (SSAS) analytical models, primarily Multidimensional Models (OLAP Cubes).
• Implement technical solutions to support new business reporting, KPI, and analytical requirements.
• Implement data quality controls, including data validation, reconciliation, consistency, and completeness checks.
• Monitor and optimize the performance of databases, data pipelines, ETL/ELT processes, and analytical models.
• Troubleshoot data processing and integration issues, perform root cause analysis, and implement preventive solutions.
• Contribute to the development of corporate data architecture and the adoption of new data technologies.
• Develop and maintain technical documentation and collaborate with Data Office, Reporting, and other business and technical teams.
About You:
• Bachelor's degree or higher in Information Technology, Computer Science, Applied Mathematics, Engineering, or a related technical field.
• At least 3 years of hands-on experience in Data Engineering, Data Warehouse Development, Business Intelligence Development, or a similar role.
• Strong proficiency in Microsoft SQL Server and T-SQL, including complex SQL development, stored procedures, and query performance optimization.
• Hands-on experience developing and maintaining ETL processes using SQL Server Integration Services (SSIS).
• Experience developing, maintaining, and optimizing SQL Server Analysis Services (SSAS) Multidimensional Models (OLAP Cubes).
• Knowledge of MDX and a solid understanding of multidimensional data modeling principles.
• Good understanding of Data Warehouse design principles, data modeling, and analytical data mart development.
• Solid knowledge of ETL/ELT concepts, data integration, error handling, and data quality management.
• Ability to troubleshoot and optimize SQL Server databases, ETL processes, and analytical models.
• Experience with Microsoft Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure SQL is nice to have
What We Offer:
Careers with caring built in - discover our benefits here.
About Ferrero:
Ferrero began its journey in the small town of Alba in Piedmont, Italy, in 1946. Today, it is one of the world’s largest sweet-packaged food companies, with many iconic brands sold in countries all over the world. Find out more about Ferrero at ferrero.com.
DE&I at Ferrero:
Ferrero is committed to building a diverse and inclusive culture in which all employees feel welcomed and appreciated and have the same opportunities. We believe all our people are equally talented in their own way. In nurturing the curiosity and natural abilities of our employees, we provide them, generation after generation, the means to succeed personally and professionally, enabling them to craft their journey at Ferrero. The diversity of our talents is what makes our work environment multicultural, innovative, and highly rewarding.
Find out more here.