Th e co m pany : our customer is a multinational based in Madrid, that operates all over the world for more than 60 years and is one of the leading producers of food products.
More than 12,000 employees and around 2.000 M€ revenue.
They will hire the selected candidate as an internal and permanent employee.
Purpose of the function: Our customer is looking for a passionate, highly self-motivated and goal oriented, data-lover Business Intelligence Consultant who will be responsible for designing, testing, and implementing business intelligence solution plus fixing the existing ones.
Successful candidates must have and demonstrate a clear understanding of BI, Data Warehousing and related technologies and solutions.
If selected, you can expect a steady stream of challenging, exciting projects around Europe that will push your capabilities and creativity.
You will work with our team of professionals, with expectations of sharing ideas for solving business problems; partnering with team members from the BI practice and others to deliver excellence in our internal clients engagements.
Qualified candidates must be able to travel occasionally around Europe.
Key Responsibilities and tasks: Project Lead Work as the project lead to understand business processes and implement company-centric solutions including but not limited to: Updating our central data warehouse, using best practices to gather requirements, model data, and implement a system that is highly performant and near-real-time.
Extend existing Data Warehouse infrastructures with new dimensionality, functionalities, scenarios and new data sources using Oracle Data Integrator.
Develop interactive reporting solutions using MicroStrategy /Power BI.
Improve data governance and data quality using Master Data Management systems.
Adapt to change, and maximize value for our internal clients using agile techniques.
Relational Database Management Strong technical level in SQL.
Manage indexes and know about performance improvements at database level (mainly in Oracle 12c, but also in other cloud-based technologies).
Manage star schema developments, from the creation to the evolution.
Implement and consider referencial integrity.
Avoid data redundancy and manage integration rules.
Entity relationship modelling creation and maintenance.
Archiving procedures knowledge and automation.
ETL Management Design and develop the information interfaces though all source systems to the data warehouse using ODI 12.
Orchestrate and coordinate data flows between business scenarios to provide consistent information on-time.
Trace and investigate issues and data collisions.
Avoid redundancy between information flows.
Monitor processes executions, performance and data quality.
Reporting Management Design and develop information integration from the data warehouse models to the reporting layer.
Be comfortable working with multidimensional models, hierarchies and complex reports/dashboards definitions.
Define consistent metrics to cover business scope.
Prepare and design simple and usable reports and dashboards for the users.
Ensure the best practices of the area on any development. Working Experience and knowledge: Minimum 5 years' hands-on work in Business Intelligence.
Previous hands-on experience with Oracle 12c, ODI 12 and MicroStrategy 2020-onwards.
Experienced in cloud based solutions based on Azure (Azure Data lake, Azure Data Storage, Azure Data Factory).
Experience in data governance and information organization.
Valuable for the position but not mandatory: Experience with Master Data Management, design and implementation.
Experience in Agile development.
Knowledge on AWS or Google cloud.
Technical skills: Excellent analytic and deductive reasoning ability (i.e.
determine the structure, content, and quality of the data through examination of source systems and data samples).
In-depth knowledge of Oracle Database, Oracle Data Integrator and Microstrategy are a must.
Other knowledge and experience on ETL and reporting tools (like Power BI) is a plus.
Advanced knowledge of Data Warehousing and BI best practices.
Knowledge in statistics, R or python is a plus.
Soft skills: Must have high energy level, be self-motivated, with a results oriented.
Great communication skills and a strong desire to succeed.
Team player.
Personal Skills Requirements and Job Conditions Job location : Madrid, European nationality otherwise EU/Spain work permit required as a prerequisite.
Education and Training : Bachelor's degree in Computer Science, Mathematics or Physics, or with equivalent professional experience.
Languages: Fluent in English languages is essential and a professional Spanish level is important.
Organizational position : Reporting to Business Intelligence Director Employment Type : Permanent Full Time.
Salary : Depending on experience.
If you are interested, please apply here or send us an email to ****** including in the subject: 'Business Intelligence Consultant' along with your CV in English.
Powered by JazzHR