Senior Microsoft BI & SQL Database Specialist

Decskill; Porto; Hybrid; EUR 50,000 - 70,000; Full time

Benefits offered by this job

Long-term projects with national &国际t‑

People-first culture focused on trust

Job summary

Decskill, part of the Astek Group, is expanding its Porto IT team. We are seeking a Database & Microsoft BI Specialist to design, optimize and monitor data systems in a dynamic enterprise environment.

You will work with SSIS/SSRS/SSAS, Power BI and SQL to deliver reliable ETL processes, performance tuning and data insights. Portuguese language skills are essential for collaboration with local teams.

Qualifications

• Solid experience with the Microsoft BI stack (SSIS/SSRS/SSAS), preferably with Tabular Models.
• Strong experience in developing, optimising and monitoring ETL processes, including SQL procedures and functions.
• Advanced Root Cause Analysis skills.
• Experience with SQL performance tuning, partitioning and indexing.
• Experience with C#, PowerShell and .NET.
• Experience with Power BI.
• Experience with Master Data Services.
• Strong knowledge of ITIL.
• Familiarity with DevOps practices and CI/CD pipelines.
• Experience with monitoring tools such as Dynatrace, ELK and Zabbix.

Responsibilities

• Design and implement database systems within the Information Systems environment.
• Monitor and support critical business processes.
• Develop and optimise SQL queries, stored procedures and database triggers for data manipulation and reporting.
• Work closely with Development teams to improve business process outcomes.
• Administer and maintain databases, ensuring operational performance and availability.
• Implement backup systems to ensure database data integrity.
• Ensure backups are performed according to the strategy defined by each business line.
• Provide technical support to developers and APS teams.
• Intervene in incidents affecting database performance or access to information.
• Actively participate in post-mortem analyses of major and/or recurring database incidents.
• Ensure technological monitoring to maintain performance and availability through visualization tools such as Dynatrace and Power BI.
• Assess and deploy innovative solutions to simplify, automate and optimise database costs.

Skills

Microsoft BI stack

SSIS/SSRS/SSAS

ETL development

SQL performance tuning

C#, PowerShell, .NET

Power BI

Master Data Services

ITIL

DevOps / CI/CD

Monitoring tools

Tools

SSIS

SSRS

SSAS

Master Data Services

Dynatrace

ELK

Zabbix

PowerShell

C#

CI/CD pipelines

Job description

Decskill, part of the Astek Group, is expanding its Porto IT team. We are seeking a Database & Microsoft BI Specialist to design, optimize and monitor data systems in a dynamic enterprise environment.

You will work with SSIS/SSRS/SSAS, Power BI and SQL to deliver reliable ETL processes, performance tuning and data insights. Portuguese language skills are essential for collaboration with local teams.