What are the responsibilities and job description for the Data Modeller position at capgemini?
We are seeking an experienced Data Modeler with strong expertise in Erwin Data Modeler, dimensional modeling, SQL queries, Relational database concepts, Data warehouse best practices. The ideal candidate will play a key role in collaborating across teams for designing and optimizing data models to support enterprise analytics, data integration and reporting.
Key Responsibilities:
- Design, develop and maintain conceptual, logical and physical data models using Erwin.
- Ensure data integrity, consistency, and best practices in data modeling.
- Work closely with data engineers, business analysts and business teams to translate business requirements into scalable data models.
- Implement data modelling strategies for Microsoft Fabric, ensuring alignment with OneLake and medallion architecture principles.
- Collaborate with ETL developers and BI teams to ensure efficient data flow and model performance.
- Document data dictionaries, business glossary and modeling guidelines.
Required Skills & Qualification:
- 8 years of experience in data modelling for enterprise scale databases.
- Proficiency in Erwin Data Modeler Hands on experience.
- Data Modeling expertise Strong understanding of conceptual, logical, physical data model including normalization/denormalization techniques.
- Experience with Star and Snowflake schema for data warehousing.
- Strong SQL skills with experience in query optimization and data transformation.
- Microsoft Fabric Understanding Lakehouse, Data Warehouse OneLake integration.
- Expertise in Oracle, SQL Server and other relational databases.
- Strong understanding of data governance and master data management.
- Strong understanding with data warehousing best practices and dimensional modeling
- Ability to work in an Agile environment and collaborate across teams.
- Strong documentation skills
- Good communication skills.
The pay range that the employer in good faith reasonably expects to pay for this position is $41.61/hour - $65.01/hour. Our benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis.
Tundra Technical Solutions is among North America’s leading providers of Staffing and Consulting Services. Our success and our clients’ success are built on a foundation of service excellence. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers: we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.
Salary : $42 - $65
