Business Intelligence Engineer

3 semanas atrás

Porto, Porto, Portugal Hexa Consulting Tempo inteiro

We are looking for a
Business Intelligence (BI) Engineer
to join our Client's team under a hybrid work model.

At Hexa Consulting, we are more than an IT consulting company — we are a place where technological talent grows. Based in Portugal, we value transparency and a people-first approach, helping professionals take the next big step in their IT careers. Our mission is to build strong relationships and support the development of every team member.

With projects in Nearshore, Time & Material, Service Management, and Tech Academies, you will find opportunities to learn, innovate, and grow in your career.

Key Responsibilities:

Data Modeling & Engineering

  • Design and maintain semantic models (star/snowflake schemas) optimized for analytics and reporting
  • Build and optimize ETL/ELT pipelines from multiple data sources
  • Ensure data quality, consistency, and performance across BI solutions

Analytics & Reporting

  • Develop and maintain dashboards and reports using BI tools (e.g. Power BI, Tableau, Looker)
  • Implement Row-Level Security (RLS) and governance standards
  • Translate business requirements into technical BI solutions
  • Performance & Optimization
  • Optimize SQL queries, data models, and report performance for large-scale datasets
  • Monitor and tune BI workloads in cloud and on-prem environments
  • Collaboration & Stakeholder Engagement
  • Work closely with business users to understand KPIs, metrics, and reporting needs
  • Partner with Data Engineers, Data Scientists, and Product teams
  • Provide guidance and best practices to analysts and report developers

Governance & Best Practices

  • Define and enforce data standards, naming conventions, and documentation
  • Support data lineage, metadata management, and auditability
  • Ensure compliance with security and privacy requirements

Required Qualifications:

  • Strong SQL skills (query optimization, indexing, complex joins)
  • Experience with data warehouses (Snowflake, Azure Synapse, BigQuery, Redshift, SQL Server)
  • Hands-on experience with Power BI (semantic models, DAX, DirectQuery, Premium)
  • Understanding of ETL/ELT tools (ADF, Airflow, dbt, SSIS, Fivetran, etc.)
  • Solid knowledge of data modeling techniques (Kimball, dimensional modeling)
  • Ability to translate business questions into data models and KPIs
  • Strong analytical and problem-solving skills
  • Excellent communication skills with technical and non-technical stakeholders
  • Ability to manage multiple priorities in a fast-paced environment
  • Strong documentation and knowledge-sharing mindset
  • English proficiency at minimum B2 level

Nice to Have:

  • Experience with cloud platforms (Azure, AWS, GCP)
  • Familiarity with Python for data processing or automation
  • Experience with DevOps / CI/CD for BI (Git, deployment pipelines)
  • Knowledge of data governance frameworks

Why Join Us?

  • Contract Type:
    Permanent / Employment contract or B2B, according to preference
  • Health Insurance:
    Comprehensive coverage for your well-being
  • Hybrid Model:
    2/3 days per week in the office (Porto)
  • Continuous Learning:
    Access to a Udemy Business subscription with thousands of courses and workshops
  • Team Culture:
    A collaborative, relaxed, and innovative environment

If you meet the above criteria and are ready for an exciting opportunity in a dynamic environment, send us your CV

  • Business Intelligence Engineer

    3 semanas atrás

    Porto, Porto, Portugal NTT DATA Europe & Latam Tempo inteiro

    Somos uma consultora multinacional de Negócios e Tecnologia que reinventa e transforma as organizações através da inovação e fomos considerados pela Gartner como uma das 10 maiores empresas de serviços de TI do mundo.Na NTTDATA somos Digital LoversAmamos a tecnologia, trabalhamos com paixão, com entusiasmo, num ambiente criativo e colaborativo e...

  • Business Intelligence Engineer – Porto

    3 semanas atrás

    Porto, Porto, Portugal NTT DATA EMEAL Tempo inteiro

    Somos uma consultora multinacional de Negócios e Tecnologia que reinventa e transforma as organizações através da inovação e fomos considerados pela Gartner como uma das 10 maiores empresas de serviços de TI do mundo.  Na NTTDATA somos Digital Lovers.Amamos a tecnologia, trabalhamos com paixão, com entusiasmo, num ambiente criativo e colaborativo e...

  • Business Intelligence Engineer

    3 semanas atrás

    Porto, Porto, Portugal Dellent Tempo inteiro

    Dellent is a consulting company focused in System Information and Telecommunications. Our goal is to help our candidates and consultants to take a step forward in their careers through projects that meet their needs and expectations.In this project you'll contact with the European stock market area. Despite its development center being located in Porto and...

  • Business Intelligence Consultant

    3 semanas atrás

    Porto, Porto, Portugal act digital Tempo inteiro

    About the company:act digital is a global digital transformation consulting group. We have more than 5.000 employees worldwide, with offices in Brazil, the United States, Canada, France, Portugal, Germany, Poland, Spain, Belgium, Luxembourg, Morocco and Serbia.We support the world's largest groups across the entire digital product development lifecycle: from...

  • Analyst - Business Intelligence

    1 dia atrás

    Porto, Porto, Portugal Metyis AG Tempo inteiro

    Metyis is growing We are looking for a Business Intelligence Analyst with 1–3 years of relevant industry or consulting experience to join our Data And Analytics team in Porto.Who we are Metyis is a global and forward-thinking firm operating across a wide range of industries, developing and delivering AI & Data, Digital Commerce, Marketing & Design...

  • Lead – Business Intelligence

    3 semanas atrás

    Porto, Porto, Portugal Consultancy Europe Tempo inteiro

    FirmMetyisLocationPortoEducationPostgraduate degreeBenefitsCompetiveFunctional areasBusiness IntelligenceApplyWho We AreThe next step of your career starts here, where you can bring your own unique mix of skills and perspectives to a fast-growing team.Metyis is a global and forward-thinking firm operating across a wide range of industries, developing and...

  • Lead – Business Intelligence

    3 semanas atrás

    Porto, Porto, Portugal Metyis AG Tempo inteiro

    Metyis is growing We are looking for a Business Intelligence Lead with 6 - 8 years of experience for a full-time position to join our Data and Analytics team based out of Porto.Who we areThe next step of your career starts here, where you can bring your own unique mix of skills and perspectives to a fast-growing team.Metyis is a global and forward-thinking...

  • Business Intelligence Senior Analyst

    3 semanas atrás

    Porto, Porto, Portugal Kantar Tempo inteiro

    We're the world's leading data, insights, and consulting company; we shape the brands of tomorrow by better understanding people everywhere.Our Functions teams are right at the centre of our business, making sure we can always get better, every day. Supporting the business with things like Marketing, Human Resources, Finance, Legal and Technology, our...

  • Fullstack Engineer – Medical Devices

    3 semanas atrás

    Porto, Porto, Portugal DIGESTAID - Digestive Artificial Intelligence Development Tempo inteiro

    Fullstack Engineer ) - Medical DevicesAtDIGESTAID, we don't just build dashboards; we build windows into the human body. Our team is using Artificial Intelligence to revolutionize digestive healthcare—enhancing diagnostics in tools like capsule endoscopy and colposcopy to save lives.We are looking for aSenior Fullstack Engineerwho is passionate about "AI...

  • Lead – Business Intelligence

    3 semanas atrás

    Porto, Porto, Portugal Metyis Tempo inteiro

    Who we areThe next step of your career starts here, where you can bring your own unique mix of skills and perspectives to a fast-growing team.Metyis is a global and forward-thinking firm operating across a wide range of industries, developing and delivering AI & Data, Digital Commerce, Marketing & Design solutions and Advisory services. At Metyis, our...