Resources
Post a Job
 Special offer 

Jumpstart your hiring with a $100 CAD credit to sponsor your first job.*

Sponsored jobs are 4.5X more likely to result in a hire.**
  • Invite matched candidates to apply
  • Increase your visibility in job search results
  • Appear to more candidates longer
*The $100 CAD Sponsored Job credit offer is only available for new accounts in Canada that post a job and expires one year after account creation. Upon expiration of the credit, users are charged based on Sponsored Job budget. Terms, conditions, and quality standards apply **Indeed data (worldwide)

How to Write a Data Architect Job Description: Top Duties and Requirements

A Data Architect, or a Database Architect, designs, develops, and administers data management solutions by using database management software. Their duties include developing and implementing data administration policies, backing up information, making sure that an effective recovery method is available, and writing computer code related to databases.

Build a Job Description
Are you a Job Seeker? Find Jobs

Data Architect duties and responsibilities

Data Architects often perform a wide range of tasks, including reviewing user feedback, participating in meetings with Software Engineers and Software Developers, and analyzing a variety of data storage statistics. They can build new data storage systems and policies or make updates to existing infrastructures. They recommend effective software that doesn’t take up lots of storage space as well. Duties and responsibilities in a Data Architect job description may include:

  • Ensuring the integrity of data backup and storage systems
  • Monitoring security software and tools
  • Managing the configuration of operating systems
  • Responding to security or usability concerns quickly
  • Anticipating possible problems and resolving them before they impact users when possible
  • Preparing reports for supervisors
Build a Job Description
Are you a Job Seeker? Find Jobs

Data Architect Job Description Examples:

Example 1

Primary Responsibilities

� Strong understanding or Snowflake on Azure �[website], design, implementation and operationalization of large-scale data and analytics solutions on Snowflake Cloud Data Warehouse.

� Hands-on development experience with Snowflake features such as Snow SQL; Snow Pipe; Python; Tasks; Streams; Time travel; Zero Copy Cloning; Optimizer; Metadata Manager; data sharing; and stored procedures.

� Experience in Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modeling.

� Need to have working knowledge of MS Azure configuration items with respect to Snowflake.

� Developing EL pipelines in and out of data warehouse using combination of Data bricks, Python and Snow SQL.

� Developing scripts UNIX, Python etc. to Extract, Load and Transform data, as well as other utility functions.

� Provide production support for Data Warehouse issues such data load problems, transformation translation problems

� Translate mapping specifications to data transformation design and development strategies and code, incorporating standards and best practices for optimal execution.

� Understanding data pipelines and modern ways of automating data pipeline using cloud based testing and clearly document implementations, so others can easily understand the requirements, implementation, and test conditions.

� Perform code reviews to ensure fit to requirements, optimal execution patterns and adherence to established standards.

Basic Qualifications

� Minimum 4 years of designing and implementing an operational production grade large-scale data solution on Microsoft Azure Snowflake Data Warehouse.

� Including hands on experience with productionized data ingestion and processing pipelines using Python, Data bricks, Snow SQL

� Excellent understanding of Snowflake Internals and integration of Snowflake with other data processing and reporting technologies

� Excellent presentation and communication skills, both written and verbal, ability to problem solve and design in an environment with unclear requirements.

Job Type: Full-time

Salary: $110,000.00-$130,000.00 per to Friday

Example 2

Amanst Inc. is looking for Senior Data Architect/Modellerfor a contract opportunity with Ontario Government.

Estimated Business Days: 55 days

Must Haves

  • 7 plus Extensive knowledge and experience in MS SQL Server Technology.
  • 3 plus years of Azure SQL Database or Synapse, Azure Data Lake

    Nice to have

  • Public Sector Experience

    Experience and Skill Set Requirements

    Design Documentation and Analysis Skills (45 points)

  • Demonstrated experience in creating both Functional Design Documents (FDD) & Detailed Design Documents (DDD). �
  • Experience in Fit-Gap analysis, system use case reviews, requirements reviews, coding exercises and reviews.
  • Experience in the development and maintaining a plan to address contract deliverables, through the identification of significant milestones and expected results with weekly status reporting.
  • Work with the Client & Developer(s) assigned to refine/confirm Business Requirements
  • Participate in defect fixing, testing support and development activities for Informatica/ETL tool. Assist with defect fixing and testing support for Cognos reports.
  • Analyze and document solution complexity and interdependencies

    BI Data Modelling and Technical Skills (45 points)

  • Understanding of Data Modelling for Business Intelligence including:

    a. Expert Knowledge of data warehouse design methodologies, data vault and dimensional modeling in particular

    b. Understanding of Extract/Transform/Load processes to transform data for reporting/BI purposes

    c. Ability to define schema for reporting databases

    d. Experience with advanced modeling tools,

  • Knowledge of BI tools for metadata modeling and report design

    a) Cognos 10/11

    b) PowerBI

  • Extensive knowledge and experience in MS SQL Server Technology, Azure SQL Database or Synapse, Azure Data Lake
  • Experience using Oracle database server and tools (12c, 19c), PL/SQL for development of Business Intelligence applications. Demonstrated skills in writing SQL stored procedures and packages for datamarts and reporting.
  • Demonstrated experience in performance tuning of Business Intelligence applications, including data model and schema optimization

    Job Type: Fixed term contract

    Schedule:
  • Monday to Location: Hybrid remote in Toronto, ON

    • Example 3

    Job title : Data Architect

    What you'll do...
  • Work closely with our Project Directors, Project Teams and our clients to meet systems and infrastructure needs.
  • Proven track of designing and delivering analytic data platforms.
  • Analyze and resolve problems.
  • Maintain the database systems - manage database access. performance tuning of database systems.
  • Data Architecture
  • Data modeling

    Preferred profile...
  • SQL Expert
  • 7+ years' experience with any major RDBMS - Microsoft SQL, Oracle, DB2
  • 7+ years' experience with any major ETL tool - SSIS, Informatica, Datastage
  • 3+ years' experience with any major BI or reporting tool - Cognos, Crystal Reports, Power BI
  • 7+ years' experience with any scripting language - Perl, Python, shell, PowerShell
  • Comprehensive grasp of data warehouse design best practices for data modeling and ETL system design
  • A year of experience on any cloud platform - Azure, AWS, GCP - nice to have
  • A year of experience with any Data Warehouse Appliance - Netezza, Synapse, Redshift, Teradata - nice to have
  • A year experience leading a small team of ETL developers or BI developers - nice to have
  • Strong communication
  • Self starter and self directed.

    What sets you apart...
  • You are professional and fun to work with
  • You write clean code
  • You are collaborative
  • You are able to adapt to diverse client environments
  • You are empathetic to customer needs
  • You have a track record of great teamwork
  • You are able to work well independently

    Job Type: Full-time

    Pay: Up to $140,000.00 per to Friday

    • Example 4

    Sr Data Architect | Remote | Contract Opportuntiy

    **Only candidates presently in Canada and eligible to work here need apply**

    Hiring a Sr Data Architect for a premium client of ours.

    Functional Accountabilities
    Responsibilities:
  • Elaborate solutions for the project needs based on the Enterprise Architecture targets
  • Produce Solution Design documentation
  • Collaborate and guide data modelers within the project
  • Estimate efforts needed on given requirements
  • Work in Agile with the Scrum master and various technical lead in the elaboration of the ETL pipelines
  • Assist to various CAB, workshops and meeting to represent the Data Architecture solutions and standards

    Required Skills
  • Solution Architecture Documentation (high and detailed level)
  • Visio or similar tools
  • Data modeling
  • SQL, Python knowledge
  • Cloud knowledge (Azure)
  • ETL process knowledge including Conventional tools
  • Data & Analytics Knowledge

    Job Type: Full-time

    Schedule:
  • Monday to Friday

    Experience:
  • Data Architect: 8 years (preferred)
  • Azure: 4 years 3 years (preferred)

    • Example 5

    Job Description � Data Architect Resources

    Evanya Consulting is hiring a Data Architect for our client Sask Energy.

    The successful candidate will work with a broad-based background of technical experience to be part of the DT&S team. The resource MUST have a minimum five (5) years of recent (last 5 years) and practical IT experience in modern data management principles such as, but not limited to practical data design, architecture, management, modelling, quality, and analytics experience.

    Responsibilities:
  • Work closely with the Analytics team to deliver strategies and roadmaps;
  • Developing reference architectures and models;
  • Consulting DT&S and Business leaders on data and information management practices and governance;
  • Recommending strategic direction for the improvement of the analytics environment;
  • Actively contributing to architecture boards and continued improvement of our practice;
  • Supporting business resources, Solution Architects, Business Analysts, Data Scientists, Data Engineers and Data Analysts on project initiatives;
  • Monitor and resolve database and data warehouse issues and problems and ensure they are in line with company policies and any external regulations that may apply;
  • Oversee integration and migration of data from legacy and on-premises systems to new solutions, including utilization of cloud technologies;
  • Championing efforts to improve business performance through enterprise information capabilities, such as master data management (MDM), metadata management, analytics, content management, data integration, and related data management or data infrastructure;
  • Provide insight into the changing database and data warehouse integration, storage and utilization requirements for the company and offer suggestions for solutions;
  • Monitor and understand Information Management trends and emerging technologies. 12. Educate staff members through training and individual support;

    Requirement:
  • A Degree or Diploma in Computer Science / Engineering, Data Sciences or a related discipline;
  • Five (5) + years� experience in a data design, data architecture, data management and data modelling;
  • Experience with developing reports and dashboards with PowerBI or another modern BI tool.
  • Proficiency with Microsoft SQL required;
  • Experience with cloud computing and cloud data warehousing & analytics tools.
  • Experience in developing and influencing Data Management programs;
  • Expert knowledge of each data management knowledge area as laid out by Data Management Association (DAMA) and the Data Management Body of Knowledge (DMBoK);
  • Certification in TOGAF; Certified Data Management Profession Certificate, Data Management Capability Assessment Model, or equivalent;
  • Extensive experience developing reference architectures and models;
  • Experience with modern Data Science and Artificial Intelligence platforms, techniques and tools.
  • Experience influencing and establishing strategic direction within an organization;
  • Experience working closely with business leaders, including presenting to senior management and the Executive;
  • Strong leadership and facilitation skills in communicating technical information effectively in an easy-to-understand language;
  • Knowledge and exposure to data privacy and confidentiality regulations such as Personal Information Protection and Electronic Documents Act (Pipeda);

    Job Type: Fixed term contract

    Schedule:
  • Monday to Friday

    Ability to commute/relocate:
  • Regina, SK: reliably commute or plan to relocate before starting work (required)

    Experience:
  • Modern Data Management Principles: 5 years Management Profession (preferred)

    • What does a Data Architect do?

    A Data Architect advises other professionals in the IT department about collecting and storing essential information, and company data security policies. They help decide which employees have access to essential files. They may also arrange for employees to access company data online when working from home. Data Architects also troubleshoot any problems with retrieving data, ensure that the company has enough storage available, and check the business’s computers to make sure that they’re working properly and prevent data loss.

    Data Architect skills and qualifications

    Successful Data Architects have a combination of technical and social skills. They can find errors in programming code, predict the behaviours of users, and collaborate with a variety of coworkers. Top skills and qualifications for Data Architects include:

    • Excellent written and verbal communication skills
    • Extensive understanding of database systems, hardware, and programming languages
    • Ability to work under pressure in a fast-paced environment
    • Outstanding attention to detail and the ability to discover small errors in complex code

    Data Architect experience requirements

    Most Data Architect jobs require some experience as a Computer Programmer, Data Analyst, Data Administrator, or another similar IT position, but they don’t necessarily need Data Architect experience. However, ideal candidates will have one to two years of experience working as a Data Architect. For more senior Data Architect roles, you may require candidates to have three to five years of experience.

    Data Architect education and training requirements

    Most Data Architect jobs require a university degree in computer science, mathematics, computer engineering, or a related field. On-the-job training is usually required as well, to become familiar with the specific database architecture and systems.

    Data Architect salary expectation

    According to Indeed Salaries, average pay for a Data Architect in Canada is 126,453 per year. Earnings can vary depending on experience, location, industry, and the hiring company.

    Job description samples for similar positions

    If a Data Architect job description sample isn’t exactly what your company is looking for, some other job descriptions that may fit your needs include:

    Ready to Hire?Build a Job Description

    Data Architect job description FAQs

    What is a typical day like for a Data Architect?

    Data Architects spend most of their time working on a computer. They read and create code, help users access data, and supervise employees converting paper files to digital files. They also interact with other IT professionals. They can focus on just one location or build networks that include multiple databases. Data Architects usually have regular hours, and they sometimes work for IT contractors. These professionals occasionally work overtime to complete large projects before deadlines. They wear casual or business casual clothing, and they can sometimes work remotely.

    Who does a Data Architect report to?

    Data Architects usually report to the head of the IT department or a senior Data Architect. In smaller organizations, they report to the Chief Technology Officer or the owner of the company. Data Architects often supervise Data Analysts, Data Managers, and people working in similar fields.

    How is a Data Architect different from a Data Engineer?

    Data Architects and Data Engineers complete many of the same tasks. A Data Architect creates digital frameworks and filing structures to make saving information easy. Then, a Data Engineer implements those plans by creating the code needed and making sure it’s compatible with the company’s hardware. Data Architects sometimes supervise Data Engineers.

    What makes a good Data Architect job description?

    An appealing Data Architect job description should describe the business’s history, values, and culture. It lets readers know the location where the new Data Architect will work and the education and skills required. Also, let potential candidates know which programming languages they will need to know, the type of database hardware and software your company uses, and the scope of the average project. Mention any benefits that come with the position, like the option to work from home, paid vacation time, a gym at the office, or free catering.

    Job Description Examples

    Need help writing a job description for a specific role? Use these job description examples to create your next great job posting. Or if you’re ready to hire, post your job on Indeed.

    No search results found

      *Indeed provides this information as a courtesy to users of this site. Please note that we are not your recruiting or legal advisor, we are not responsible for the content of your job descriptions, and none of the information provided herein guarantees performance.