Home
/
Comprehensive
/
Data Architect/Modeler (Edmonton/Calgary)
Data Architect/Modeler (Edmonton/Calgary)-November 2024
Toronto
Nov 12, 2024
ABOUT CAPGEMINI
We focus on helping drive value for our customers in three key areas: customer experience, intelligent industry, and enterprise management.
10,000+ employees
Consulting, Information Technology
VIEW COMPANY PROFILE >>
About Data Architect/Modeler (Edmonton/Calgary)

  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

Comments
Welcome to zdrecruit comments! Please keep conversations courteous and on-topic. To fosterproductive and respectful conversations, you may see comments from our Community Managers.
Sign up to post
Sort by
Show More Comments
SIMILAR JOBS
Customer Service Associate
Job Description: Models and delivers a distinctive and delightful customer experience. Registers sales on assigned cash register, provides customers with courteous, fair, friendly, and efficient chec
Senior Member of Technical Staff
Job Description Cloud Engineering Infrastructure Development - Virtual Machine Control Plane At Oracle Cloud Infrastructure (OCI), we build the future of the cloud for Enterprises as a diverse team o
Store Associate
Bring your heart to CVS Health. Every one of us at CVS Health shares a single, clear purpose: Bringing our heart to every moment of your health. This purpose guides our commitment to deliver enhanced
School Bus Driver
School Bus Driver Location352 Concord Rd Sudbury, Massachusetts 01776 USPhone NumberCategoriesDriversReq IDJR367 School Bus Driver (Open) First for a reasonFirst Student is the largest school transpo
Retail Cashier Part Time
Req ID: 431465 Address: 7791 NW 47th Ave Ocala, FL, 34482 Benefits: * Paid Time Off * Flexible Scheduling * 401(k) – 100% Match up to 5% * Medical/Dental/Vision Insurance after 30 days * Competitive
Special Education Teacher - Fortville, IN $45 Hourly
Special Education Teacher –Fortville, IN $45 Hourly Hours: 35 Location:Fortville, IN Start Date: asap $45 Hourly 23/24 school year, 6thgrade Requirements:IN SPED License The Special Education Teacher
TSSCI Cyber Network Defense Analyst
Job Description An employer is looking for a TSSCI Cyber Countermeasures Analyst to sit at Fort Meade. This person is going to be responsible for being the subject matter expert of a specific system
Merchandiser Stocker
Job Overview Merchandiser for Greater Moon Township, PA The Merchandiser is responsible for providing high-quality merchandising support for Keurig Dr Pepper brands like 7UP, Snapple, Core, Bai and o
Cleaner
Overview Position Summary Details The Cleaner position provides the cleaning and upkeep of an assigned area. Essential Functions Cleans and maintains buildings/facilities. Performs heavy cleaning dut
Security Officer
Allied Universal®, North America’s leading security and facility services company, provides rewarding careers that give you a sense of purpose. While working in a dynamic, diverse and inclusive workp
Copyright 2023-2024 - www.zdrecruit.com All Rights Reserved