At GM Financial, our team members define and shape our culture — an environment that welcomes new ideas, fosters integrity, and creates a sense of community and belonging. Here we do more than work — we thrive.
Overview
- 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
- 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 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
- Working knowledge of business processes for supported business groups
- Working knowledge of information technology systems, infrastructure and operations
- Knowledge of GM Financial's core business functions
- Working knowledge of security methodologies, policies, standards and best practices
- Knowledgeable about 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 consumer loan business
- Working knowledge of the Corporate Business solution environment
- Thorough understanding of data modeling and experience in modeling techniques required such as Relational, Dimensional and Data Vault
- 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 levels
- 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 visualization concepts and tools
Qualifications:
- High School Diploma or equivalent required
- Bachelor’s Degree in related field or equivalent work experience preferred
- Master’s Degree preferred
- 3-5 years of Data Modeling required
- Experience with current data technologies including Hadoop, Big Data, NoSQL, Data Virtualization, Data Services, Oracle, Oracle Exadata required
- Related IT, business and technology certifications preferred
Note:Please note we are not able to consider candidates who require visa sponsorship for this position.
#LI-Hybrid