Senior Microsoft SQL & BI Developer (Hybrid Lisbon)

iTRTech Group; Lisboa; Hybrid; EUR 28,000 - 31,000; Full time

Job summary

iTRTech Group seeks a Senior Database Analyst/Developer (Microsoft) to design, develop, maintain, and optimize database systems and BI solutions in a hybrid Lisbon role.

The successful candidate will focus on data integrity, performance tuning, ETL processes, and Microsoft BI tools (SSIS/SSRS/SSAS, Power BI) to support critical business applications. English proficiency of B2 required.

Qualifications

• Solid experience with Microsoft SQL Server and database development.
• Strong knowledge of the Microsoft BI stack: SSIS, SSRS, and SSAS, preferably Tabular Models.
• Hands-on experience with ETL development, optimization, and monitoring.
• Strong SQL skills, including stored procedures, functions, and triggers.
• Experience with SQL performance tuning, partitioning, and indexing.
• Knowledge of database administration, maintenance, and backup strategies.
• Experience with C#, PowerShell, and .NET.
• Practical experience with Power BI.
• Strong troubleshooting and root cause analysis skills.
• English B2 or higher.

Responsibilities

• Design, implement, maintain, and optimize database systems.
• Develop and optimize SQL queries, stored procedures, functions, and database triggers.
• Monitor and support critical business processes, ensuring database performance and availability.
• Develop, optimize, and monitor ETL processes and Microsoft BI solutions.
• Implement and maintain database backup systems to ensure data integrity.
• Ensure database backups comply with business requirements and established backup strategies.
• Investigate database incidents, perform root cause analysis, and resolve performance issues.
• Collaborate with Development, Operations, and Security teams to improve database solutions and business processes.

Skills

SQL

ETL development

Performance tuning

Root cause analysis

Troubleshooting

English B2

Tools

MS SQL Server

SSIS

SSRS

SSAS

Tabular Models

C#

PowerShell

.NET

Power BI

Job description

iTRTech Group seeks a Senior Database Analyst/Developer (Microsoft) to design, develop, maintain, and optimize database systems and BI solutions in a hybrid Lisbon role.

The successful candidate will focus on data integrity, performance tuning, ETL processes, and Microsoft BI tools (SSIS/SSRS/SSAS, Power BI) to support critical business applications. English proficiency of B2 required.