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 teamEstablished 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 missionYou 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 commitmentAt 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 projectsThis is clearThe 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 togetherGood 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 EngineeringWhat you will do here, you won't do anywhere else.This moment is yours.