Database & Microsoft BI 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

We are growing. And we are looking for talented people!

At Decskill, we believe that technological excellence is driven by human talent.

We are an IT consulting company with more than 10 years of consolidated experience in the market, focused on building long-term relationships with both our clients and our people. Today, we are a community of over 800 professionals, working from Lisbon, Porto, and Madrid, contributing to impactful technology initiatives.

As part of the Astek Group, we combine a strong local culture with a global presence, being active in around 23 countries across 4 continents. This allows us to offer an international context, diverse challenges, and long-term career opportunities, while staying close to our teams.

We are looking for a Database & Microsoft BI Specialist!

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 Application Production Support (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 the required performance and availability through visualisation tools such as Dynatrace and Power BI.
• Assess and deploy innovative solutions to simplify, automate and optimise database costs.

Requirements:

• Solid experience with the Microsoft BI stack, including SSIS, SSRS and 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.

Technical Skills – Expected Levels:

• Microsoft BI (SSIS, SSRS, SSAS): Expert.
• ETL Development, Optimisation and Monitoring: Expert.
• SQL Performance Tuning, Partitioning and Indexing: Expert.
• C#, PowerShell and .NET: Expert.
• Power BI: Expert.
• Master Data Services: Expert.
• ITIL: Expert.
• DevOps / CI/CD: Practice.
• Monitoring Tools (Dynatrace, ELK, Zabbix): Expert.

Soft Skills:

• Excellent written and verbal communication skills.
• Strong teamwork and collaboration skills.
• Creativity and innovation.
• Ability to develop and adapt processes.
• Advanced problem-solving skills.
• Advanced analytical thinking.
• Strong attention to detail and accuracy.

Language Skills:

• Portuguese: Mastery.

Are you looking for an environment that values curiosity and commitment?

Here, your contribution has real impact and individual growth is taken seriously.

What you can expect from us?

• Long-term projects with national and international context.
• Opportunities to grow technically and professionally.
• A people-first culture, focused on transparency and trust.
• Teams that value ownership, collaboration and stability.

Find with us the right opportunity to grow!

Your next challenge might start here.

Decskill is committed to equality and non-discrimination with all our talents. We recruit and promote talent based on diversity and inclusion, regardless of age, gender, ethnicity, race, nationality or any other form of discrimination incompatible with the dignity of the human being.