BI & SQL Data Architect — Power BI & Data Warehouse

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

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.