Overview
Why GM Financial?
GM Financial is the wholly owned captive finance subsidiary of General Motors and is headquartered in Fort Worth, U.S. We are a global provider of auto finance solutions, with operations in North America, South America, and the Asia Pacific region. Through our long-standing relationships with auto dealers, we offer attractive retail financing and lease programs to meet the needs of each customer. We also offer commercial lending products to dealers to help them finance and grow their businesses.
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.
Our Purpose: We pioneer the innovations that move and connect people to what matters.
Overview
The Data Architect III is responsible for delivering high quality data storage solutions and efficient data integration strategies used to support both applications (OLTP) as well as business intelligence (OLAP) and advanced analytics and machine learning (NoSQL) across the Enterprise. Drawing on robust hands on experience and leveraging multi-cloud services, NoSQL/ Distributed systems, web services, and relational database technologies this team member will drive the adoption of multi-hybrid cloud data services as well as large scale data pipelines across the enterprise ensuring emerging business goals are met while maintaining a consistent and stabile data landscape. The Data Architect III leads and coordinates cross functional teams composed of developers, administrators, and business teams on a project basis to effectively communicate database design related activities to a wide range of technical, non-technical, and 3rd party team members. While they search for, identify, and exploit opportunities for more effective data storage and use; this team member will also participate in strategic discussions with department and IT leadership and provide mentorship to more junior team members.
Responsibilities
What makes you an ideal candidate?
- 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 and Adhere to 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 ITS 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
- Create, maintain, and adhere to Enterprise Data Modeling Standards
- 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
- Serve as an SME for cloud and on-premesis data storage and integration across team with initial focus on Azure followed by Multi-Cloud to support 12 Factor software development (operational) and NoSQL data engineering
- Recommend advanced cloud and on-premises data storage and integration related solutions on basis of need and risk
- Educate teams on cloud data services and standards and serve as a mentor
- Regularly communicate project health and identifies risks to project and program stakeholders, sponsors, and management
- Resolve most conflicts between timeline, budget, and scope independently but intuitively escalate complex or consequential issues to management
- Define cloud data standards, DevOps, Continuous Integration / Continuous Delivery (CI/CD) processes
- Participate in the proliferation of our Corporate Meta-Data Repository
- Thorough understanding and working knowledge of Data Modeling and extensive experience in Modeling and Fact-Finding Techniques
- Must have strong knowledge of Relational Database, Dimensional Database, NoSQL, and Hub and Spoke Database architectures
- Advanced experience with current data technologies including Hadoop, Big Data, NoSQL, Data Virtualization, Data Services, Oracle, Oracle Exadata
- Must have strong working knowledge of ETL and Data integration techniques, Informatica Power Center/ Cloud preferred
- Thorough knowledge of SQL and SparkSQL
- Hands-on experience in creation and usage of 3rd Normal Form OLTP Databases/ Models
- Hands-on experience in creation and usage of Dimensional Models (STAR Schema, Kimball, Inmon)
- Advanced understanding of Busing Intelligence Tools and both their functional and technical requirements, Cognos and Power BI preferred
- Must be able to recognize and identify Patterns in Data Relationships from Disparate Systems
- Ability to create system and process flow diagrams, data flow diagrams, sequence and UML diagrams, inter and intra system dependencies within the functional domain and across them
- Possess strong organizational, facilitation and critical thinking abilities, to assess complex problems, analyze options, navigate diverse perspectives and objectives and develop acceptable Data Management solution
Qualifications
Education
- High School Diploma or equivalent required
- Bachelor’s Degree in related field or equivalent work experience preferred
Experience
- 5-7 years data modeling experience required
- 3-5 years with cloud architecture and PaaS, IaaS, SaaS services related to data storage (Azure required, prefer multi-cloud solutions) preferred
- Database/ data store design experience with at least three or more years of experience with cloud like technologies such as Microsoft Azure, Amazon Web Services (AWS) or Google Cloud Platform (GCP) preferred
- Experience in Application Development, ETL Development, Report Development and/ or other Data Warehouse Projects preferred
- Experience working within an Enterprise Data Management role including transactional Data, Analytical Data, and Data Governance/ Administration preferred
- Experience with Oracle/ Oracle Exadata highly preferred
- Strong experience with Data Modeling and Data Integration tools preferred
- Experience with Cloud based Data Warehouse services (Azure Synapse, Data Bricks Delta Lake, Snow Flake, AWS Redshift) preferred
- Experience architecting DevOps automated data pipelines preferred
- Experience architecting Enterprise Data Pipelines leveraging technologies such as Kafka, Azure Event Hub, Azure Service Bus preferred
- Experience creating and maintaining Web Services for Enterprise Data Hub preferred
- Experience Architecting solutions for Machine Learning and Advanced Analytics/ Data Science deployments preferred
- Experience Architecting Enterprise Data Lake/ Distributed Data patterns for use in Multi-Cloud/ Hybrid Cloud Environments preferred
What We Offer: Generous benefits package available on day one to include: 401K matching, bonding leave for new parents (12 weeks, 100% paid), tuition assistance, training, GM employee auto discount, community service pay and nine company holidays.
Our Culture: Our team members define and shape our culture — an environment that welcomes innovative ideas, fosters integrity, and creates a sense of community and belonging. Here we do more than work — we thrive.
Compensation: Competitive pay and bonus eligibility
Work Life Balance: Flexible hybrid work environment, 2-days a week in office
#LI-Hybrid
#LI-MH1
Salary
The base salary range for this role is: USD $112,200.00 to $213,100.00. At GM Financial, we strive for transparency in all aspects of our business, including pay equity. This is the GM Financial pay range for this role and job level. The exact salary and compensation will vary based on factors like knowledge, skills, experience, and education. This role is eligible to participate in a performance-based incentive plan. Full time employees are eligible to participate in health benefits on day one of employment.