Data Architect Job Description
Data architect
provides assistance, guidance to development teams in regard to data modeling, SQL and stored procedure development, includes code review of complex SQL and stored procedures and performance tuning as needed by development teams; develops data models as required by project team.
Data Architect Duties & Responsibilities
To write an effective data architect job description, begin by listing detailed duties, responsibilities and expectations. We have included data architect job description templates that you can modify and use.
Sample responsibilities for this position include:
Build and guide our data growth, analysis, and storage strategies
Supporting database requests in DB2, Teradata, Oracle, or SQL Server
Reviewing SQL for potential performance improvements
Guide data modeling efforts on storage technologies like HBase, Cassandra, MongoDB, DWH technologies like Teradata, Vertica
Research and Innovate using emerging open source storage technology stack like Opentsdb, Rocksdb, Druid
Support ETL processes moving data between various DB platforms via a custom-coded management application
Design and develop database applications using SQL Server Integration Services (SSIS)
Performs data modeling (conceptual, logical and physical) for supported applications (OLTP, ODS, MDM, Data Marts, Data Warehouse ,) and projects and creates related diagram deliverables
Collaborates with the Sr
Utilize ERWin to develop logical data models from functional specifications, data requirements, and business rules provided by clients
Data Architect Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Data Architect
List any licenses or certifications required by the position: AWS, CSM, ADS, TDWI, DAMA, SQL, CISM, CISA, CISSP, GCP
Education for Data Architect
Typically a job would require a certain level of education.
Employers hiring for the data architect job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Computer Science, Engineering, Technical, Information Technology, Education, Information Systems, Business, Science, Computer Engineering, Computer
Skills for Data Architect
Desired skills for data architect include:
SQL
S3
Cloud Computing
VPC and Redshift
Python
Storage
Queries and stored procedures
ETL
Spark
Writing SQL commands
Desired experience for data architect includes:
Advanced knowledge of data modeling in relational, dimensional, multidimensional, and non-structured environments
Advanced knowledge of data integration patterns and procedures
Expert knowledge of an industry standard financial data model, like FSLDM, is an asset
Advanced knowledge of data mastering principles
Deep understanding of data governance principles
Responsible for contributing to multiple projects with high degree of complexity and broad scope
Data Architect Examples
1
Data Architect Job Description
Job Description Example
Our innovative and growing company is looking for a data architect. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for data architect
- Design the database, data models, ETL processes, and data warehouse applications through the use of best practices and tools, including SQL and SSIS
- Responsible for overall data architecture for all areas and domains of the enterprise, including data acquisition, ODS, MDM, data warehouse, data provisioning, and ETL
- Ensure data received or created are effectively controlled and maintained in accordance with Bank policies
- Control and dispose of sensitive data and confidential information in accordance with the Corporate Code of Conduct policies
- Provide written analysis of changes between reporting periods and the results of investigations on data irregularities
- Ability to function at the platform architect level the application level is required, as the position is reponsible for both the DW platform and working with application teams (e.g., for view design)
- Lead database level tuning and optimization in support of application development teams on an ad-hoc basis
- Gather and analyze business data requirements and model these needs
- Expert level understanding of relational database concepts, dimensional database concepts and database architecture and design, ontology and taxonomy design
- Desirable but not required understanding of ontologies and semantic web RDF and SPARQL, previous experience with global ecommerce platforms and subscription management platforms, enterprise modeling tools and search technologies such as SOLR and context analysis
Qualifications for data architect
- Experience with using CA Erwin to develop Enterprise Data Models
- Experience in metadata management—maintenance design and implementation of metadata-driven enterprise solutions
- Familiarity with data privacy, compliance, and security principles and standards (GLBA, COBIT, Sarbanes-Oxley)
- Provide expertise and counsel
- Use specialized tools and techniques to develop data model and enhance existing data model
- Experience with distributed data processing tools (Hadoop) is a plus
2
Data Architect Job Description
Job Description Example
Our company is growing rapidly and is looking for a data architect. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for data architect
- Set standards for data management, analyze current state and conceive desired future state, and conceive projects needed to close the gap between current state and future goals
- Define how data will be stored, consumed, integrated and managed by different data entities and IT systems, any applications using or processing that data in some way
- Establish and enforce data governance functions and frameworks
- Collaborate with internal and external partners to ensure that technology decisions align with the overall Enterprise Architecture Framework / Roadmap
- Troubleshoot recurring problems at the code level with ongoing capacity planning
- Partner with business analysts and customers to translate business and data requirements into logical and physical data models in support of Enterprise Data Warehouse (EDW)
- Translate business intelligence metrics into EDW technical requirements
- Collaborate with data stewards and business customers to identify data usage patterns and formulate business names, definitions, and data quality rules for data elements
- Generate and maintain the enterprise data asset catalog
- Create and manage business metadata and consistent data definitions across the business units for published data sources to ensure that it is easily discoverable, and meaningful to information workers
Qualifications for data architect
- 3-5 years of experience with data architecture, large-scale data modeling, database design, and business requirements analysis
- Technical leadership abilities in data architecture
- Strong understanding of the best practices in data modeling techniques including in-depth knowledge of the various normalization, dimensional modeling and their appropriate usage in various solutions
- Demonstrated experience in large scale enterprise and data warehouse initiatives, involving multiple departments
- Ability to communicate strategies and processes around data governance and modeling across departments and senior leaders
- Knowledge of database administration, and performance tuning
3
Data Architect Job Description
Job Description Example
Our company is growing rapidly and is looking to fill the role of data architect. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for data architect
- Work with third party BI solution providers where necessary to incorporate any suggested design improvements or factors, and ensure that the identified data structure is resilient, flexible and scalable
- Support the implementation of the appropriate data architecture for existing and new development, and supporting the development of any new data warehouses ( 200+TB) , data marts, data transformation and data extracts
- Provide guidance on technical specifications, data modeling, and reviews proposed data marts, data models, and other dimensional uses of data within the Data Warehouse
- The Data Architect will oversee the mapping of data sources, data movement, interfaces, and analytics, with the goal of ensuring data quality
- Develop and deliver long-term strategic goals for data architecture vision
- Acts as a subject matter expert for the Data Services team, internal and external clients, on key datasets
- Promote and provide support for BI solutions/capabilities to the business user community executives
- Execute rapid prototyping for new report requirements using open source, Hadoop
- Leverage internal and external subject expertise to translate regulatory and business requirements into process and technology / data requirements
- Think and plan strategically while formulating software / data specifications
Qualifications for data architect
- Team or project lead experience
- Familiarity with reporting/ad-hoc analysis tools such as MicroStrategy, Cognos, Business Objects, Tableau
- Familiarity with customer identification and address standardization processes and tools such as Unica
- Able to form and express reasoned opinions
- Advanced knowledge of data mastering (MDM) principles (client master, security master, org master, …)
- Breadth in established and emerging Data technologies
4
Data Architect Job Description
Job Description Example
Our growing company is searching for experienced candidates for the position of data architect. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for data architect
- Contribute to the ongoing development of the schema, schema management tools, ETL tools, and data replication tools - which all fall under the "data engineering" umbrella
- Experience with ETL tools such as Informatica, GoldenGate, DMX or similar
- Gauge existing system’s design, performance, and/or implementation issues using SQL Server monitoring and tuning tools to help circumvent or ideally, resolve the issues in development
- Provide hands-on application design and development of data structures
- Work with leadership to influence the direction of our data technology platform
- Work with the architecture and development teams to help choose data-related technologies, design architectures, and model data in a manner that is efficient, scalable, and supportable
- Participate in, and significantly contribute to, corporate architecture reviews
- Mentor and work with members of IT to develop and support our enterprise data
- Work with the Project Manager (PM) to identify set of tasks unique to the project
- Provide inputs to capacity planning in case it is a new environment
Qualifications for data architect
- Demonstrable experience using data modeling tools - , ERwin
- Ability to perform data manipulation, data cleansing, data analysis, and data anomalies detection
- Knowledge of SAP, Salesforce, and HR systems data models
- Working knowledge of Business Intelligence tools such as Tableau and Business Objects
- Ability to create very complex process flow diagrams or flowcharts that demonstrate business or system process and data flows
- Ability to perform data fit/gap analysis based on requirements
5
Data Architect Job Description
Job Description Example
Our company is looking for a data architect. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for data architect
- Show the current state, future state and transition plan
- Address implementation of a data architecture program and program operations
- Provide an estimated level of effort for each task
- Provide a description of the skill set needed to implement the data architecture and provide operational program support
- Defining the Enterprise Data Strategy for JD Williams
- Develop and maintain subject area data models such as Customer, Traveler, Booking, Rates
- Designing and understanding relevant data models
- Contribute to tools supporting a continuous delivery model to achieve non-breaking, data API contracts
- Play a vital role in publishing our baseline reporting and analytics source to the retailer & partner community
- Contribute to the development of a "data API" by designing and creating persistent rollups, optimizing access patterns and building tools that provide "data access" to the retailers & partners
Qualifications for data architect
- Strong problem-solving and analytical skills, creativity and the ability to work with abstract concepts to create innovative and appropriate data architectural proposals and work to ensure their adoption
- Strong experience in Data Modeling Techniques, data warehousing, data administration
- Knowledge of large scale data systems and data integration, supporting both batch & transactional deliveries
- 3+ years experience in Data Base Change System
- Experience with data modeling tools such as ERwin or Power Designer Team or project lead experience
- Experience with BMC Change Manager