Senior BI Engineer – Semantic Layer & Data Modeling

We are seeking an experienced Senior BI Engineer with deep expertise in semantic layer data modeling and analytics engineering
. This role will be responsible for designing, governing, and delivering trusted analytical data products that power enterprise BI, self‑service analytics, and embedded use cases.

The ideal candidate has a strong command of both open‑source semantic layer technologies and enterprise BI semantic models, with a proven ability to translate complex business requirements into intuitive, governed analytical models consumed by a wide range of stakeholders.

• Design and maintain enterprise‑grade semantic layers, including fact/dimension models, relationship definitions, metrics, and calculated measures.
• Build and evolve analytical models that balance performance, usability, and governance across BI tools.
• Apply best practices in dimensional modeling, star/snowflake schemas, and metric standardization.
• Define and manage business‑friendly metrics and KPIs to ensure consistency across all consuming tools.

• Develop and manage open‑source semantic layers (e.g., Cube) for headless BI and API‑driven use cases.
• Design and support enterprise semantic models, including:
  Microsoft Fabric / Power BI Tabular Models (DAX) and LookML (Looker)
• Enable interoperability and reuse of semantic definitions across multiple BI and analytical platforms.

• Establish and enforce semantic layer governance, including metric definitions, naming conventions, versioning, and access controls.
• Partner with data governance teams to ensure alignment with enterprise standards and data policies.
• Own analytics as data products, ensuring clarity of purpose, documentation, quality checks, and reliable delivery to end consumers.
• Support auditability, lineage, and trust in analytical outputs.
• Collaborate closely with business stakeholders, data engineers, and platform teams to gather requirements and translate them into scalable analytical models.
• Drive solutions from raw data → curated models → semantic layer → BI consumption.
• Support downstream use cases including dashboards, self‑service exploration, and embedded analytics.
• Optimize semantic models for performance, cost efficiency, and scalability.

• Strong experience in BI and semantic layer modeling in enterprise environments.
• Deep understanding of data modeling for analytics, including relationships, hierarchies, measures, and aggregations.
• Hands on experience with:
  Open source semantic layer tools (e.g., Cube), Microsoft Fabric / Power BI Tabular Models, LookML
• Solid SQL expertise and familiarity with modern cloud data warehouses.
• Understanding of API driven analytics and headless BI patterns.

• Flexible work options
• 401(k) with 150% match up to 6%
• Employee Share Ownership Plan
• Life Insurance
• Adoption, Surrogacy & Cryopreservation Assistance
• Career Planning & Coaching
• $5,250 Tuition Reimbursement & 20,000+ Online Courses
• Employee Resource Groups
• Counseling & Support for Physical, Financial, Emotional & Spiritual Well-being
• Disaster Relief Programs

Part of the Capgemini Group, Sogeti makes business value through technology for organizations that need to implement innovation at speed and want a local partner with global scale. With a hands‑on culture and close proximity to its clients, Sogeti implements solutions that will help organizations work faster, better, and smarter. By combining its agility and speed of implementation through a Dev Ops approach, Sogeti delivers innovative solutions in quality engineering, cloud and application development, all driven by AI, data and automation.

Become Your Best | (Use the "Apply for this Job" box below)..us

Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.

This is a general description of the Duties,…