Data Architect Job Description

Question

Data Architect Job Description

Job descriptions
Information Technology

Job summary 1

We are seeking a Data Architect with deep diverse technical experience who can navigate the challenge of pushing the organization to envision forward-thinking solutions that meet or exceed our key business performance measures. Our Data Architect works closely with technology and business leadership to envision and develop strategies that challenge current thinking, processes, and rules. You will enable strategic, big-picture design thinking for the business and how it operates, while collaborating with business and technical counterparts to drive the delivery of systems that align with key business performance indicators. You will provide a comprehensive, enterprise, and operational view ensuring output and artifact quality at all levels. You will be expected to work across the enterprise domains to drive architecture and design runways that result in implemented business solutions.

Duties & Responsibilities 1

special offer

Download all 10 Data Architect Job Descriptions

100Hires
eBook

Free Guide:

The Ultimate guide
to recruiting

Requirements & Skills 1

Job summary 2

The Data Architect provides data strategy and governance oversight for a focused portion of the information architecture and ensures projects and programs within the portfolio are supported by the appropriate data deliverables. Develops information architecture solutions that are aligned with the objectives and standards of the enterprise data management strategy and enable optimal performance, stability, and extensibility.

Duties & Responsibilities 2

Create the high-level architecture and data solution design for projects (conceptual model, integration model, sourcing) in alignment with the portfolio and enterprise data strategy. Translate enterprise or business needs into long-term information architecture solutions. Apply enterprise vision to all portfolio, technical, and application projects understanding and communicating different architectural models/strategies that are consistent with business strategies.
Analyze business processes, operational applications, and source data to understand dependencies, anomalies, and implicit business rules that impact the ability to manage the master data. Design, develop and maintain logical and physical data models. Perform data profiling and analysis and develop data models that correspond to business and technical requirements. Review and sign off on all project data models.
Provide governance oversight to ensure project adherence to information architecture strategy, principles, standards, policies, and procedures throughout all project phases. Partner with other architects to ensure alignment and integration across portfolio boundaries and promote an enterprise focus on data management. Review information architecture deliverables throughout the development process to ensure quality and traceability to requirements and adherence to all plans and standards.
- Develop and maintain the portfolio information architecture strategy including data models, and data strategy (e.g. management, integration, and optimization), and apply to ongoing projects and initiatives, acting as the subject matter expert in key data areas (e.g. data integration, data quality, master data governance, security). Develop and build strong relationships and use effective communication skills to influence and accomplish strategic information architecture objectives.
- Work with project managers and across the architecture organization to develop the approach and cost estimates to produce information architecture deliverables for projects. Assess and facilitate engagement of other data management services (DBA and data integration) for the projects within the portfolio. Provide high-level tracking of project progress, concerning data architecture deliverables, to ensure timely delivery and efficient use and staffing of data architecture resources.
- Contribute to the development and evolution of the Enterprise Reference Architecture and the Information Architecture. Communicate, educate, and ensure adherence to sound data management principles and where possible, the re-use of data as well as creating and managing meta-data and business rules for the use of data. Establish guiding principles and a reusable methodology for managing information architecture deliverables.

Requirements & Skills 2

Bachelor's degree or equivalent in Engineering, Computer Science, Mathematics, or related technical field; or related work experience.
5-7 years of relevant experience required
Deep logical and physical data modeling experience using the Entity Relationship Diagram (ERD) methodology.
Applied experience and expertise in data architecture concepts (e.g. model management, meta-data management, data governance).
Experience delivering concurrent, large information management projects at all phases-from project definition through design and delivery.
- Demonstrated proficiency in requirements gathering and analysis processes and methodologies.
- Experience developing a data strategy and working within and influencing the associated policies.
- 3+ years of software development and/or technical support experience.

Job summary 3

The Data Architect is responsible for analyzing and translating business, application, information, data, reporting, and analytical requirements into an architectural blueprint that outlines solutions to achieve business objectives.

Duties & Responsibilities 3

Requirements & Skills 3

Job summary 4

As our Data Architect you will play a lead role in delivering data and business intelligence strategies, solutions, and processes to support the digital transformation. The ideal candidate is passionate about delivering cutting-edge solutions to support the changing business needs and technology landscape. You will be working closely with our Digital Experiences, Customer Success, and Data & Analytics teams to define and deliver these solutions.

Duties & Responsibilities 4

Lead the development of our data strategy and capabilities roadmap
Lead analysis, architecture, design, and development of data and business intelligence solutions.
- Document existing business capabilities & dependent systems integrations then build a phased architectural plan for creating a connected digital infrastructure - including customer listening, health, triggers for automated digital motions, and reporting/business intelligence. Innovate new ways of leveraging our data to support our digital transformation
- Document business requirements and technical architecture and translate the requirements into technical designs for implementation, and manage key solution artifacts. Identify, analyze, and interpret trends and patterns using a variety of techniques to meet business needs. Evaluate organizational methods and provide source-to-target mappings of information and curate data assets relevant to business requirements. Evaluate internal systems for efficiency, problems, and inaccuracies, developing and maintaining protocols for handling, processing, and cleaning data
- Track and report development progress and performance regularly. Collaboration with geographically dispersed team.

Requirements & Skills 4

5+ years’ experience in data architecture, data warehousing, and data lake platforms
Technical expertise regarding data models, database design, data mining, and segmentation techniques.
Experience with the latest cloud technologies like a snowflake
- Experience in working with structured and unstructured data
- Proven abilities to take initiative and be innovative
- Bachelor’s in Computer Science, Engineering, or relevant field

Job summary 5

We are looking for a Data Architect to join our team in helping to support our modern data platform in Azure. This person will primarily be responsible for working with the Azure Data Architect in the design of the physical data warehouse architecture in Azure and the design of the BI semantic layer. They will also assist in creating and maintaining our analytic capabilities by finding ways to unlock value from our data to support our finance, marketing, and operation teams.

Duties & Responsibilities 5

Requirements & Skills 5

Job summary 6

We are looking for a Data Architect for the data team, working closely with all teams and cross-functional partners (including product, engineering, and data analysts) to build a foundational data stack powering business analytics. You will be responsible for creating a strategy for data ownership at our Company and help define the data architecture, data model, and pipelines to drive understanding of the Company’s business.

Duties & Responsibilities 6

Participate in creating and executing a roadmap for all things data infrastructure.
Build scalable systems that effectively store and crunch tons of data.
- Work with cross-functional partners (product, infra, security, analysts) to power data-driven products.
- Create fault-tolerant, timely, and optimized pipelines for data ingestion powering the company’s business analytics. Evangelize best practices with the engineering, infra, and analyst teams for building data models, pipelines, and materialized views. Standardize access to data across teams, and build tooling to reuse queries.
- Own data reliability and help assess and determine which warehousing technologies to use when to move data between data stores, and help production models.

Requirements & Skills 6

4+ years of managing data infrastructure / distributed systems
Strong knowledge of SQL and at least one programming language
Must be willing to both architect solutions & get deep into the weeds of delivering solutions
Experience with big data technologies such as Redshift, EMR + Spark, S3, Glue, Kinesis Firehose, Lambda, etc.
- Comfortable thinking about infrastructure as code
- Experience with Terraform or similar tools
- Nice to haves: NoSQL techs like DynamoDb, Kafka, and Kinesis Data Streams. Familiarity with BI tools Eg: Quicksight, Metabase, etc.

Job summary 7

As a Data Architect within the IT Department, you will lead a team of data engineers in providing consistent, reliable, and sustainable data solutions for use across all areas of the company. You will influence data management processes that result in highly accurate and trusted assets for use by stakeholders across the company to ensure investments are centered on optimizing clearly defined and quantified business outcomes.

Duties & Responsibilities 7

Lead the design, development, implementation, and maintenance of complex data systems and solutions
Establish standards, processes, and tools for data strategy, data life cycle, data ownership, data definition, and data classification to be used across the organization; Define the process to resolve cross-organizational data management issues
Develop conceptual and logical data models in a variety of storage types including by not limited to data lakes, data warehouses, and graph databases that support data analysis and business intelligence
Manage relationships with project teams using/ implementing data and meta-data management processes
Work with IT teams, business analysts, and data analytics teams to understand and develop solutions for data consumers’ needs
- Develop enterprise data management methodology and standards, and promote them to both technology and business users throughout the company
- Establish measures to chart progress related to completeness and quality of data and meta-data for enterprise information, to support the reduction of data redundancy and fragmentation, elimination of unnecessary movement of data, and improvement of data quality
- Participate in Data Governance Process to ensure standards are being followed by the team

Requirements & Skills 7

Bachelor’s Degree in a related field
- 7 or more years of experience architecting data-driven solutions
- Experience leading full lifecycle, large, complex reporting or data engineering efforts
- Skills in Data Governance, Master Data Management, Data Quality, and Data Lineage

Job summary 8

As a Data Architect, you will be responsible for owning the strategy, design, and implementation of data migration and integration plans across multiple projects. The candidate must have a thorough understanding of database systems and software and a strong understanding of data protection and data governance. In addition, the candidate must have an exceptional skill level of attention to detail, data analysis, and problem-solving. The person in this position will own the data migration and integration process throughout the entire project implementation lifecycle. They will also be responsible for ensuring the migration of data and/or data transformation meets the agreed-upon business requirements, ensures proper testing is implemented as well performance and security are closely monitored within the team. The candidate will also need to have experience in providing level-of-effort estimates for solutions around data migration and/or data transformation.

Duties & Responsibilities 8

Support Solutions Architect (SA) in client system tours, and discovery sessions and participate where appropriate to understand current business processes.
Own the data migration or integration plan and work with SA to secure client approval of the same. Plan data solutions to meet each requirement, finalize documentation, and secure approval from the client on each data deliverable.
- Audit existing data systems to strategize and plan the migration, including assessing any risks, potential impacts, and areas of improvement.
- Collaborate with SA to ensure system architecture meets the needs of the incoming data structure and details. Own building the plan for data migration utilizing knowledge of the client’s business requirements and planned system architecture.
- Act as the data expert point of contact with the client and ensure the vision for data migration is properly relayed to the client. Work with the Project Manager (PM) and the SA to design the discovery and implementation plans. Collaborate with the PM and SA to create estimates. Reprioritize tasks and rebuild the project plan as the project evolves.

Requirements & Skills 8

You have worked on a wide variety of projects: You have collaborated with technical and non-technical team members to complete a range of project types from small projects with a straightforward objective, to large projects with many business requirements. You have completed end-to-end data migrations inside of implementations that include high-level data mapping, detailed data analysis and mapping, data integrations, migration scripting, troubleshooting, data clean-up, and performing the migration. You can identify gaps between current and future states and deliver properly positioned data solutions.
You have a broad set of tools: You feel comfortable determining the appropriate path for data migrations and integrations, have a strong understanding of the technical applications available inside and outside of the Salesforce ecosystem, and you know how to apply your knowledge and advocate for the appropriate approach on the data migration and/or integration. Ideally, you have experience in or knowledge of development technologies, web-based technologies, and integration technologies.
You know database migration: You have working experience with relevant migration tools such as ETL, SQL, and data loaders.
You know relational databases: You're familiar with the data structure (especially non-profits) that underpins a relational database, and if you don't already know Salesforce, you're excited to learn.
- You are a strong communicator: You can distill complex technical ideas for a diverse set of stakeholders from developers, project managers, executives, and clients of all technical levels of sophistication.
- You are adaptable: The idea of working on several diverse types of projects of different sizes within different organizations excites you.
- You are a critical thinker: You don’t need to be told how to get from point A to point B. You are up for the challenge of figuring out how the pieces of a given project fit together.

Job summary 9

The Data Architect is responsible to define standards and design the flow of data throughout both the enterprise and the integration to external ecosystems (customers, channels, etc.). In this role, you are required to lead the development and maintenance of data architecture and work with a team of data architects to improve the maturity of curated data, data pipelines, data quality, and data governance to support data democratization. A Data Architect is a knowledgeable leader with the ability to lead and is passionate about coaching and using data to solve business problems. The right individual will have a vision for the overall data landscape with the ability to develop technically viable global data architecture with a focus on international data.

Duties & Responsibilities 9

Drives the international data architecture strategy in collaboration with enterprise architecture.
Builds optimizes, and maintains logical (curated) data models.
Advises team on translating business needs into long-term architecture solutions.
Develops and maintains reference architectures for data services.
Works with data engineering and data platform teams to conduct ongoing performance enhancement by troubleshooting and introducing new technologies.
Assists in defining data integration, storage, replication, and transformation protocols for the data layer of technical solutions supported by enterprise architecture.
- Participates in the delivery of operational business performance monitoring capabilities.
- Brainstorm ideas with database developers, data engineers, and data scientists to generate new data products.
- Mentors and coaches the data architecture team on new technologies and methodologies in data architecture and engineering.

Requirements & Skills 9

7+ years’ experience in data architecture with large and complex datasets.
3+ years’ experience working with Cloud technologies such as ADLS, Azure Databricks, Spark, Azure Synapse, Cosmos DB, and other big data technologies.
- Experience in developing a big-picture view of the data needs of business and building the architecture based on a strong technical foundation.
- Strong understanding of database storage concepts (data lake, relational databases, NoSQL, Graph, data warehousing).
- Graduate degree in Computer Science, Engineering, or equivalent software/services experience.

Job summary 10

We are seeking a Data Architect to join our team.

Duties & Responsibilities 10

Design/redesign the architecture of enterprise data warehouses (EDWs).
Manage resources and timelines for the development of the EDWs process.
Design and implement detailed EDW model and data mappings.
- Troubleshoot issues throughout the EDW development lifecycle.
- Optimize EDW implementations.
- Directly supervise and provide technical guidance to EDW developers/engineers.

Requirements & Skills 10

5+ years of professional experience in a data architecture role managing EDW projects, including supervision of developers/engineers.
Significant experience with Informatica.
Working knowledge of modeling tools (such as Erwin or Rational Rose).
Expert knowledge of SQL and related SQL procedure languages.
- Hands-on experience with BI tools.
- Excellent oral and written communication skills.
- Bachelor’s degree in Computer Science, Information Science, or related field, or 3 additional years of relevant professional experience.

Frequently asked questions

What is the role of a data architect?

A Data Architect is an IT professional responsible for creating and managing a company's data architecture - the rules, policies, standards, and models that govern and define the type of data collected and how it is used, stored, managed, and integrated within the organization.

Here are some of the main responsibilities of a Data Architect:

Design Data Models and Database Systems: They design and create data models that define the structure, relationships, and constraints of the data. They are also responsible for choosing suitable database systems and ensuring they are properly integrated into the company's IT infrastructure.

Develop Data Strategies and Policies: They work with the company's leadership and stakeholders to understand the company's objectives and develop data strategies that support these goals. This includes developing policies for data standardization, quality, privacy, and security.

Data Management and Governance: They oversee the proper management and governance of the organization's data to ensure its accuracy, quality, and security. This involves defining roles, responsibilities, and processes for data management and establishing data governance frameworks.

Evaluate and Incorporate New Technologies: They continuously evaluate new data technologies and trends, determining how they could improve the organization's data architecture and integration.

Coordinate with Other IT Professionals: Data Architects work closely with other IT professionals, such as Data Analysts, Data Engineers, and Business Intelligence Analysts. They ensure that the data architecture supports their needs and facilitates data-related tasks.

Troubleshooting and Problem Solving: They identify and solve data-related problems, troubleshooting issues with the database systems, and making adjustments to improve performance.

Ensure Compliance: In industries with strict data regulations, Data Architects ensure the company's data management practices comply with relevant laws and standards.

Overall, a Data Architect plays a critical role in managing a company's data infrastructure. They ensure that data is structured, stored, and used effectively to support the organization's objectives. They require a strong understanding of data principles and technologies, as well as the ability to translate business needs into data solutions.

Who does a data architect work with?

A Data Architect typically works with a wide range of professionals within an organization, collaborating across various teams and departments to ensure effective data management and use. Here are some key roles they interact with:

Data Engineers: Data engineers are responsible for building and maintaining the technical infrastructure (data pipelines, databases, etc.) that allows data to be collected, stored, and processed. Data Architects often collaborate closely with Data Engineers to design these systems and troubleshoot any issues.

Data Analysts and Data Scientists: Data Analysts and Data Scientists use the data to generate insights and build predictive models. The Data Architect must ensure the data architecture supports their needs, providing them with accurate, high-quality data in a format they can use.

Business Intelligence Analysts: These professionals also rely on the data infrastructure to develop reports, dashboards, and visualizations that inform business decision-making. The Data Architect works with them to understand their data needs and ensure they have access to the right data.

IT Team: They work closely with other IT professionals, such as system administrators, developers, and IT managers, to ensure the data systems are well-integrated with the rest of the IT infrastructure and meet the organization's technical standards and requirements.

Business Leaders and Stakeholders: Data Architects often collaborate with business leaders and other stakeholders to understand their data requirements and strategic goals, and to explain data-related issues or decisions.

Database Administrators: In some organizations, Database Administrators are responsible for the day-to-day management and operation of the databases. The Data Architect often works closely with them, providing guidance on the overall data structure and strategies.

Compliance Officers: In industries with strict data regulations, Data Architects may work with Compliance Officers to ensure the company's data practices meet all legal and regulatory requirements.

Project Managers: In the context of specific projects, Data Architects may work with Project Managers, contributing their expertise to the project planning and execution.

In sum, the Data Architect's role is highly collaborative, requiring good communication and teamwork skills, along with technical expertise.

Olivia Powell
Recruiting expert

Last updated Sep 24

Weekly Webinars

Get started with 100Hires

We use cookies to offer you our service. By continuing to use this site, you consent to our use of cookies as described in our policy

Data Architect Job Description

Job summary 1

Duties & Responsibilities 1

Requirements & Skills 1

Job summary 2

Duties & Responsibilities 2

Requirements & Skills 2

Job summary 3

Duties & Responsibilities 3

Requirements & Skills 3

Job summary 4

Duties & Responsibilities 4

Requirements & Skills 4

Job summary 5

Duties & Responsibilities 5

Requirements & Skills 5

Job summary 6

Duties & Responsibilities 6

Requirements & Skills 6

Job summary 7

Duties & Responsibilities 7

Requirements & Skills 7

Job summary 8

Duties & Responsibilities 8

Requirements & Skills 8

Job summary 9

Duties & Responsibilities 9

Requirements & Skills 9

Job summary 10

Duties & Responsibilities 10

Requirements & Skills 10

Frequently asked questions

What is the role of a data architect?

Who does a data architect work with?

Start Using 100hires for Free

Weekly Webinars

Start Using
100hires for Free