Business Intelligence specialist - 100% on- site

DO & CO; Madrid; Presencial; EUR 35.000 - 55.000; Jornada completa

Descripción de la vacante

A gourmet entertainment company in Madrid is seeking an IT Data Analyst to manage database design, performance tuning, and API architecture. The ideal candidate has strong expertise in Power Apps, data modeling, and SQL. This role requires onsite presence and excellent collaboration skills. A commitment to quality and adaptability in team settings is essential.

Formación

• The position requires a solid foundation in Power Apps and data modeling.
• Excellent problem-solving and communication skills are essential.
• Ability to work onsite and collaborate with various teams.

Responsabilidades

• Create data models and establish connections with data sources.
• Implement automation processes using Power Automate.
• Monitor database performance and provide ongoing tuning.

Conocimientos

Strong understanding of Power Apps components

Solid understanding of data modeling relational databases

Experience with Power Automate

Knowledge of SharePoint and Microsoft technologies

Excellent problem-solving skills

Strong communication and interpersonal skills

Herramientas

SQL

Power BI

Data Visualization tools

Descripción del empleo

Overview

DO & CO The Gourmet Entertainment company was founded and is currently listed in Austria. DO & CO is still family owned and run specialising in three primary business segments of Airline Catering International Event Catering and Hotel / Retail offering Gourmet Entertainment all over the world. We operate out of 32 locations in 11 countries on 3 continents maintaining the highest standard of quality in both our products and services. We refine the classics develop the unknown and grow constantly sometimes beyond our own expectations.

DO & CO represents the best flavours from the international spectrum and offers a culinary journey around the world. As a premium brand it is associated with good emotions culture and enjoyment providing high-class gourmet entertainment flawless service and an unrivalled all-round service package.

The most important ingredient however in our premium recipe is our diverse team of DO & CO family. Our people play a vital role and are the key to our success. They are brand ambassadors of the company and show passion for hospitality. It is thanks to our people that we are able to provide our customers with an impeccable standard of hospitality. Special commitment and passionate attention to our guests create an environment that feels like home wherever they are in the world defines our uniqueness and makes us leaders across our industry.

Job Summary

The purpose of the IT Data Analyst is to proactively engage with platform developers to support business initiatives for database design creation and maintenance. Has responsibility for database backups and recovery performance tuning capacity planning maintaining security standards and database upgrades. Develops implements and maintains an API / ETL architecture that is consistent with the enterprise strategy. Develops and implements an EAI approach that is compatible with guidelines and local application design goals.

What will you be doing

• Create data models and establish data connections with various data sources such as SharePoint SQL databases Excel and external APIs.
• Utilize Power Apps formulas expressions and workflows to create interactive and intuitive user interfaces.
• Implement business logic and automation using Power Automate (formerly Flow) to streamline processes and improve productivity.
• Determine space requirements for a database working with developers and system administrators
• Determine and implement the backup / recovery plan for each database both while in development and as the application moves into production
• Monitor database performance while the application is in development on an ongoing database-by-database basis to identify potential performance problems before getting to production
• Provide an ongoing tuning process for a database once an application goes into production
• Monitor table and tablespace growth and fragmentation on a periodic basis
• Stay abreast of the most current releases of database software and compatibility issues with the appropriate operating systems as well as intra-database software compatibility
• Create user and developer accounts and distribute appropriate privileges as needed to appropriate users
• Design implement and maintain an API / ETL architecture consistent with enterprise needs
• Plan coordinate and execute API / ETL upgrades as they become available
• Create connections from the API / ETL to source and target databases
• Import source and target metadata from databases creating objects for developer use
• Migrate mappings and workflows from development to quality assurance to production

Qualifications

Skills you must have :

• Strong understanding of Power Apps components including Canvas Apps and Model-Driven Apps.
• Solid understanding of data modeling relational databases and data integration concepts.
• Experience with Power Automate (formerly Flow) for creating workflows and automation processes.
• Familiarity with Power Apps is a plus.
• Knowledge of SharePoint Office 365 and other Microsoft technologies is desirable.
• Excellent problem-solving skills and attention to detail.
• Strong communication and interpersonal skills to collaborate effectively with cross-functional teams and stakeholders.
• Ability to influence different departments to suggest implement and track more efficient processes.
• Confident and flexible in the way you think making decisions efficiently and handling change to ensure everything we do is right for our partners and the DO & CO family.
• Keep in mind that this position is 100% on-site.
• Whilst we value experience most importantly to us is your personality adaptability charm & team player spirit.

Remote Work: Employment Type: Full-time

Key Skills

Business Intelligence, Cognos, SQL, Power BI, QlikView, Data Visualization, SSRS, Tableau, SSIS, Data Modeling, Data Warehouse, Data Analysis Skills

Experience : years

Vacancy : 1

Intelligence On Site