
Posted today
Database & BI Engineer
AI Summary
Designs, maintains and optimises database systems for business-critical applications, handling administration, backups, ETL processes, performance tuning and incident root-cause analysis alongside Development and Operations teams.
About this role
Every moment counts. Especially those you live to the fullest. Welcome to Consort Group.
For over 30 years, Consort Group has been helping companies leverage their data and infrastructure. It is backed by two leaders, Consortis and Consortia, and places people and social responsibility at the heart of its values.
This is your future team
Established in 2021, Consort Portugal supports the strategic offshoring choices of our clients, particularly in Europe, and brings our expertise in infrastructure services to the Portuguese market. With a team of around 45 employees, our Service Center based in Porto is developing a dynamic nearshore business, offering the French and European markets an environment of excellence and high potential.
Database & BI Engineer
This is your mission
You will be responsible for designing, maintaining and optimising database systems to ensure data integrity, performance and availability across business-critical applications.
Working closely with Development, Operations and Security teams, you will contribute to database administration, ETL processes, performance optimisation and technical support.
Build side
• Design and implement database solutions within the Information Systems environment.
• Develop and optimise SQL queries, stored procedures, functions and database triggers.
• Develop, optimise and monitor ETL processes.
• Work with Development teams to improve database performance and business process outcomes.
• Assess and implement solutions to automate database operations and optimise costs.
• Contribute to the continuous improvement of database and Microsoft BI solutions.
Run side
• Monitor and support critical business processes and database environments.
• Administer and maintain databases to ensure operational availability and performance.
• Implement and maintain backup systems in line with business requirements and defined strategies.
• Provide technical support to Development and APS teams.
• Investigate and resolve incidents affecting database performance or access to information.
• Perform root cause analysis and actively participate in post-mortems for major or recurring incidents.
• Monitor database performance and availability using tools such as Dynatrace, Power BI, ELK and Zabbix.
• Ensure data integrity, reliability and availability across database systems.
This is your background
• Solid experience in database design, administration and performance optimisation.
• Strong experience working with Microsoft Business Intelligence solutions.
• Experience developing, optimising and monitoring ETL processes.
• Proven ability to troubleshoot complex database issues and perform root cause analysis.
• Experience supporting business-critical applications in collaboration with Development and Operations teams.
This is your expertise
• Microsoft BI: SSIS, SSRS and SSAS, preferably with Tabular Models.
• SQL: Advanced SQL queries, stored procedures, functions, triggers and ETL development.
• Database Performance: Performance tuning, partitioning and indexing.
• Database Administration: Database maintenance, backup strategies, integrity and availability.
• Microsoft Technologies: C#, PowerShell and .NET.
• Power BI: Reporting and data visualisation.
• Master Data Services: Experience with Microsoft Master Data Services.
• Monitoring Tools: Dynatrace, ELK and Zabbix.
• IT Service Management: ITIL.
• DevOps: CI/CD practices.
Your language skills
• Portuguese: Mastery.
• English: Expert.
• Spanish: Basic knowledge.
This is your way of working
• Strong communication skills, both written and verbal.
• Collaborative mindset and ability to work effectively within a team.
• Creativity and interest in innovation.
• Ability to develop, adapt and improve processes.
• Strong problem-solving and analytical thinking skills.
• Attention to detail and a rigorous approach.
This is our commitment
At Consort Group, you are an expert we support so that every mission becomes a meaningful step in your career.
• Attentive and human onboarding
• Close management support
• Continuous access to training
• Concrete commitments to inclusion, equality and solidarity
• A comprehensive HR package
• A culture of feedback and meaningful projects
This is clear
The recruitment process:
• A first telephone exchange with our recruitment team
• An HR interview and a professional discussion with a business manager
• A technical test or exchange with one of our experts
• A final discussion with your future manager or mission manager
• And if we recognise ourselves in each other: we start together
Good to know
• Location: Lisbon or Porto
• Contract: B2B / Permanent
• Remote work: Hybrid - 50% onsite
• Salary: 37 k to 48 k yearly
• Job category: Database Administration / Microsoft BI / Data Engineering
What you will do here, you won't do anywhere else.
This moment is yours.
Skills
Explore related jobs
More jobs at Consort Group
Similar ETL jobs
- DIT-Systemadministrator für VirtualisierungDIS AG Germany · Mannheim, Germany
- EFachinformatiker für Systemintegrationexpo3 engineering GmbH · Ehingen, Germany
- BFOS-Praktikanten InformationstechnikBBZ Mitte GmbH · Petersberg, Germany
- Z
Zitac söker en driven IT-konsult med fokus på Hosting, Azure och BackupZitac · Västra Frölunda, Sweden - I
Storage EngineerIntegrated Resources INC · Detroit, MI - I
Backup/Storage Engineer IIIIntegrated Resources INC · Detroit, MI
Jobs in Porto
- C
Business AnalystConsort Group · Porto, Portugal - H
Sales Advisor | CC Norte Shopping - Porto | Part time 24h | Temporário (reforço de Natal)H&M Group · Matosinhos, Porto - H
Database Site Reliability EngineerHostelworld Group · Porto, Portugal - H
Sales Advisor | Alameda Shopping - Porto | Part time 24h | Temporário (reforço de Natal)H&M Group · Porto, Porto - M
Técnico de ManutençãoMAP Group · Porto, Portugal - H
Sales Advisor | CC Mar Shopping - Matosinhos | Part time 24h | Temporário (reforço de Natal)H&M Group · Matosinhos, Porto
Browse these categories
Market data for this role
All reports →- SeriesRole reportsOne role family at a time: how many openings, what changed this week, who is hiring, what it pays.
- SeriesSalary reportsWhat employers publish in job postings, by level and workplace. Not self-reported pay.
- Market overviewState of tech hiring, September 2026: up 4.8%Tech hiring rose 4.8% month over month in September 2026, with 411,122 new listings. Customer support and account executive roles led the growth.