Data Modelling Consultant at Accenture
Ottawa, ON, Canada -
Full Time


Start Date

Immediate

Expiry Date

05 Dec, 25

Salary

0.0

Posted On

05 Sep, 25

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

No

Skills

Good communication skills

Industry

Information Technology/IT

Description

WE ARE:

Accenture’s Data & AI practice, the people who love using data to tell a story. We’re also the world’s largest team of data scientists, data engineers, and experts in machine learning and AI. A great day for us? Solving big problems using the latest tech, serious brain power, and deep knowledge of just about every industry. We believe a mix of data, analytics, automation, and responsible AI can do almost anything—spark digital metamorphoses, widen the range of what humans can do, and breathe life into smart products and services. Want to join our crew of sharp analytical minds?

How To Apply:

Incase you would like to apply to this job directly from the source, please click here

Responsibilities

As a Data Modeler, you will be responsible for designing and managing data models to support operational systems on Azure, with a focus on operational data models and NoSQL databases. Your key responsibilities include:

  • Developing and Maintaining Data Models: Create and manage conceptual, logical, and physical data models tailored for operational systems and integration use cases Azure SQL for operational data and NoSQL databases for flexible, scalable data structures. Analytical and dimensional modeling experience is a nice-to-have but not required.
  • Collaborating with Stakeholders: Work closely with business teams, including stakeholders and analysts, as well as IT professionals, to gather and refine data requirements for the program.
  • Data Profiling and Analysis: Perform data profiling and analysis to establish, refine, and maintain robust data models that meet business needs.
  • Conceptual Modeling: Build conceptual data models to identify key business entities and visualize their relationships, ensuring alignment with operational goals.
  • Logical Modeling: Develop detailed logical models that define entities, attributes, relationships, and their characteristics, optimized for both relational (Azure SQL) and NoSQL environments.
  • Physical Modeling: Convert logical models into physical models for Azure Data Lake, Azure SQL, and NoSQL databases, generating DDLs or equivalent schema definitions for implementation teams.
  • Testing and Deployment: Test DDLs and schema implementations to ensure consistency and performance across all environments (development, testing, production).
  • Design Workshops: Participate in and facilitate design workshops to align business data needs with the data model, ensuring clarity and consensus.
  • Conflict Resolution: Mediate and resolve model conflicts arising from competing business requirements, ensuring a balanced and effective solution.
  • Collaboration and Signoff: Partner with global business units, architecture, and delivery teams to review, finalize, and adopt data models.

What you need:

  • Bachelor’s degree or completion of a college diploma in a related field
  • 5+ years of experience in designing Entity Relationship Models and operational data models, with specific expertise in data modeling for Azure Data Lake and Azure SQL, with hands-on experience in operational data structures.
  • 5+ years of experience using ERWin as a data modeling tool (preferred)
  • Proficiency in NoSQL databases (e.g., Azure Cosmos DB or similar).
  • Strong experience with Azure cloud services, particularly Azure Data Lake and Azure SQL, for building and deploying data models.
  • Eligibility for reliability security clearance
Loading...