Home
/
Comprehensive
/
Data Architect/Modeler (Edmonton/Calgary)
Data Architect/Modeler (Edmonton/Calgary)-November 2024
Toronto
Nov 22, 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
Transaction Manager - Electric Vehicles (EV)
Transaction Manager - Electric Vehicles (EV) Job ID 150392 Posted 12-Jan-2024 Service line Advisory Segment Role type Full-time Areas of Interest Transaction Management Location(s) Denver - Colorado
Retail Print and Client Services Manager - Key Carrier
Overview At Office Depot, Inc., our Print & Client Services Manager reports directly to the General Manager and has ownership of the Print Services area. The Print & Client Services Manager i
Retail Key Holder-GRAPEVINE MILLS MALL
Retail Key Holder-GRAPEVINE MILLS MALL Brand: Bath & Body Works Location: Grapevine, TX, US Location Type: On-site Job ID: 04259 Job Area: Store: Sales and Support Associate Employment type: Part
Support and Services Specialist
Would you like the opportunity to work closely with high-performing teams in India ? Do you thrive in an environment which values autonomy, ownership and creativity ? Jabra India is currently on a lo
Sales Representative
Compensation Commission only. Average full-time Sales Representatives earn $80,000 - $100,000. Top Sales Representatives earn 250,000+ Benefits Flexible schedule Uncapped commission with massive earn
Certified Water/Wastewater Treatment Operator II
Certified Water/Wastewater Treatment Operator II Veolia North AmericaPalmetto, FL (Onsite)Full-Time Apply on company site Company Description About Veolia North America A subsidiary of Veolia Group,
Stamping Press Operator
Stamping Press Operator HIROTEC Manufacturing America, located in Fayetteville, Tennessee, is part of the HIROTEC Group, headquartered in Hiroshima, Japan. HIROTEC Group delivers body-in-white closur
Crew Member
CREW MEMBER Crew Members are responsible for delivering great guest experiences. Responsibilities Include: Team Environment - Communicate appropriately with fellow team members, treating others fairl
Value Based/Alternative Payment Models Program Specialist
Value Based/Alternative Payment Models Program Specialist As a Value Based/Alternative Payment Models Program Specialist, you will be responsible for partnering with team members and external stakeho
*Summer Opportunities - Recreation, Nithview Community
Summer Opportunities - Recreation Assistant Nithview Community, Tri-County Mennonite Homes New Hamburg, ON About Nithview Community: Nithview Community is a seniors' community designed to provide sev
Copyright 2023-2024 - www.zdrecruit.com All Rights Reserved