Data Architect Job Description

Data Architect I designs and builds relational databases for data storage or processing. Develops strategies for warehouse implementation, data acquisition and access, and data archiving and recovery. Being a Data Architect I builds data models and defines the structure, attributes and nomenclature of data elements. May evaluate new data sources for adherence to the organization’s quality standards and ease of integration. Additionally, Data Architect I typically requires a bachelor’s degree. Typically reports to a supervisor or manager. The Data Architect I works on projects/matters of limited complexity in a support role. Work is closely managed. To be a Data Architect I typically requires 0-2 years of related experience.

View Data Architect jobs

Data Architect Job Description Template

Our company is looking for a Data Architect to join our team.

Responsibilities:

  • Definition of Information from each data sources integrating to the enterprise DW Define the Dimension information;
  • Generate DDL and validate that the DDL is implemented properly;
  • Participate in DRB reviews by providing constructive feedback to others;
  • Provide input into the vision, strategy and principles for end-to-end data management pertaining to repeatable Advisory Technology developed solutions;
  • Ability to identify and design the implementation of new systems while maintaining existing systems and processes;
  • Lead Initiatives to define approach to dashboarding and reporting solutions for the application;
  • Develop DW Standards for Enterprise including Database, ETL and Reporting Standards to be used in development projects on DW Platform;
  • Develop and maintain Dashboards/reports using Tableau and Looker;
  • Proactively monitors systems for optimum performance and capacity constraints;
  • Other duties as assigned;
  • Being competitive, bold, innovative and adding value;
  • Develop security and backup procedures;
  • Respect for our internal and external customers;
  • Design and architect data solutions with Business intelligence and reporting in mind;
  • Perform R & D of various reporting tools to find the best fit for CoStar Real Estate Manager.

Requirements:

  • Experience with data management platforms (e.g. SSIS, SSAS, InfoSphere, Talend, Informatica, SAS);
  • Assist in the delivery of business intelligence solutions with best of breed products;
  • Experience with Denodo a plus;
  • Take initiative in an environment involving diverse sets of data, documents, and materials;
  • Demonstrated strong leadership and mentoring skills. ;
  • 3+ years of data modeling experience;
  • Bachelor’s Degree in Computer Science, Computer Engineering or a closely related field;
  • Master of database structuring and querying having first-hand experience in designing complex database systems;
  • Ability to design data models based on functional data/business requirements;
  • Knowledge of data architecture and design patterns and the ability to apply them;
  • Ensure compliance with approved IT standards, principles, policies and guidelines in the design of projects, applications and solutions;
  • Experience implementing an end-to-end Software Development Lifecycle (SDLC);
  • Experience with Hadoop (or similar) Ecosystem (MapReduce, Yarn, HDFS, Hive, Spark, Presto, Pig, HBase);
  • 5 years’ experience designing and implementing data systems in a lead role;
  • 10+ years of experience managing, architecting, and integrating Oracle databases.