Analytics Engineer: Build Scalable Data Products

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

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.