PowerBI Developer

Your next opportunity starts here. At Aubay Portugal, we work daily with some of the largest organisations across sectors such as banking, insurance, telecommunications and energy, helping to build and evolve critical systems that support millions of users. We have been in Portugal since 2007 and are part of an international group with a presence in several European countries. More than technology, we build close relationships and deliver real-impact projects.What will you do?Design, build, and maintain enterprise-level Power BI dashboards, reports, and data models that meet business requirements;Write and optimize highly complex SQL queries (e.g., advanced SELECTs, subqueries, complex JOINs) to extract data from various source systems;Design and adapt SQL queries specifically tailored to retrieve historical datasets, utilizing dynamic date filters and time-series logic;Author, optimize, and maintain advanced DAX calculations, leveraging complex time intelligence and filter context manipulation;Troubleshoot and optimize Power BI reports, dashboard refresh times, and underlying SQL queries to guarantee an optimal end-user experience;Provide technical guidance, conduct code reviews, and promote best practices to junior and mid-level developers within the team (N4 Level).What are we looking for? At Aubay, our focus is on professionals who bring both technical expertise and the right mindset:A minimum of 8 years of professional experience in Business Intelligence, Data Engineering, or Data Analytics, with a strong focus on the Microsoft BI Stack;Advanced SQL mastery, including proven ability to write, debug, and fine-tune complex SQL queries utilizing subqueries, CTEs, JOINs, UNIONs, and aggregation functions;Demonstrated experience in adapting queries for historical data extraction using dynamic date parameters and injecting parameters directly into custom SQL queries;Deep expertise in creating both foundational and highly complex DAX formulas to support advanced business logic;Strong understanding of the Power BI Ecosystem, including Power BI Desktop, Power BI Service, gateway configurations, row-level security (RLS), and workspace administration;Proficiency in English is mandatory; French language skills are considered a strong asset;Alignment with our corporate culture and a commitment to integrity and ethics are highly valued;Strong customer focus, teamwork, task prioritisation, and daily commitment are highly appreciated.What can we offer? At Aubay, we invest in your development and well-being:Continuous growth through our Training Academy, with technical and soft skills training, mentoring, tech communities, workshops and in-person meetups;Close support with regular feedback and a structured career advancement model;Comprehensive health insurance, including dental coverage, as well as access to a mental health platform and well-being initiatives;Team-oriented environment, including events and initiatives to promote connection and team spirit;Personal and family life support, from the moment your children are born and throughout their educational path;Access to a language platform with conversational classes in multiple languages;Project-tailored work model: hybrid.What will you find here?A close-knit and informal environment, where direct communication is preferred and people are valued;Recognition of your contribution, with initiatives that celebrate meaningful moments;Freedom to be yourself, without unnecessary formalities;Teams where knowledge sharing, collaboration and joint growth are a reality.If you are looking for more than just a project and want to be part of a team where you can grow consistently, email your CV. The future awaits you, and so do we. Shall we talk?Personal Data collected by AUBAY PORTUGAL as Data Controller, regarding the identification, contact and professional capabilities of the candidates, in the present procedure, will be processed for the application analysis, having in consideration that the processing is conducted in order to take the steps, at the request of the data subject, prior to entering into a contract; Personal data sent through the present application will be kept by Aubay during the application procedure and will remain stored whilst updated (for two years period). The collected data might be transferred or include other processing activities, as long as the data subject is informed, in the occurrence of a standard application and selection procedure, for the compliance of legal obligations for the time required by law. For any queries or request regarding personal data protection rights, the Data Subject may contact AUBAY PORTUGAL's headquarters in Avenida Duque D'Ávila, nº46 em Lisboa or use the DPO's e-mail - dpo@aubay.pt. The Data Subject also has the right to file a complaint with the National Data Protection Authority – www.cnpd.pt. (please do not include data regarding racial or ethnical origins, political opinions, religion, philosophy, biometrical data, health data, sexual life and orientation, or relating to criminal convictions and offences.)