Database & BI Engineer

Consort Group

Porto

Hybrid

EUR 37.000 - 48.000

Vollzeit

Vor 2 Tagen
Sei unter den ersten Bewerbenden

Eine vollständige Bewerbung in einer Minute

Maßgeschneiderter Lebenslauf und Anschreiben – versandbereit.

Schaffe es an den ATS-Filtern vorbei

Benefits dieser Stelle

HR package
Training opportunities
Hybrid work model (50% onsite)

Zusammenfassung

Consort Group in Portugal is seeking a Database & BI Engineer to design, maintain and optimize database systems, ensuring data integrity, performance and availability across business-critical applications. You will work closely with Development, Operations and Security teams to manage ETL processes, improve performance, and support MS BI solutions including SSIS, SSRS, SSAS and Power BI.

The role offers a hybrid work model (50% onsite) in Porto or Lisbon, with a yearly salary of 37k to 48k EUR

Qualifikationen

  • Solid experience in database design, administration and performance optimisation.
  • Strong experience 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.

Aufgaben

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

Kenntnisse

SQL
Database design
Performance tuning
ETL development
C# / .NET
Power BI
Team collaboration

Tools

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

Jobbeschreibung

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.

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
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.
Hol dir deinen kostenlosen, vertraulichen Lebenslauf-Check.

oder ziehe deine Datei hierhin.

Similar jobs

Ähnliche Jobs, die dir auch gefallen könnten

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

Consort Group • Porto

Hybrid
EUR 37.000 - 48.000
Comprehensive HR package
Hybrid work - 50% onsite
Database & Infrastructure Engineer
Database & Infrastructure Engineer

Consort Group • Lisboa

Hybrid
EUR 50.000 - 70.000
Health insurance
TR card
CSE
+2
Database & Linux Infrastructure Engineer
Database & Linux Infrastructure Engineer

Consort Group • Lisboa

Hybrid
EUR 55.000 - 75.000
Data Engineer
Data Engineer

Consort Group • Porto

Hybrid
EUR 55.000 - 75.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 Engineer Consortis - Infra & Support · Lisbon · Hybride
Data Engineer Consortis - Infra & Support · Lisbon · Hybride

Consort Group • Lisboa

Hybrid
EUR 42.000 - 64.000
Health insurance
TR card
CSE
+1
Data Engineer
Data Engineer

Consort Group • Lisboa

Hybrid
EUR 55.000 - 75.000
Health insurance
TR card
CSE
+1
Data Analyst
Data Analyst

Consort Group • Lisboa

Hybrid
EUR 40.000 - 60.000
Inclusion and equality programs
Hands-on management style
Meaningful project commitments
Application Support Engineer – Cloud
Application Support Engineer – Cloud

Consort Group • Lisboa

Hybrid
EUR 45.000 - 65.000
Top-Standorte