Skip to content
CV Rocket
Get started
How it worksThe enginePricingBlogContactSign in

Open nowFirst seen 3 days ago

RQ08912 - Data Architect/Modeller - Senior

Rubicon Path638 open roles

Where
Toronto, Ontario, Canada
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowRQ08912 - Data Architect/Modeller - SeniorRubicon Path · Toronto, Ontario, Canada

  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on Rubicon Path's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

12.1% of postings close within 7 days. Measured by our own scanner across the market.

Share of postings closed within
  1. 2.1%1 day
  2. 4.5%3 days
  3. 12.1%7 days
  4. 19.1%14 days
  5. 35.6%30 days
  6. 52.7%60 days
This job: first seen 3 days ago

The posting

Responsibilities:

  • Construct a high-level overview of the entire data landscape of the organization.
  • Illustrate how data moves through the organization and between systems.
  • Develop high-level designs outlining the main entities and their relationships.
  • Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects.
  • Implement designs showing how data will be stored, including tables, columns, indexes, and relationships.
  • Design diagrams showing how different data systems and databases interact and are integrated.
  • Document standards and policies for data management, including naming conventions, data quality standards, and data security policies.
  • Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity.
  • Compile detailed descriptions of data elements, their meanings, and their relationships.
  • Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization.
  • Document and design processes for extracting, transforming, and loading data from various sources.
  • Strategize and schedule the movement of data from legacy systems to new systems or platforms.
  • Detail the design of the data warehouse, including the schema, dimensions, and fact tables.
  • Set up and configure BI tools and dashboards.
  • Regularly report on the quality of data, identifying issues and areas for improvement.
  • Develop strategies and methods for cleaning and improving the quality of data.
  • Plan and diagram how data security will be implemented and maintained.
  • Document compliance with relevant regulations and standards.
  • Develop strategies for improving the efficiency and performance of data systems.
  • Detail plans for data architecture projects, including timelines, milestones, and resources required.
  • Document technical specifications for all data architecture components and processes.

SkillsExperience and Skill Set Requirements

Public Sector Experience

· 5+ years of experience working with federal/provincial/broader public-sector healthcare providers.

· Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices.

· In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies.

· Knowledge and experience with Public Sector Health related projects.

· Knowledge and understanding of Ministry policy and IT project approval processes and requirements.

· Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies.

· Experience with large complex IT Health-related projects.

5 points

Technical Skills and Experience

7+years experiences in the following:

· developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas.

· Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer).

· developing and implementing common data models and master data management strategies

· design schemas that balance agility, schema flexibility, data governance, and quality.

· Expertise in creating schemas that allow flexible querying and analysis across various data formats.

· defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns.

· implementing schemas and metadata structures that support efficient data management.

· Understanding of data governance principles and practices, especially in designing schemas and metadata structures.

· Experience in creating Architecture Artefacts based on enterprise standards.

· 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse.

· 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment.

· Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks.

50 points

Core Skill and Experience

· 10+ years experience with Solutions development.

· Experience in addressing complex data integration challenges and design efficient, scalable data models.

· Experience in monitoring and enforcing data modelling/normalization standards.

· Experience with the privacy and security requirements or software development in a health context, or equivalent.

· Demonstrated knowledge of leading technical design, security and recovery procedures for application development.

· Experience with relational and hierarchical database technologies.

· Demonstrated understanding and experience with the use of information retrieval packages using query languages.

· Experience in production environment troubleshooting and tuning to improve performance.

· Knowledge and experience of Information Management tools, principles, concepts, policies and practices.

30 points

General Skills

· Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols.

· Knowledge of performance considerations for different database designs in different environments.

· Experience in structured methodologies for the design, development and implementation of applications.

· Experience in systems analysis and design in large or medium systems environments.

· Awareness of emerging I&IT trends and directions

· Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders.

· Experience working with cross-functional teams, including IT, business, and data engineering teams.

· Strong analytical skills to understand and model complex data relationships and structures.

· Meticulous attention to detail in designing and implementing data models and schemas.

15 points

MUST HAVES:

7+years experiences in the following:

· developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas.

· Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer).

· developing and implementing common data models and master data management strategies

· design schemas that balance agility, schema flexibility, data governance, and quality.

· Expertise in creating schemas that allow flexible querying and analysis across various data formats.

· defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns.

· implementing schemas and metadata structures that support efficient data management.

· Understanding of data governance principles and practices, especially in designing schemas and metadata structures.

· Experience in creating Architecture Artefacts based on enterprise standards.

· 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse.

· 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment.

· Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks

· 10+ years experience with Solutions development.

· Experience in addressing complex data integration challenges and design efficient, scalable data models.

· Experience in monitoring and enforcing data modelling/normalization standards.

From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against Rubicon Path's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.

  3. We apply on Rubicon Path's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.

  4. Every reply, sorted

    Rubicon Path's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.

  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

Get the CV for this job
By hand5–10
With CV Rocket100
applications a day

Nearby

Live postings like this one

Same employer first, then the same role elsewhere.

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.