Data Architect Specialist

Overview:
**Why GMF?**

GM Financial International Operations conducts business in Latin America and China. International Operations offers a wide range of wholesale and retail automotive financing products to dealers and their customers. The strength of the international

business lies in its ability to tailor its products to meet unique dealer needs, consumer preferences and national requirements in local markets. Latin American country operations include Brazil, Chile, Colombia, Mexico, and Peru.

**About the role**

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 with supporting documentation. This team member actively leads and participates in Data Governance initiatives to support the GM Financial 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. 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.

**Location**: São Paulo

**Responsibilities**:
**What you will be doing**
- Work fluently with many technologies including Hadoop, Big Data, NoSQL, Data Virtualization, Data Services, Oracle, Oracle Exadata
- 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
- 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 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
- 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
- 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
- Perform other duties as assigned
- Conform with all company policies and procedures

Qualifications:
**What you need**
- Bachelor degree in related field.
- Experience in Data Modeling.
- Experience with current data technologies including Hadoop, Big Data, NoSQL, Data Virtualization, Data Services, Oracle, Oracle Exadata.
- Advanced English Skills both verbal and written.
- Working knowledge of business processes for supported business groups
- Working knowledge of information technology systems, infrastructure and operations
- Working knowledge of security methodologies, policies, standards and best practices
- Knowledgeable about best practices in information technology governance and regulatory landscape for financial institutions
- Working knowledge of the consumer loan business
- Working knowledge of the Corporate Business solution environment
- 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
- Must be able to recognize and identify patterns in data relationships from disparate systems
- Strong in the use of Microsoft Office software including strong ability to analyze data using Excel for reporting and data mining purposes
- Strong people skills including the ability to interact with employees at all level
- Ability to meet expected delivery dates and the tasks necessary to achieve objectives.
- Computer skills and conversance in information technology issues.
- Deadline oriented.
- Excellent writing and speaking skills.
- Experience with data