Data Architect Job Description
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:
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:
Desired experience for data architect includes:
Data Architect Examples
Data Architect Job Description
- 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
- 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
Data Architect Job Description
- 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
- 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
Data Architect Job Description
- 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
- 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
Data Architect Job Description
- 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
- 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
Data Architect Job Description
- 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
- 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