Share this Job


Date: Nov 25, 2021

Location: Copenhagen, Copenhagen, DK, 1411

Company: IFF Family of Companies

Job Description


The SAP HANA BI Lead will be responsible for implementing data warehousing and analytics solutions based on SAP BW, SAP BW/4HANA, SAP HANA, and appropriate Analytics tools. 


You will be responsible for performance improvements, replication of data from source systems and reporting on top of data warehousing using Business Objects, SAP Analytics Cloud, Tableau and Power BI as front-end tools.  Your role will manage escalation and resolution of complex issues, participate in the design and implementation of new technical solutions and tools, and lead internal and inter-team development projects and initiatives).  You should have a deep technical understanding of SAP BW on HANA including data modeling, optimization, data extraction, loading, transformation, and reporting.  


This role reports to Director, Integrated Analytics and is part of the Global Data Management organization. Global Data Management Organization strives to create a repeatable delivery process that creates rapid realization of business value through Data & Analytics-as-a-Service. This team is responsible for S3 Data Lake and Snowflake Data Warehouse and also for several SAP BW systems, with native Hana solutions as well, using a combination of Business Objects, SAP Analytics Cloud, Tableau and Power BI.

This role is mapped to our location in Copenhagen (DK). During spring 2022 IFF office will move location from Kbh. K to Lyngby. 

Key Responsibilities
•    Act as SME for SAP HANA and SAP centric reporting and HANA native applications, leveraging data from SAP BW, SAP BW/4HANA, SAP S/4HANA, SAP ECC, and other related applications. Provide architectural expertise and technical assistance to software developers.
•    Define best practices for leveraging SAP HANA for analytics applications. Develop proofs-of-concept and prototypes to help illustrate approaches to technology and business problems.
•    Translate business and functional specifications into detailed technical design documents, applying SAP BW on HANA best practices, to provide optimal reporting solutions for projects.
•    Build BI solutions using SAP BW on HANA objects. These include both persistence layer (DataSources, InfoSources, InfoObjects, aDSOs, Hierarchies, Open Hub Destinations) and virtual layer (Composite Providers, open ODS Views, external HANA views, attribute, analytical and calculation views).
•    Create data transformation, extraction, and load processes (ETL), including enablement of delta loads for both SAP-sourced and non-SAP data.
•    Create SAP reporting applications, dashboards using Business Objects, SAP Analytics Cloud or Power BI.
•    Lead the assessment of the capacity and resource utilization of application HANA appliances, application/integration/database servers, storage and security.
•    Drive test planning and execution break fix, enhancements and problem management delivery
•    Coordinate & collaborate across Finance, enterprise technology, internal audit, enterprise risk, and external audit, as appropriate

Job Requirements


•    7+ years of hands-on design and development experience including 3-5 years of SAP BW and HANA. At least 3 full life cycle implementations on SAP BW or BW/4HANA 
•    At least 3 plus years of experience with frontend reporting and dashboarding using Business Objects, SAP Analytics Cloud, Tableau or Power BI.
•    At least 3 plus years of experience in leading the implementation of SAP BI related projects
•    Strong integration knowledge among Sales and Distribution, Material Management (Supply Chain) and FICO modules.
•    Experience in development HANA models using HANA Studio and/or Eclipse 
•    Knowledge of SAP BW or HANA modelling and scripting or both including ability to write complex stored procedures. 
•    Experience in performance analysis and optimization, SQLScript, Stored procedures and security concepts.
•    Knowledge of various reporting techniques on top of data warehousing on SAP Analytics Cloud or Business Objects or Analysis for Office or in multiple tools
•    Experience in developing HANA XS applications is preferred
•    Knowledge in AWS cloud platform infrastructure and technologies is preferred
•    Good problem solving and troubleshooting skills
•    Ability to influence multiple stakeholders and handle conflicting priorities
•    Excellent communication skills, including both oral and written
•    Demonstrated excellence in project management and organization

Leadership Behaviors: 
•    DRIVE INNOVATION. Generate new or unique solutions and embrace new ideas that help sustain our business (encompassing everything from continuous improvement to new product and package innovation)
•    OWN. Deliver results, creating value for our Brands, our System, our customers, and key stakeholders
•    INSPIRE OTHERS. Inspire people to deliver our mission and 2025 Vision, demonstrate passion for the business and give customers a reason to believe our vision, too

Please submit your CV and application in English as soon as possible. We review applications on an ongoing basis. For more information about the role, you’re welcome to contact Director, Integrated Analytics, Reddy Ayyalapu at:



About IFF


It’s an exciting time to be part of the IFF IT family. We are a global leader in taste, scent and nutrition, offering our customers a broader range of natural solutions and accelerating our growth strategy.
At the heart of our success is investing in talent and valuing the diversity of our people. To drive breakthrough innovation and top performance, we aim to develop and engage employees through effective talent management, career development and workplace health and safety programs. By joining IFF, you could be part of a diverse team of highly passionate people who never stop imagining, always curious and committed to creating a better future for all.


At IFF, we believe that your uniqueness unleashes our potential. We value the diverse mosaic of the ethnicity, national origin, race, age, sex or veteran status. We strive for inclusive workplace that allows each of our colleagues to bring their authentic self to work regardless of their religion, gender identity & expression, sexual orientation, or disability. Visit to learn more.


We apply science and creativity for a better world.
With the beauty of art and the precision of science, we are an international collective of thinkers who partner with customers to bring scents, tastes, experiences, ingredients and solutions for products the world craves.
As a global leader in food, beverage, health, biosciences and sensorial experiences, we do a lot and continually innovate to do it better.
For more than 130 years we’ve been focused on finding the most innovative solutions to help bring “better for you” products to market. While we have grown over the years, we remain agile in our approach and put our customers’ needs at the forefront of our thinking.
We offer end-to-end service that few can deliver on. Our unparalleled product portfolio is the most robust in the industry and we have leadership positions across key taste, texture, scent, nutrition, enzymes, cultures, soy proteins and probiotics categories.