Job Title: Senior Data Architect (50615-LYLDRO-IOM-O-ARI)

Location: Addison, TX

Duration: 12 months

Emp. Type: w2 / 1099

 

Job Description:

The Data Architect designs database structures for high-performance reporting & analytics systems. The Data Architect must be an expert in the database design techniques, including requirements discovery and analysis, formulation of solution context, identification and assessment of solution alternatives, and design implementation. The Data Architect should have working knowledge of data warehouse architectures and platforms and a proven history of cross-platform effectiveness. The ideal candidate will be skilled at performing business data flow analysis, designing data models, helping develop data dictionaries, and designing appropriate database access/authorization processes as part of an overall software development life cycle. The Data Architect will work with DBAs to generate database table structures, create indexes, and specify user authorization methods as they create and enhance databases. 

Required Skill:
• Serve as lead to define and maintain architectural frameworks/design, processes, standards, and guidelines, specifically around data. 
• Communicate relevant architecture decisions and share implications on data architecture work. Leading other technical staff engaged in development technologies and decisions. 
• Provide architectural subject matter expertise to internal and external clients, and communicate architectural decisions clearly and effectively. 
• Review and assess projects for adherence to architecture standards. Rationalize architectures both at the table and database levels, ensuring both high performance and efficient use of the data warehouse platform. 
• Be deeply skilled in database design. Possess sound knowledge across all phases of database development, from conceptualization to database optimization. This includes SQL development and database administration. 
• Familiarity with data warehouse platforms such as Netezza, Teradata, SQL Server PDW, etc. and ETL tools such as Informatica. While not necessarily deep in all of these technologies, a strong candidate will be experienced in one or more of these, and can sufficiently to guide the group in deploying them. Oracle database design and maintenance experience is highly desired. 
• Foundation in systems development: being able to conceptualize and influence application and interface projects, and therefore must understand what advice to give and where to plug in to steer toward desirable outcomes. 
• Ability to conceive and portray the big data picture: ability to map the systems and interfaces used to manage data, serve as a lead sets standards for data management, analyzes current state and conceives desired future state, and conceives projects needed to close the gap between current state and future goals. 

Specialized Knowledge & Skills 
• Knowledge of relational database platforms, in particular Oracle and Netezza (highly preferred) 
• SQL 
• SAS 
• Informatica 
• Tableau or other business intelligence tools such as Spotfire, MicroStrategy, Cognos, etc. (desired) 
• R (programming language) (desired) 
• Apache Hadoop (desired)

 

 

 

To Apply, Please click here: APPLY NOW