Data Architect

in Morrisville, NC

Job #:274888

Practice Area: IT

Date Posted: 06/10/2019

Share this job  

Job Title:  Data Architect

Location:  Morrisville, NC

Industry:  IT

Terms:  Direct Placement

Requirements: 7+ years of experience as a data architect, experience architecting or re-architecting data warehouses, ER modeling and database normalization, experience with system architectures, business process management, programming and project management, ETL Tools, SQL

Data Architect – Job Description

The Data Architect will be responsible for defining the architecture road-map for achieving availability, performance and quality objectives for enterprise master data, transaction data and informational data.  

The Data Architect will be the lead technical member of the team responsible for planning, designing and implementing large scale OLTP databases, OLAP data warehouses and data marts, ODS repositories, the system transports and the business processes – all used to create, read, update, delete, move and synchronize enterprise data.  This individual will be a peer to the Business Process Architect and System Architect, and  provide technical and business process direction to Data Modelers, Database Architects, Business Analysts and Data Quality I/T Specialists. 

Data Architect – Job Responsibilities

  • Develop logical data models, and how data are shared and synchronized between various transactional and informational systems
  • Ensure the proper alignment of the logical data models with use cases, object models and interface definitions
  • Work with the Data Modeler and Database Architect in the development of the physical model that will meet availability, performance and quality objectives
  • Maintain change control of the logical data models and take business direction from the Data Steward responsible for aparticular datatype
  • Align business needs to I/T capabilities through effective integration of processes, data and I/T
  • Develop and maintain an architectureroad-mapfor achieving data availability, performance and quality objectives
  • Perform entity-relationship modeling including normalization.
  • Perform dimensional modeling, and define and select ETL techniques
  • Develop SQL queries
  • Perform in a matrix, cross-discipline environment.
  • Use Case and UML modeling tools to define and document as-isand to-be processes associated with the creation, use, update and deletion of data.
  • Use enterprise architecture patterns to specify how master, transactional and informational data are made available and synchronized across the enterprise


Data Architect – Job Requirements:

Basic Requirements:

  • Bachelor's Degree in a Computer Science, Engineering, or Math related discipline
  • 7+ years of experience as a data architect
  • Passion for deconstructing complex business problems, and engineering user-friendly, maintainable, scalable systems
  • Proven track record of driving solutionsfrom start to finish
  • Proven track record of having designs adopted by the business that have resulted in profit makingorcost/timesavings
  • High interest in researching newtechnologies toinnovate andkeep the business relevant
  • Must be skilled at ER (or relational) modeling and database normalization techniques for transactional systems; and dimensional modeling and the extract, transform and load
  • techniques for informational systems
  • Experience with system architectures, business process management, programming and project management

Preferred Qualifications:

  • Expertise and prior experience with SAP, project management and business process managementisa plus.
  • The candidate should have demonstrated competency in data modeling and by having successfully completed three major data projects involving both OLTP/ERP and OLAP systems.

 Frequently Asked Questions:

Benefits?  Yes, provided by the client

Remote Workers?  Not eligible, must work onsite with the team

Visa Sponsorship?  Not offered

Corp-to-Corp?  Not eligible

How to Apply:

For immediate attention please apply online and send a text message to Star Gibson at 919-287-3973 with your full name, job title, and location.

ettain group is a talent solutions company dedicated to matching people with the most relevant employment opportunities in IT, healthcare IT and the digital creative space. Top employers and highly skilled talent throughout the U.S. select ettain group for a better recruitment experience. Our culture empowers teams with the flexibility to deliver a superior candidate experience and client experience using market intelligence. We recruit resources, own projects and manage programs to offer a wide range of IT development and talent solutions to our clients and candidates. To learn more about ettain group visit To explore more job opportunities with ettain group, visit


Apply Now