BI & SQL Data Architect — Power BI & Data Warehouse

Caixa Mágica Software; Lisboa; Presencial; EUR 45 000 - 65 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Health and Life Insurance

Tech equipment + SIM card

Social events and training

Smartphone

Resumo da oferta

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.

Qualificações

• 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.

Responsabilidades

• 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.

Conhecimentos

SQL

Performance optimization

Data modelling

Star schema design

Power BI

DAX

Tabular Model

SSDT

Git

C# basics

Ferramentas

SSDT

Descrição da oferta de emprego

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.