Database and Business Intelligence Expert

hace 3 semanas


Madrid, Madrid, España Twtspain A tiempo completo
About the Job

We are seeking a highly skilled Database and Business Intelligence Expert to join our team at the European Commission IT in Bilbao. As a key member of our off-site team, you will be responsible for designing, implementing, and deploying complex data solutions using SQL Server.

The ideal candidate will have a strong background in database design and development, with a focus on data warehousing and business intelligence. You will work closely with our team to develop innovative solutions that meet the evolving needs of our organization.

Key Responsibilities:

  • Design and implement complex data models using SQL Server
  • Develop data warehousing solutions using Kimball or Inmon methodologies
  • Create ETL workflows using SSIS
  • Configure SSAS (multidimensional and tabular models) and create data cubes
  • Design and implement business intelligence dashboards using Tableau or Power BI

Requirements:

  • Language Level: Proficiency in English, minimum C1 level or higher
  • Education: Relevant education level for the role
  • Professional Experience:
    • Minimum 9-10 years in Software Development
    • Minimum 3 years in Database Design and Development with Data Vault Modelling
    • Minimum 12 years of experience writing Microsoft T-SQL code
    • Minimum 3 years with Flyway deployment
    • Minimum 12 years with SSAS (multidimensional + tabular) development
    • Desirable: Minimum 6 years with Microsoft SSIS
    • Desirable: Minimum 12 years in database dimensional modelling (Kimball and Inmon)
    • Desirable: Minimum 6 years with reporting tools like Tableau or Power BI
  • Professional Knowledge:
    • Excellent knowledge of writing complex SQL queries and stored procedures
    • Extensive experience with Microsoft SQL Server
    • Strong knowledge of Data Vault modelling
    • Expertise in SSIS and SSAS development and deployment
    • Thorough understanding of data warehousing and dimensional modelling
    • Desirable: Good knowledge of SSIS and SSAS server configuration and Power BI on-premises development
    • Desirable: Knowledge of CI/CD systems (e.g., TFS) and Agile methodologies

Salary: The salary for this position is approximately €80,000 per annum.



  • Madrid, Madrid, España Datais A tiempo completo

    As a Datais Business Intelligence Expert, you will play a vital role in unlocking business value by leveraging data and visualization skills to drive strategic decision-making. With a strong background in Business Intelligence (BI) tools and approaches, you will design, test, optimize, and deploy innovative solutions that provide real business benefits.We...


  • Madrid, Madrid, España Jordan martorell s.l. A tiempo completo

    We are seeking a highly skilled Business Intelligence Expert to join our team in Madrid, Spain. In this role, you will be responsible for developing and maintaining business intelligence solutions to support strategic decision-making.About the PositionYou will be working closely with cross-functional teams to gather requirements, design and implement...


  • Madrid, Madrid, España Prime Vigilance Ltd A tiempo completo

    At PrimeVigilance Ltd, we are seeking a highly skilled Regulatory Intelligence and Analytics Expert to complete regulatory deliverables based on an established regulatory plan.The successful candidate will be responsible for providing intelligence on requirements, contributing to the development of the strategy, and supporting the identification of issues...


  • Madrid, Madrid, España Join - Ats A tiempo completo

    About .DATAIS.DATAIS is a forward-thinking consultancy that leverages data and artificial intelligence to drive business growth. As a network of expert professionals, we collaborate with clients to provide tailored solutions, training, and consulting services. Our team has expanded its expertise beyond data analysis and visualization, now engaging with...


  • Madrid, Madrid, España Basf A tiempo completo

    **About Us**BASF Digital Hub Madrid is a leading innovation hub that develops cutting-edge digital solutions for the chemical industry. Our team is passionate about creating new and exciting customer experiences, driving business growth, and strengthening our position as a digital leader.**Your Role**We are seeking a skilled Senior Business Intelligence...


  • Madrid, Madrid, España Otto Group Solution Provider (OSP) GmbH A tiempo completo

    About the RoleWe are seeking a skilled Business Intelligence Developer to join our team at Otto Group Solution Provider (OSP) GmbH. As a Business Intelligence Developer, you will play a key role in designing and implementing our new, high-performance BI platform in the Google Cloud for big, fast & smart data.The ideal candidate will have excellent handling...


  • Madrid, Madrid, España Fusion Consulting Gmbh A tiempo completo

    At Fusion Consulting Gmbh, we're revolutionizing the Life Sciences industry with innovative solutions. As a leading Business and IT boutique consultancy, we partner with top companies in pharma, healthcare, and animal health to transform their business challenges into success stories.Estimated Salary: €60,000 - €80,000 per yearJob DescriptionWe're...


  • Madrid, Madrid, España Amadeus A tiempo completo

    About the Role:Amadeus is seeking a skilled Data Analyst to join our team. This role will play an essential part in transforming raw data into actionable insights that drive business decisions.Responsibilities:Gather and preprocess data from various sources, including databases, spreadsheets, and external systems.Clean and validate data to ensure accuracy...


  • Madrid, Madrid, España Six Group Services Ltd. A tiempo completo

    We are seeking a skilled Junior Business Intelligence Specialist to join our Data Managing Back Office team in Madrid. As a key member of the Business Intelligence team, you will play a crucial role in supporting national and foreign entities with their reporting to PTI (Post-Trade Interface) and operational control work with high relational content.Key...


  • Madrid, Madrid, España Amazon A tiempo completo

    Job DescriptionWe are seeking a highly experienced Relational Database Systems Expert to join our team at Amazon. As a key member of our Aurora PostgreSQL development team, you will be responsible for designing and developing innovative software solutions to enhance the performance, availability, and durability of Amazon Aurora.This is a unique opportunity...


  • Madrid, Madrid, España Tomtom A tiempo completo

    Company Overview: TomTom is a leading provider of navigation and mapping technologies, helping people find their way in the world.Salary: We offer a competitive compensation package, with a salary range of $120,000 - $180,000 per year, depending on experience.Job Description:We are seeking a skilled Senior Business Intelligence (BI) Developer to join our...


  • Madrid, Madrid, España Kavak A tiempo completo

    About KavakKavak is the leading e-commerce company in Latin America for buying and selling pre-owned vehicles. With a valuation of over $8.7 billion, we are the first unicorn company in Mexico's history.Job DescriptionWe are seeking an experienced Business Intelligence Data Analyst to join our team. In this role, you will play a key part in building and...


  • Madrid, Madrid, España Boston Scientific Gruppe A tiempo completo

    **Job Description:**At Boston Scientific Gruppe, we are seeking a highly skilled Senior Business Intelligence Developer to join our team in Madrid, Spain. This is a senior-level position that requires extensive experience in data analytics and business intelligence.**Responsibilities:Develop predictive analytics models to inform machine learning...


  • Madrid, Madrid, España Sgs A tiempo completo

    **Company Overview**Sgs is a leading testing, inspection, and certification company with a global presence.**Salary Range**: $100,000 - $150,000 per year, depending on experience.**Job Description**We are seeking an experienced Senior Business Intelligence (BI) Developer to join our team. As a BI Engineer, you will design, develop, and maintain data...


  • Madrid, Madrid, España 3M A tiempo completo

    Role OverviewWe are seeking a skilled Business Intelligence Analyst to join our Consumer Business Group. As a key member of our team, you will be responsible for driving business growth and mitigating declines through advanced analysis and insight generation.About the RoleIn this role, you will leverage retailers and distributors' point of sales (POS) data,...


  • Madrid, Madrid, España 3M Group A tiempo completo

    **About 3M Group**At 3M Group, we are committed to delivering innovative solutions that make a real difference in people's lives. With a diverse range of products and technologies, we offer exciting career opportunities for talented individuals who share our passion for excellence.**Salary:** $80,000 - $110,000 per year**Job Description:**We're Looking for a...


  • Madrid, Madrid, España Kruk España A tiempo completo

    MadridKruk España is seeking a Senior Business Intelligence Specialist to join our team. Job Description:We are looking for an experienced Data Analyst to prepare and interpret raw data using SQL. The ideal candidate will have 1-2 years of experience in a similar position, with expertise in Excel, Tableau, and statistical tools like R or...


  • Madrid, Madrid, España Tenth Revolution Group A tiempo completo

    We are seeking a highly experienced Cybersecurity Specialist with a strong focus on database security to join our international and decentralized team working on innovative solutions for global database management.This critical role is responsible for ensuring the security, protection, and seamless integration of relational and non-SQL databases in a cloud...


  • Madrid, Madrid, España Turner & Townsend Group A tiempo completo

    **Turner & Townsend Group Overview**We are a global leader in the built environment, delivering consultancy and project services. Our passion is to make a difference by delivering better outcomes for our clients.**About the Role**A competitive remuneration package of £70,000 - £90,000 per annum, depending on experience, reflects our commitment to...


  • Madrid, Madrid, España Brambles A tiempo completo

    Job DescriptionWe are seeking a highly skilled Business Intelligence Developer to join our Supply Chain Digitization team at Brambles.The ideal candidate will have a strong background in data visualization, ETL processes, and programming skills in SQL and Python. Experience with Power BI and Tableau is also essential.This role requires the ability to design,...