Data Architect

Job Overview
Job Order:JO00020134
Date Posted:Feb 26
Category:3 - Information Technology (I/T)
Metro Area:

Describe the key responsibilities and deliverables that this position is accountable for. Indicate strategic vs. tactical focus.
• Contribute thought leadership in development and evolution of our Enterprise Data Services capabilities and strategy.
• Collaborate with internal and external personnel, including system architects, software developers, database administrators, design analysts and information modeling experts to determine project requirements and capabilities.
• Design relational databases to support business enterprise applications and physical data modeling according to project requirements for data acquisition and security as well as customer-defined deliverables.
• Research new technologies, data modeling methods and information management systems to contribute to and evolve Dana’s data & analytics strategy.
• Review existing data architectures to determine overall effectiveness and compliance with original objectives, develop comprehensive strategies for improving or replacing underperforming.
• Develop architectural strategies for data modeling, design, and implementation to meet stated requirements for metadata management, operational data stores and Extract Transform Load environments
• Develop a logical data model that represents all data assets across Dana’s application landscape.

• Identify all master data elements that are shared throughout Dana’s application landscape.

• Document data lineage across Dana’s application landscape and establish processes for maintaining data integrity throughout the landscape.

• Maintain Dana’s data catalogue to enable easy identification of systems of record and systems of reference.

• Establish reusable integration patterns for maintaining systems integrations, master data management and analytical solutions.

• Design reusable analytical data models within SAP HANA, SQL Server and PowerBI.
• Design and implement effective database solutions and models to store and retrieve data for analytical and integration use cases.
Bachelor’s Degree in a business or technical discipline required.

• 5-7 years related professional experience
• Minimum of 3 years of IT experience as a data architect or data modeler.
• Knowledge of SQL Server and SAP HANA database platforms
• Experience with Azure Data Factory, DataBricks, PySpark, and AzureSQL for data processing
• Experience with Microsoft PowerBI for analytics.
• Technical experience in the development of Extract, Transform and Load solutions for the delivery of analytical solutions.
• Technical experience with internet of things (IOT) and data streaming for connected products.
• Technical experience in integration patterns, SOA governance, and information modeling that pertains to systems integration
• Knowledge of cloud integration (iPaaS), service enablement (API), the data integration disciplines of messaging (ESB) for real-time data propagation, service-oriented architecture (SOA) for information sharing, and extract, transfer and load (ETL) for data staging and movement

Language Skills
• English (fluency in reading, writing, and speaking)

• None Required

Additional skills
• Creation of logical and physical data models
• Creation of Process Models
• Definition of dataflows and supporting data processing operations
• Creation of database design models (3NF, Star Schema, Snowflake, etc.)

Periodic U.S. and International travel will be required