BI Consultant - Back-End & Semantic Modelling

About the role

IQVIA is looking for a Business Intelligence Consultant with a strong back-end focus to join its Portugal-based team, based in Lisbon. You will help build robust data solutions and AI-ready semantic models that make trusted business data easier to understand, govern and use across analytics and AI-enabled applications. You will collaborate with international colleagues and support projects for the Belgian healthcare and life sciences market.

Key responsibilities

• Translate business and data requirements into data integration, back-end and semantic modelling solutions.
• Design, develop and maintain ETL/ELT pipelines, data transformations and curated data layers.
• Build and evolve dimensional and semantic models, including relationships, hierarchies, measures and reusable business definitions.
• Help make data AI-ready through consistent terminology, metadata, governance and data lineage.
• Collaborate with business stakeholders, analysts, data engineers, data scientists and front-end developers.
• Support data quality, performance optimisation and continuous improvement.
• Contribute across the project lifecycle, from requirements and design through development, testing and deployment.

Required profile

• Bachelor's or Master's degree in Computer Science, Engineering, Data, Business Intelligence or a related field.
• Typically 3+ years of relevant experience in BI, data engineering, analytics engineering or a similar back-end role.
• Professional proficiency in English.
• Collaborative, customer-focused and solution-oriented mindset with a strong sense of ownership.

Required skills

• Strong SQL, ETL/ELT and data integration skills.
• Experience with Snowflake, Databricks, Informatica Cloud or SSIS.
• Understanding of data warehousing, dimensional modelling and Kimball principles.
• Experience with data and semantic modelling for BI and analytics.
• Familiarity with APIs and common data exchange formats.
• A plus: healthcare, pharma or life sciences experience; Power BI, Analysis Services, dbt, AtScale; metadata, lineage, governance or knowledge graphs; LLMs, RAG or vector search; Power BI, Qlik Sense or QlikView; cloud architectures, Agile, version control or CI/CD; Veeva or other life sciences platforms.

What we offer

• Work on data solutions in an industry that directly impacts patients and society.
• Growth across BI, data engineering, consulting and AI.
• International exposure while working from Portugal on projects for the Belgian market.
• A supportive, knowledgeable and collaborative team.
• A hybrid working model.