Logo of Huzzle

Home

Matches

Explore

Manage

Data Architect II

image

GM Financial

3mo ago

  • Job
    Full-time
    Senior & Expert Level
  • Data
  • Detroit

AI generated summary

  • You need a high school diploma; 3-5 years in data modeling and cloud architecture (Azure preferred); experience with ETL, database design, and data governance; and familiarity with Oracle and data pipelines.
  • You will model complex data, analyze patterns, maintain data standards, collaborate with users, create ETL strategies, and support data integration in a multi-cloud environment.

Requirements

  • 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
  • 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
  • Experience designing, diagramming, and documenting for ETL Development, and/or other Data 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
  • Experience in Data Modeling , Data Engineering and Data Integration 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 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

Responsibilities

  • Thorough understanding of data modeling and experience in modeling techniques required such as Relational, Dimensional and Data Vault
  • Moderate to strong working knowledge of ERwin Data Modeling Software
  • Experience with Cloud based Data Warehouse services (Azure Synapse, Data Bricks Delta Lake, Snow Flake, AWS Redshift) preferred
  • Experience with cloud architecture and PaaS, IaaS, SaaS services related to data storage (Azure required, multi cloud solutions) preferred
  • 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
  • Must be able to recognize and identify patterns in data relationships from disparate systems
  • 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
  • Provide 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
  • Maintain and administer the Corporate Data Model Repository
  • 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
  • Must have moderate to strong working knowledge of ETL and Data integration techniques, Informatica Power Center preferred
  • Significant experience in a large and complex business environment
  • Participate in the proliferation of our Corporate Meta-Data Repository
  • Research, present, and accurately articulate benefits and goals of these technologies, such as Big Data, Hadoop, NoSQL, Data V
  • Work fluently with many technologies including Hadoop, Big Data, NoSQL, Data Virtualization, Data Services, Oracle, Oracle Exadata
  • Strong in the use of Microsoft Office software including strong ability to analyze data using Excel for reporting and data mining purposes
  • Experience with data visualization concepts and tools

FAQs

What are the primary responsibilities of a Data Architect II at GM Financial?

The Data Architect II is responsible for designing and documenting logical and physical Enterprise Application and Data Warehouse databases, creating ETL Design Specifications with supporting documentation, leading Data Governance initiatives, coordinating cross-functional teams, publishing and distributing data models, and enhancing analytical databases.

What skills and experience are required for this position?

Ideal candidates should have a thorough understanding of data modeling techniques, moderate to strong knowledge of ERwin Data Modeling Software, experience with cloud-based Data Warehouse services (such as Azure Synapse and Snowflake), ETL and data integration techniques, and the ability to perform in-depth data analysis. Additionally, experience with various data technologies, strong communication skills, and the ability to work in a collaborative environment are important.

What educational background is preferred for the Data Architect II role?

A high school diploma or equivalent is required, with a Bachelor’s Degree in a related field preferred. A Master’s Degree is also preferred.

How many years of experience are necessary for this position?

Candidates should have 3-5 years of experience in data modeling, working with cloud architecture and related data storage services, and database design. Additionally, experience with data engineering and data integration is valued.

What tools and technologies should candidates be familiar with?

Candidates should have experience with ERwin Data Modeling Software, ETL tools like Informatica Power Center, cloud services like Azure, AWS, and modern data technologies including Hadoop, Big Data, NoSQL, and data virtualization tools.

Is the Data Architect II position a remote job?

The role offers a flexible hybrid work environment, requiring two days per week in the office.

What does GM Financial offer in terms of benefits?

GM Financial offers a generous benefits package that includes 401K matching, bonding leave for new parents, tuition assistance, training, GM employee auto discounts, community service pay, and nine company holidays, all available from day one.

Does GM Financial support diversity in the workplace?

Yes, GM Financial is committed to diversity and inclusion at every level of the organization and does not discriminate based on race, color, age, gender, national origin, religion, sexual orientation, gender identity, veteran status, disability, or any other protected class.

Are veterans encouraged to apply for this position?

Yes, all Veterans are welcome to apply for the Data Architect II position at GM Financial.

Will GM Financial consider candidates who require visa sponsorship for this position?

No, GM Financial is unable to consider candidates who require visa sponsorship for the Data Architect II position.

GM Financial

Teamwork | Excellence | Integrity | Diversity, Equity and Inclusion | Community Investment

Finance
Industry
5001-10,000
Employees
1992
Founded Year

Mission & Purpose

GM Financial is the captive finance company and the wholly owned subsidiary of General Motors and is headquartered in Fort Worth, Texas. The company is a global provider of auto finance solutions, with operations in North America, Latin America and China. Through our long-standing relationships with auto dealers, we offer attractive retail loan 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. GM Financial employs more than 9,000 hard-working team members, and we're always looking for new people with diverse talents. GM Financial is a workplace where dedicated people have the opportunity to work together and celebrate our successes. Our culture is based on respect, integrity, innovation and personal development. GM Financial is committed to strengthening the communities where we live and work. Each year, we select several philanthropic organizations to support through our Signature Events program. The company and its team members actively support these organizations through many company-wide initiatives; in addition we support numerous other nonprofit organizations through sponsorships and monetary donations. For more information, visit www.gmfinancial.com. NMLS #2108 (https://nationwidelicensingsystem.org/about/Pages/NMLSConsumerAccess.aspx)