Analytics Engineer

Analytics Engineer Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired by a collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizations unlock the value of technology and build a more sustainable, more inclusive world. You’ll have the opportunity to collaborate with a leading European mobility services provider, headquartered in Germany and backed by nearly 90 years of expertise. As part of this journey, you’ll contribute to the launch of a new Tech Hub in Porto, helping to drive innovative, technology-led solutions that are transforming how businesses move while contributing to a more sustainable future. YOUR ROLE Design, build and maintain curated data products using SQL and dbt . Develop scalable data models applying dimensional modelling best practices. Define and maintain certified business metrics and semantic-layer logic. Ensure data quality through automated testing, monitoring and data contracts. Support the migration of finance reporting from SAP BW to the lakehouse. Collaborate with business stakeholders and cross-functional data teams to deliver trusted analytics solutions. YOUR PROFILE 2-3 years of experience in Analytics Engineering , Data Modelling or Data Products. Strong experience with SQL and dbt (or equivalent transformation frameworks). Knowledge of dimensional modelling, star schemas, slowly changing dimensions and semantic layers. Experience translating business processes and KPIs into reusable and governed data logic. Understanding of data quality, documentation, lineage and governance practices. Experience with Git , testing frameworks and CI/CD for analytics development. Experience with SAP BW structures and finance reporting logic (nice to have, not mandatory) . Experience with finance or commercial data (nice to have, not mandatory) . Knowledge of Databricks SQL and Unity Catalog , including metric views and governed data sharing (nice to have, not mandatory) . Ability to work closely with business stakeholders and reconcile reporting requirements. WHAT YOU'LL LOVE ABOUT WORKING HERE At Capgemini Portugal we have a flexible and dynamic work environment. Flexibility enables a better work-life balance and gives more flexibility to the employee to manage the working hours, as well if he works at the office or remotely, according with the company’s hybrid work policy; We have local programs that promote people growth, reskill and new skills development (Career Acceleration Programs); We promote an empowering environment with autonomy and peers' relationships among the top scores of our Monthly Employees' feedback; Next to this, we also offer an attractive compensation package and benefits such as Health and Life insurance, as well as Referral program with bonuses for talent recommendations and other fringe benefits according with our partnerships in for; Capgemini Portugal is an equal opportunity employer. We promote equality and dignity in all aspects of recruitment and employment, as well as employment offers and promotions made according with competence and ability or performance, respectively. ABOUT CAPGEMINI Capgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than 50 countries. With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fuelled by its market leading capabilities in AI, cloud and data, combined with its deep industry expertise and partner ecosystem. The Group reported 2023 global revenues of €22.5 billion Get the future you want | <www.capgemini.com>