Sogeti · 6 hours ago
Senior BI Engineer – Semantic Layer & Data Modeling
KC Metro Area
Full-time
Hybrid
Senior LevelSogeti, part of the Capgemini Group, is seeking a Senior BI Engineer with expertise in semantic layer data modeling and analytics engineering. The role involves designing and delivering analytical data products, managing semantic layers, and collaborating with stakeholders to optimize BI solutions.
ConsultingSoftwareInformation TechnologyProfessional Services
No H1B
Hiring Manager
Kimberley Rowe
Responsibilities
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
Qualification
Required
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
Benefits
Flexible work options
401(k) with 150% match up to 6%
Employee Share Ownership Plan
Medical, Prescription, Dental & Vision Insurance
Life Insurance
100% Company-Paid Mobile Phone Plan
3 Weeks PTO + 7 Paid Holidays
Paid Parental Leave
Adoption, Surrogacy & Cryopreservation Assistance
Subsidized Back-up Child/Elder Care & Tutoring
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
Company
Sogeti
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.
Founded in 2007
10001+ employees
Funding
Current Stage
Late StageLeadership Team
Steve Young
Chief Operating Officer - USA
Chris Wilkins, ITIL, SAFe Agilist, A-CSM
Client Partner
Company data provided by crunchbase