BI Developer

Caixa Mágica Software; Lisboa; On-site; EUR 45,000 - 65,000; Full time

Benefits offered by this job

Health and Life Insurance

Tech equipment + SIM card

Social events and training

Smartphone

Job summary

Caixa Mágica Software is seeking a Data & BI professional with strong SQL expertise to join our long-term project. You will work on complex SQL, performance tuning, data modelling, and DW environments.

You will design star-schema data models, implement Power BI reports with DAX and Tabular Models, and collaborate with Git, SSDT, and basic C# components to integrate business logic. This is a dynamic, growth-focused team.

Qualifications

• Strong SQL query language expertise.
• Understanding of SQL engine behavior and performance optimization.
• Ability to discuss and solve complex SQL topics.
• Data modelling with star schema design.
• Experience with data warehouse environments, preferably Dedicated SQL Pools.
• Experience with Git; Power BI, DAX, Tabular Models, SSDT.

Responsibilities

• Develop and optimize complex SQL queries for data warehousing.
• Design and implement star-schema data models for DW environments.
• Build Power BI reports using DAX and Tabular Models.
• Collaborate with Git, SSDT, and C# components for business logic integration.
• Provide performance tuning and query optimization recommendations.

Skills

SQL

Performance optimization

Data modelling

Star schema design

Power BI

DAX

Tabular Model

SSDT

Git

C# basics

Tools

SSDT

Job description

Overview:

We are looking for a Data & BI professional with strong SQL expertise and solid experience in data modeling and data warehouse environments. The role involves working with complex SQL, performance optimization, star schema design, Power BI, DAX and Tabular Models, with Git, SSDT and basic C# knowledge as additional key skills.

What are we looking for?

• Strong SQL query language expertise
• Understanding of SQL engine behavior and performance optimization
• Ability to discuss and solve complex SQL topics
• Data modelling with star schema design
• Understanding when more advanced modeling approaches are required
• Experience with data warehouse environments, preferably Dedicated SQL Pools
• Experience with Git
• Experience with Power BI,DAX,Tabular Model,SSDT (SQL Server Data Tools)
• Basic knowledge of C#, as some of our business logic is generated in C#

What can you expect from us?

• A permanent job contract for a long term project;
• Tech equipment + SIM Card + personal smartphone;
• Health and Life Insurance;
• Social events and team buildings;
• The commitment of letting you grow with us, and be rewarded accordingly;
• A dynamic and young team that will be always there to support you;
• Training in the latest technologies;
• Coffee, fruits, snacks and a warm welcoming when you pass by the office.