Data Architect

Agile Premier
Arlington, TX
Jun 13, 2017
Jobs Outside Higher Education
Software & Technology
Institution Type
Outside Academe

Job Description

We are looking for a Data Architect II in our DFW area office. The Data Architect II is responsible for designing and documenting logical and physical Enterprise Application (OLTP) and Data Warehouse (OLAP) databases and creating the related ETL Design Specifications and supporting documentation. This team member actively leads and participates in Data Governance initiatives to support the Enterprise Data Strategy across operational and analytical database environments. The Data Architect II leads and coordinates cross functional teams on a project basis to effectively communicate database design related activities with a wide range of technical, non-technical, and third party team members. This team member is also responsible for the publication and distribution of Enterprise and Data Warehouse data models and related documentation throughout the company.

COMPENSATION: $150,000 TO $160,000 (based on experience)

BONUS: 14%, expectation is to be around the same % this year but depends on company performance.

LOCATION: DFW (Arlington, TX)

NOTES: This is a management level position. This will require 8+ years of actual Data Modeling, Architecture, Data Warehousing, Big Data, BI and a few more items listed below. This is not a third party opportunity so please do not contact us about that option.


The Data Architect II searches for, identifies, and exploits opportunities to enhance Enterprise analytical databases using knowledge gained from experience and from an understanding of emerging methodologies. Detailed Description JOB DUTIES Create and document logical data integration (ETL) strategies for data flows between disparate source/target systems and the Enterprise Data Warehouse. Perform a variety of in-depth data analysis, data modeling, and data administration tasks on complicated datasets with potentially complex data integration scenarios with limited supervision. Provide senior level guidance in the interaction with business users to plan, develop, improve, and maintain complex components of the logical/physical Enterprise Data Warehouse and related models. Establish, maintain, adhere to, and enforce Enterprise Data Modeling and Data Integration standards. Communicate with and/or interview users to plan, develop, improve, and maintain moderately complex components of the logical/physical corporate model. Work closely with BSA, business, and IT team members to clarify and refine functional data requirement specifications. Develop and present training materials such as data flow diagrams, conceptual diagrams, UML diagrams, ER flow diagrams as needed in order to clarify data model meaning and usage effectively to a wide range of technical and non-technical consumers. Work closely with Database Administrators and Data Integration (ETL) developers resulting in effective data driven solutions. Participate in the implementation of strategic Enterprise Data Strategies. Must drive innovations by keeping current on emerging technology and Data Trends which may fit with company needs. Must be able to research, present, and accurately articulate benefits and goals of these technologies, such as Big Data, Hadoop, NoSQL, Data Virtualization, Data Services. Participate in the proliferation of our Corporate Meta-Data Repository. Maintain and administer the Corporate Data Model Repository. Create Reporting as required on Corporate Data Model Repository.

We are not looking for any one specific architect, so if you are an ETL Architect or BI Architect or a specific niche architect please do not apply. We are looking for someone who can handle all aspects of Architecture along the entire Data Life-cycle process. Please review and only apply if you have experience in the following requirements which have been highlighted below. This is not a learn as you go opportunity so if you dont have experience in one aspect of the requirements please DO NOT APPLY!


Thorough understanding of data modeling and experience in modeling techniques required.

Must have moderate to strong knowledge of Relational Database Design, Dimensional Database Design, and Hub and Spoke Database Design. Data Vault Modeling preferred.

Must have moderate to strong working knowledge of Erwin Data Modeling Software.

Must have moderate to strong working knowledge of ETL and Data integration techniques. Informatica Power Center Preferred.

Thorough knowledge of SQL.

Hands-on experience in usage and design considerations of 3 rd Normal Form OLTP Databases/ Models.

Hands-on experience in creation and usage of ETL Design Specifications.

Hands-on experience in creation and usage of Dimensional Models (Star Schema, Kimball, Inmon) ?? Basic understanding of Busing Intelligence Tools and both their functional and technical requirements. Cognos preferred.

Must have basic understanding or working knowledge of at least one of the following Data Management disciplines: Data Vault, Master Data Management, Data Virtualization, SOA, XML, Web Services, or Hadoop or similar Big Data methodology.

Must be highly intelligent, conceptual, display excellent judgment, and be capable of analyzing business and management problems.

Must possess the ability to arrive at sound and effective business solutions

Position requires proficient business knowledge in the subject areas being modeled.


Must possess strong organizational, facilitation and critical thinking abilities, to assess complex problems, analyze options, navigate diverse perspectives and objectives and develop acceptable Data Management solutions

Must be able to recognize and identify patterns in data relationships from disparate systems.

Must have a strong work ethic, positive demeanor, and drive to see projects through to successful completion.

Must have the ability to think logically and design data structures for applications. Must have excellent oral and written communication skills, and the ability to prioritize and handle multiple tasks and a heavy workload.

Must possess the interpersonal skills necessary to lead and coordinate others to accomplish goals on complex tasks/projects.

Must be able to present information in a clear and concise manner to all levels of the organization.

Must have the ability to work both autonomously and with appropriate collaboration among other team members and applying Data Management concepts to a variety of "real-life" business scenarios.

Must be assertive and proactive and have the ability to bring out the best in others.

Must have strong project management skills.


Minimum of Bachelor's Degree Required.

Minimum of 5 years overall experience in information systems is required.

Preferred background experience in Application Development, ETL Development, Report Development and/or other Data Warehouse Projects.

Minimum 2 years data modeling experience.

Experience working within an Enterprise Data Management role including transactional Data, Analytical Data, and Data Governance/Administration.

Experience with Oracle is highly desired.

Moderate experience with Data Modeling tools such as Erwin.

Company Description
Agile Premier is a privately-owned recruiting firm that specializes in Information Technology recruiting. The company is headquartered in Addison, TX (Dallas suburb) and has an additional office in Fort Worth, TX. Agile Premier is the market leader for placing key contributors and leaders within the software development life cycle, business intelligence solutions, data management, systems and network engineering, ERP, and content management / team collaboration space.

Agile Premier's internal team consists of the top performing recruiters in the industry who focus solely on building long-term relationships with Information Technology professionals. Our recruiting specialties include but are not limited to .NET, PHP, SharePoint, Windows Server, Linux/Unix Server, SSIS/Informatica, Cisco, Java, VMWare, Citrix, Oracle/SQL Server database, and much more.

Arlington, TX


Sat, 10 Jun 2017 10:57:48 PDT