Capgemini

Analytics Engineer

Capgemini Vila Nova de Gaia, Portugal

IT Services and IT Consulting · 10,001+ employees

Yesterday
data-analyst Mid (2-5 yrs) Full-time Portugal
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

Design, build, and maintain curated data products using SQL and dbt while developing scalable data models. Collaborate with business stakeholders to deliver trusted analytics solutions and support the migration of finance reporting to the lakehouse.

What they look for

SQL Dbt Data modelling Dimensional modelling Star schemas Semantic layers Data quality Git CI/CD Databricks SQL Unity Catalog SAP BW Finance reporting Data governance Data lineage

Requirements

Requires 2-3 years of experience in Analytics Engineering or Data Modelling with strong proficiency in SQL and dbt. Candidates should have knowledge of dimensional modelling, data governance practices, and experience with CI/CD workflows.

Benefits

Health insurance Life insurance Referral program Career acceleration programs Flexible work environment

Full description

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

Similar roles