Semantic Modeler

Team Function:

This position designs and develops a robust semantic layer and underlying data model to bridge the gap between
technical data and business language. The primary objective is to facilitate intuitive self-serve access to data in
simple business language for easy exploration and analysis by users across the organization. The role develops the
semantic layer by applying data virtualization principles on a cloud environment. The position collaborates with
business and technical partners to define and refine a comprehensive data model and ensure semantic consistency
across platforms. The role contributes to continuously improving data quality and accessibility standards. Performs
work within functional guidelines and works independently while receiving minimal guidance from a supervisor.

Role Description:

Collaborates with data architect to understand the overall data strategy and requirements for the semantic layer.
Designs and develops a comprehensive semantic data model that accurately reflects the business meaning of data
entities and their relationships. Participates in testing and validating the semantic data model to ensure it meets
performance and usability requirements. Defines data quality checks, transformations, and cleansing rules and works
with data engineers to implement them witihin the semantic layer. Documents the semantic data model including
detailed entity definitions, relationships, and data lineage information.
Engages business and technical partners to translate technical data terminology into clear and simple business
language. Consults with stakeholders to understand business needs, identify key concepts, and learn preferred
terminology. Uses in-depth knowledge of data modeling, database management systems, and semantic methodologies
combined with working knowledge of the business to create easy-to-understand business glossaries. Facilitates a
shared understanding of business data across the organization.
Analyzes data sources from multiple systems to understand their structure, content, and relationships. Collaborates
with data source owners to enable data access through the semantic layer. Uses semantic modeling best practices to
ensure semantic model is optimized for self-service data access and analysis.
Applies in-depth knowledge and practical expertise in data virtualization to access, integrate, and analyze diverse
datasets to create data and semantic models that equip business partners across the organization with valuable,
data-driven insights.
Works closely with internal IT and technical partners to define and implement security provisioning measures for
accessing and connecting to data sources, ensuring adherence to the established policies and procedures and
standards of the organization.
Stays updated on best practices, trends, and advancements in data modeling and semantic modeling methodologies.
Acts as a knowledgeable resource to lead, guide, and support the implementation of a robust semantic layer and
underlying data model. Performs other duties as assigned.

Work Experience in This Field

Minimum Required: 4-6

Preferred: 4-6

Required Education

Minimum Required: Bachelor

Additional Preferred :

Strong verbal communication and listening skills with ability to convey complex technical data to others in a simple and clear manner. Demonstrated written communication skills. Able to translate complex technical data into clear business language. Demonstrated analytical skills. Demonstrated problem solving skills. Effective interpersonal skills. Possesses strong technical aptitude. Strong understanding of data virtualization principles, concepts, and technologies and their performance characteristics. Strong understanding of cloud-based data management and analytics technologies and tools. Proficiency in SQL and relational databases. Demonstrates excellent judgment and decision making skills. Performs work independently with minimal supervision. Possesses a high degree of initiative. Seeks to acquire knowledge in area of specialty. Strong understanding of data quality, data governance, security, and data classification principles and practices.

Competitive compensation and benefits package:

1. Competitive salary and performance-based bonuses
2. Comprehensive benefits package
3. Career development and training opportunities
4. Flexible work arrangements (remote and/or office-based)
5. Dynamic and inclusive work culture within a globally renowned group
6. Private Health Insurance
7. Pension Plan
8. Paid Time Off
9. Training & Development

Note: Benefits differ based on employee level.

About Capgemini

Capgemini is a global leader in partnering with companies to transform and manage their business by harnessing the power of technology. The Group is guided everyday by its purpose of unleashing human energy through technology for an inclusive and sustainable future. It is a responsible and diverse organization of over 340,000 team members in more than 50 countries. With its strong 55-year heritage and deep industry expertise, Capgemini is trusted by its clients to address the entire breadth of their business needs, from strategy and design to operations, fueled by the fast evolving and innovative world of cloud, data, AI, connectivity, software, digital engineering and platforms. The Group €22.5 billion in revenues in 2023.

https://www.capgemini.com/us-en/about-us/who-we-are/