Data, Information Architect

Jobtailor; Dearborn (MO); On-site; USD 120,000 - 170,000; Full time

Job summary

Jobtailor is seeking a Senior Data Architect/Engineer to lead the design of enterprise data models and governance across Industrial Systems. You will shape data strategy, guide platform choices, and collaborate with IS and EDP teams to advance the data landscape.

Responsibilities include modeling data architectures, enabling data integration on ISDP, and applying TOGAF and DAMA principles. Strong GCP experience with BigQuery and PostgreSQL is required.

Qualifications

• Bachelor degree in CS, IS, or equivalent
• 8+ years IT experience
• 5+ years data architecture/engineering in OLTP/RDBMS, DW
• Knowledge of Master Data Management concepts
• Experience with PLM platforms (e.g., Teamcenter, 3D Experience)
• Knowledge of TOGAF and DAMA standards
• Ability to define data architecture principles
• 4+ years hands-on data modeling with Power Designer
• 2+ years GCP knowledge including BigQuery, AlloyDB, PostgreSQL, Cloud Run, MongoDB
• Understanding AI capabilities and semantic data modeling

Responsibilities

• Provide consultation and guidance on data strategy for IS initiatives.
• Lead IS Data Strategy Office Hours and guidance on data challenges.
• Partner with the EDP team to align roadmap for IS EA architects.
• Design and maintain information/data models (enterprise, conceptual, logical, physical) using Power Designer.
• Map applications to data models, processes, and capabilities.
• Translate use cases into data requirements for product teams and provide architecture guidance.
• Lead discovery and integration of sources into ISDP.
• Develop canonical domain models and data dictionaries for identified sources.
• Define data quality requirements, metrics, and monitoring; guide remediation.
• Establish data-architecture principles, standards, and guidelines for the data platform.
• Perform POCs and guide product teams in using GCP data-engineering tools.

Skills

Data Architecture

Data Engineering

Data Modeling

OLTP/RDBMS

Data Warehousing

GCP

BigQuery

PostgreSQL

MongoDB

Cloud Run

Data Governance

Education

Bachelor of Computer Science or Information Systems

Tools

Power Designer

AlloyDB

PostgreSQL

MongoDB

Cloud Dataflow

Job description

Responsibilities

• Provide consultation and data‑strategy support for IS initiatives.
• Run EA IS Data Strategy Office Hours and provide guidance on data challenges.
• Partners closely with the EDP team—understand their roadmap and share relevant updates with IS EA architects.
• Design and develop information/data models (enterprise, conceptual, logical, and physical) for Industrial Systems; manage and maintain models in a Power Designer repository.
• Map applications to the conceptual data model, business processes, and business capabilities.
• Support product‑team intake: translate use cases into data requirements and provide expert architecture guidance and designs.
• Lead discovery, onboarding, and analysis of sources into Industrial Systems Data Platform (ISDP); build deep understanding of the data landscape and enable integration of diverse sources into ISDP.
• Lead conceptual discussions to understand the data landscape; identify and evaluate candidate data sources; maintain data models and data dictionaries for identified source systems; and develop canonical domain models.
• Profile source‑system data; define data‑quality requirements, dimensions, and metrics; and guide monitoring, measurement, reporting, and issue remediation.
• Establish data‑architecture principles, standards, best practices, and guidelines for the data platform (catalog, lineage, observability, security, interoperability).
• Perform proof‑of‑concepts and guide product teams in designing and developing solutions using GCP data‑engineering technologies and tools.

Core Competencies

Demonstrates expertise in Data Architecture and Engineering, with a strong focus on designing and implementing data models and strategies for Industrial Systems. Proficient in GCP technologies and data management principles, ensuring high-quality data integration and governance.

Requirements

• Bachelor of Computer Science, Information Systems, Systems Programming or equivalent combination of relevant education and experience
• 8+ years overall IT experience.
• 5+ years of Data Architecture, Data Engineering, or advanced Database Design/Modeling experience in designing or implementing OLTP/RDBMS databases, Data Warehouse, Data Marts.
• Knowledge of Master Data Management concepts and tools
• Functional and Architecture Experience with one or more PLM platforms (e.g., Siemens’ Teamcenter, Dassault’s 3D Experience)
• Knowledge of TOGAF, DAMA Architecture Framework and Standards
• Ability to define data architecture principles, guidelines and standards
• 4+ years of hands‑on experience creating data models using data modeling tools (e.g. Power Designer)
• 2+ years of experience in GCP technologies including Big Query, Alloy DB, PostgreSQL, Cloud Run, Mongo DB, Data Flow. Similar cloud experience may be acceptable.
• Understanding and knowledge of AI capabilities and modeling semantic layer for a data platform.