• Category
    Information Technology - Database Developer
  • Job type
  • Location
    Ottawa, Ontario

Adecco is currently recruiting for a Data Modeller - Intermediate for a 9.5-month contract with possibility of extension with our Crown Corporation Client located in Kanata, ON. The successful candidate must hold a valid Reliability Security Clearance or be eligible for one.

The Data Modeller - Intermediate will have the following responsibilities:

  • Work closely with project solution architects to design data services that are scalable, reliable and highly available to users.
  • Define and develop data standards, procedures, guidelines, policies and lifecycles that meet project’s strategic information requirements.
  • Develop Logical and Physical Data Models to ensure adherence to sound data management principles and where possible, the reuse of data
  • Perform project data modeling activities. Responsible for conceptual, logical, and physical schemas. Perform throughput and capacity analysis.
  • Consult, review, and approve project database changes. Advise developers with best practices and patterns.
  • Provide end-to-end vision and knowledge to the project  to help better design from a data perspective
  • Provide guidance and basic principles to projects to assist efficient management of data assets
  • Implement and oversee enterprise data governance and data management program
  • Establish and oversee basic data modeling principles
  • Develop project strategies for data acquisitions, archive recovery, and implementation of a database
  • Perform database tuning and optimization, provide suggestions on database performance improvement to the project
  • Translate technical concepts into costs and risks to the business and adjust technology strategy and tactical efforts to meet project objectives.
  • Provide expertise, guidance and consultation regarding the physical storage, movement and presentation of data for projects and the organization
  • Utilize industry & competitive knowledge to apply the most current and appropriate ideas in a forward-looking manner to support the business
  • Provide leadership and direction to a team of database developers to ensure technical requirements are met

The Data Modeller - Intermediate must meet the following mandatory requirements:

  • Minimum 5-8 years’ experience as a Data Architect.
  • Current knowledge of industry trends and technology advancements in data management.
  • Experience designing for large scale, highly available, fault tolerant data management systems in a dynamic environment.
  • Ability to create and maintain conceptual/business, logical and physical data models.
    Ability to translate a logical model into a physical model, adding appropriate physical objects needed to create the database e.g. indexes.
  • Experience maintaining a model repository.
  • Demonstrable analytical and problem solving skills, particularly as it relates to data modeling and data of the enterprise.
  • Ability to clearly articulate business and technical issues with senior management, peers, and outside parties (e.g. vendors, partners).
  • Knowledge of Cosmos DB, Big Data, Hadoop, hBase and other NoSQL data structures is plus.
  • Experience with web services and/or data design for cloud computing/multi-tenant/distributed systems is required
  • Proficient SQL skills. Understanding of a major DBMS e.g. Oracle, Postgres, MySQL, SQL Server, Redshift. Table types, index types, partitioning schemes, etc.
  • Solid understanding of ETL architectures, data movement technologies and business information systems.
  • Must have developed and enforced data standards in a previous experience.


  • Client Management : can consolidate business requirements and translate them into sound solution architecture
  • Data management: significant experience with the design, development and maintenance of enterprise level data systems such as Oracle, SQL Server or others; established and recognized area(s) of expertise in data standards and database products; strong data management skills including relationships and conversion requirements
  • Solution design: familiar with workflow concepts and how they integrate with application solutions in a cross application context
  • Application development concepts: is familiar with developing Service Oriented Architecture (SOA) based services within medium to highly complex application environments
  • Familiarity with both functional and performance aspects of integration
  • Domain knowledge: experience in relevant IT domain


  • Academic : undergraduate degree in engineering, computer science, or equivalent

Nice to Have:

  • ITIL foundations
  • IT Architecture Certification
  • SOA
  • Integration technologies (FUSE/DataStage/MQ)

If you are interested in applying to the Data Modeller - Intermediate position, please submit your resume as soon as possible by clicking on the 'Apply with Adecco’ button.


  • Apply with Adecco

Reference number CA_EN_1_027616_12037066

Accommodation will be provided in all parts of the hiring process as required under Adecco’s Employment Accommodation policy. Applicants will need to make their needs known in advance to their Adecco representative.