Analytics Engineer

Capgemini; Vila Nova de Gaia; Hybrid; EUR 45,000 - 65,000; Full time

Benefits offered by this job

Health and Life insurance

Referral program

Career Acceleration Programs

Job summary

Capgemini Portugal is launching a new Tech Hub in Porto. We’re seeking an Analytics Engineer to design, build and maintain data products using SQL and dbt, define metrics, ensure data quality, and support migration of finance reporting from SAP BW to the lakehouse.

You will collaborate with cross-functional data teams and business stakeholders, applying dimensional modelling and semantic layer practices to deliver trusted analytics solutions in a hybrid work setup.

Qualifications

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

Responsibilities

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

Skills

SQL

dbt

Dimensional modelling

Star schemas

Data governance

Data quality

Git

CI/CD for analytics

Testing frameworks

Databricks SQL

Unity Catalog

SAP BW knowledge

Tools

SAP BW

Git

Databricks

Unity Catalog

Job description

Analytics EngineerChoosing 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 ROLEDesign, 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 PROFILE2-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 HEREAt 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 CAPGEMINICapgemini 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 billionGet the future you want | www.capgemini.com