Business Intelligence Specialist

TL;DR

Business Intelligence Specialist: Developing and optimizing BI projects with an accent on data warehousing, ETL processes, and reporting solutions. Focus on designing end-to-end BI architectures, performance tuning SQL code, and implementing Power BI models and dashboards.

Location: Hybrid, Lisbon, Portugal

Company

hirify.global is a specialized IT consulting partner with 18 years of experience, driven by a senior team that helps clients make the right decisions in a fast-moving market.

What you will do

• Design and implement Power BI models, dashboards, and Row-Level Security.
• Define and build end-to-end BI architectures.
• Develop and optimize T-SQL queries and ETL/ELT processes using SSIS.
• Implement relational and dimensional modeling (Star Schema / Snowflake).
• Perform performance tuning and monitoring of SQL code, indexes, and execution plans.
• Ensure security and access control for BI solutions.

Requirements

• Bachelors or Masters in Computer Science, Engineering, Applied Mathematics, Data Science or related fields.
• Minimum 5 years of experience in BI projects.
• Proficiency in Microsoft SQL Server 2016–2022 and advanced T-SQL.
• Expertise in SSIS, SSAS (Multidimensional and Tabular), DAX, and MDX.
• Experience with SSRS reporting and Power BI model/dashboard design.
• Strong background in performance tuning and security implementation for BI.

Culture & Benefits

• No-term full-time contract.
• Health Insurance.
• 22 days of paid vacation + 4 extra days annually (Carnival, Christmas Eve, New Year's Eve, Birthday).
• Meal Allowance on card (Coverflex).
• Training annual budget.
• Team-oriented culture with challenging projects.
• Chance to grow with a dynamically growing international company.