Database & BI Engineer Consortia - Testing, Développement, Data & IA · Porto, Lisbon · Hybride

Consort Group

Porto

Hybrid

EUR 37,000 - 48,000

Full time

21 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Comprehensive HR package
Hybrid work - 50% onsite

Job summary

Consort Group in Portugal is seeking a Database & BI Engineer to design, maintain and optimise database systems across business-critical applications. You will collaborate with Development, Operations and Security teams to ensure data integrity, performance and availability while contributing to ETL processes.

You will work on both the Build and Run sides, developing SQL queries, BI solutions and monitoring with tools such as Power BI, Dynatrace and ELK.

Qualifications

  • Solid experience designing, administering and tuning databases.
  • Strong Microsoft BI experience and Power BI expertise.
  • Experience developing, optimising and monitoring ETL processes.
  • Ability to troubleshoot complex database issues and perform root-cause analysis.
  • Experience supporting business-critical applications with Development and Operations teams.

Responsibilities

  • Design and implement database solutions within the Information Systems environment.
  • Develop, optimise and monitor ETL processes.
  • Work with Development teams to improve database performance and business outcomes.
  • Monitor and support critical business processes and database environments.
  • Administer and maintain databases to ensure operational availability and performance.
  • Provide technical support to Development and APS teams.

Skills

Database design
Database administration
Performance optimisation
ETL processes
Troubleshooting
Collaboration
Problem solving
Attention to detail

Tools

SSIS
SSRS
SSAS
Tabular Models
Power BI
Master Data Services
Dynatrace
ELK
Zabbix
C#
PowerShell
.NET

Job description

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer Consortia - Testing, Développement, Data & IA · Lisbon, Porto · Hybride
Data Engineer Consortia - Testing, Développement, Data & IA · Lisbon, Porto · Hybride

Consort Group • Lisboa, Porto

Hybrid
EUR 55,000 - 85,000
Health insurance
TR card
CSE
+2
Database & Linux Infrastructure Engineer
Database & Linux Infrastructure Engineer

Consort Group • Lisboa

Hybrid
EUR 55,000 - 75,000
Database & Infrastructure Engineer
Database & Infrastructure Engineer

Consort Group • Lisboa

Hybrid
EUR 50,000 - 70,000
Health insurance
TR card
CSE
+2
Senior Data Analyst Consortis - Infra & Support · Lisbon · Hybride
Senior Data Analyst Consortis - Infra & Support · Lisbon · Hybride

Consort Group • Lisboa

Hybrid
EUR 42,000 - 66,000
Health insurance
TR card
CSE
+1
Business Analyst
Business Analyst

Consort Group • Lisboa

Hybrid
EUR 38,000 - 54,000
Health insurance
Continuous training opportunities
Pension plan
+1
Developer Java Spring / SQL
Developer Java Spring / SQL

Consort Group • Porto

Hybrid
EUR 35,000 - 55,000
Health insurance
Continuous training opportunities
Pension plan
Data Analyst
Data Analyst

Consort Group • Lisboa

Hybrid
EUR 40,000 - 60,000
Inclusion and equality programs
Hands-on management style
Meaningful project commitments
Business Analyst Consortis - Infra & Support · Porto · Hybride
Business Analyst Consortis - Infra & Support · Porto · Hybride

Consort Group • Porto

Hybrid
EUR 32,000 - 46,000
Health insurance
TR card
CSE
Linux System Administrator Consortis - Infra & Support · Lisbon
Linux System Administrator Consortis - Infra & Support · Lisbon

Consort Group • Lisboa

Hybrid
EUR 45,000 - 60,000
HR package
Training programs
Inclusive culture
Senior Developer
Senior Developer

Consort Group • Lisboa

Hybrid
EUR 50,000 - 70,000
Inclusive workplace
Employee development programs
Dynamic project environment
Top locations