Data Architect III Gm Financial
Arlington, TX

Job Description

Overview

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 GMF 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. Provide functional advice or training and serve as a mentor to less experienced Data Warehouse Analysts.

Responsibilities

JOB DUTIES

* 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.
* Create and document logical data integration (ETL) strategies for data flows between disparate source/target systems and the Enterprise Data Warehouse. 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 GMF needs. Must be able to research, present, and accurately articulate benefits and goals of these technologies, such as Big Data, Hadoop, NoSQL, Data V
* Provide functional advice or training and serve as a mentor to less experienced Data Warehouse Analysts.

Qualifications

Knowledge

* Advanced knowledge of business processes for supported business groups.
* Advanced knowledge of information technology systems, infrastructure and operations.
* Advanced working knowledge of information systems and operations systems for supported business groups.
* Knowledge of business processes for supported business groups.
* Knowledge of GM Financials core business functions, policies and procedures.
* Knowledge of information technology systems, infrastructure and operations.
* Knowledge of security methodologies, policies, standards and best practices.
* Knowledgeable of best practices in information technology governance and regulatory landscape for financial institutions.
* Significant experience in a large and complex business environment.
* Working knowledge of all system applications.
* Working knowledge of the Corporate Business solution environment.
* Thorough understanding and working knowledge of data modeling and extensive experience in modeling and fact-finding techniques.
* Must have strong working knowledge of ERwin Data Modeling Software.

Skills

* Ability to analyze data using Excel for reporting and data mining purposes.
* Ability to effectively lead, organize, and supervise.
* Ability to interact with staff at all levels.
* Ability to meet expected delivery dates and the tasks necessary to achieve objectives.
* Ability to work directly with senior level management.
* Advanced computer skills and conversance in information technology issues.
* Advanced experience with data visualization concepts and tools.
* Competent in the use of Microsoft Office software.
* Computer skills and conversance in information technology issues.
* Deadline oriented.Excellent writing and speaking skills.
* Experience with data visualization concepts and tools.
* Strong ability to analyze data using Excel for reporting and data mining purposes.
* Strong in the use of Microsoft Office software.
* Strong people skills.
* Hands-on experience in creation and usage of 3rd Normal Form OLTP Databases/ Models.
* Must have the ability to independently identify opportunities for improvement in Enterprise Analytical Databases.
* Must have a strong work ethic, positive demeanor, and drive to see projects through to successful completion.

Education

* High School Diploma or equivalent required
* Bachelor's Degree or equivalent experience preferred
* Master's Degree or equivalent preferred

Experience

* 5-7 Years data modeling experience. Required
* 7-10 Years overall experience in information systems .

Work Condition

* Subject to stressful situations; harsh language from customers;some travel required;normal office environment; Fast-paced office environment; Strong focus on providing quality service to internal and external customers; Flexible schedule with possibility of working long hours;Limited travel may be required to support business needs; Must be able to deal with stressful office conditions while troubleshooting problems