Job Description
Planning, migration, and integration of multiple on-prem data sources into a modern Azure data architecture. The focus of this initiative will be data migration and integration 10 datasets including new and historical data, time-series and trending data and some additional datasets into a data lake. As the lead Data Modeler, you will need to develop conceptual data models, detailed logical data models for client’s data objects, and collaborate with database developers and data engineers to implement the data models in the cloud data lake. Effective communication, and technical programming skillsets will be important to be a successful candidate
Key Responsibilities
Requirements Analysis: Work closely with stakeholders, such as business analysts and end-users, to understand the data requirements of a system or project.
Conceptual Modeling: Create a high-level, abstract representation of the data requirements, known as a conceptual data model. This model defines entities, their attributes, and the relationships between them.
Logical Modeling: Develop a detailed logical data model based on the conceptual model. This involves defining tables, columns, primary keys, foreign keys, and other database-specific details.
Normalization: Ensure that the data model is normalized, which means organizing data in a way that minimizes redundancy and dependency issues.
Data Integrity: Enforce data integrity constraints to maintain the accuracy and consistency of the data within the database.
Collaboration with Database Developers: Work closely with database developers and administrators to implement the data model in the cloud.
Documentation: Create and maintain documentation for the data model, including diagrams, data dictionaries, and any other relevant information.
Programming/Development: Utilizing your expertise in SQL/T-SQL, Python, C#, No-SQL, ADF, Event Hub, Databricks, Unity Catalog, Delta Lake, CosmoDB, Git, Azure DevOps, and modern architecture design principles.
Required Skills
Client facing / Business stakeholder management: Ability to lead client conversations, develop new opportunities and turn them into revenue generating initiatives.
Analytical skills: strong data analysis skills and know how to appropriately evaluate metrics for informed decision making
Communication abilities: communicate with a large number of stakeholders that span across the business and IT through both verbal and written communication
Problem-solving capabilities: creative thinker with excellent problem-solving abilities
Minimum of 7 years of hands-on experience in data modeling.
Proven capacity for managing several parallel initiatives while identifying and balancing priorities effectively.
Strong expertise in SQL/T-SQL, Python, C#, No-SQL, ADF, Event Hub, Databricks, Unity Catalog, eDelta Lake, CosmoDB, Git, and Azure DevOps.
Experience in Historical Data Migration, Bulk Data Migration, Technical Documentation, Creating ERD Diagrams, and Data Engineering via ADF Databricks.
Familiarity with PODS data models and/or ERwin data modeling tools is a bonus.
Azure Data Engineer Associate (Microsoft Certified), Certified Data Management Professional (CDMP) or Certified Data Modeler (CDM), or Azure Data Fundamentals certification preferred
Life at Capgemini
Capgemini supports all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer:
Collaborating with teams of creative, fun, and driven colleagues
Flexible work options enabling time and location-based flexibility
Company-provided home office equipment
Virtual collaboration and productivity tools to enable hybrid teams
Comprehensive benefits program (Health, Welfare, Retirement and Paid time off)
Other perks and wellness benefits like discount programs, and gym/studio access.
Paid Parental Leave and coaching, baby welcome gift, and family care/illness days
Back-up childcare/elder care, childcare discounts, and subsidized virtual tutoring
Tuition assistance and weekly hot skill development opportunities
Experiential, high-impact learning series events
Access to mental health resources and mindfulness programs
Access to join Capgemini Employee Resource Groups around communities of interest
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 360,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 reported in 2022 global revenues of €22 billion.
Get The Future You Want | www.capgemini.com (http://www.capgemini.com/#_blank)
Disclaimer
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, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.
Capgemini is committed to providing reasonable accommodations during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact.
Click the following link for more information on your rights as an Applicant http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law
Please be aware that Capgemini may capture your image (video or screenshot) during the interview process and that image may be used for verification, including during the hiring and onboarding process.
Applicants for employment in Canada must have valid work authorization that does not now and/or will not in the future require sponsorship of a visa for employment authorization in Canada by Capgemini.
Job: Developer
Organization: I&D
Title: Data Architect/Modeler
Location: CAN-ON-Toronto
Requisition ID: 074355