Senior Data Architect - Enterprise Data & AI (Hybrid)

Wade Trim; Taylor (MI); Hybrid; USD 140,000 - 180,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

401(k)

Employee stock program

Education reimbursement

Performance bonuses

Wellness program

Job summary

Wade Trim seeks a Senior IT Data Architect to join its IT team in Taylor, Michigan. The role requires at least five years in data architecture, data engineering, or related data platform roles, and a bachelor’s degree. Strong SQL, data modeling, and data integration experience are essential, with Azure and Microsoft Fabric expertise.

A hybrid remote option after 30 days is available. Responsibilities include designing enterprise data models, defining data pipelines, and enabling analytics, AI,

Qualifications

• 5+ years of experience in data architecture, data engineering, database design, enterprise application integration, or related data platform roles.
• Strong SQL, data modeling, database design, and data integration experience is required.
• Experience with Azure and Microsoft Fabric is required.
• Experience with SQL and NoSQL databases is required.
• Experience with Enterprise Data Architecture is required.
• Experience with Data Modeling, Semantic Modeling & Integration Design is required.
• Experience with Business and Application Data Requirements Translation is required.
• Understanding of data pipelines, semantic models, APIs, ETL/ELT patterns, and model-ready data preparation is required.
• Strong communication skills with the ability to explain data architecture concepts to technical and non-technical stakeholders is required.
• Cross-Functional Collaboration is required.
• Strategic Thinking & Problem Solving is required.
• Exposure to the Architecture, Engineering, and Construction (AEC) industry is preferred.

Responsibilities

• Develop a roadmap for data projects in conjunction with the business units.
• Design and maintain enterprise data models, integration patterns, and architecture standards that unify data across Wade Trim databases and enterprise applications.
• Provide curated, governed, and model-ready datasets that support Development team solutions, Citizen Development initiatives, analytics, automation, AI, and model development.
• Collaborate with Data Engineers to define source-to-target mappings, data pipelines, semantic models, and reusable data assets.
• Translate business and application needs into scalable data architecture requirements, data models, and integration designs.
• Analyze structured and unstructured data sources to identify opportunities for standardization, consolidation, and reuse.
• Establish data quality expectations, validation rules, metadata standards, and lineage practices.
• Support dashboards, reports, applications, automations, and AI use cases by ensuring data is consistent, trusted, and accessible.
• Support development of repeatable data delivery and integration workflows.
• Develop data access protocols in conjunction with the business units.
• Maintain a safe working environment.

Skills

SQL

Data modeling

Data integration

Enterprise data architecture

Semantic modeling

Data requirements translation

Strong communication

Cross-functional collaboration

Strategic thinking

Problem solving

Education

Bachelor’s degree

Tools

Azure

Microsoft Fabric

Job description

Wade Trim seeks a Senior IT Data Architect to join its IT team in Taylor, Michigan. The role requires at least five years in data architecture, data engineering, or related data platform roles, and a bachelor’s degree. Strong SQL, data modeling, and data integration experience are essential, with Azure and Microsoft Fabric expertise.

A hybrid remote option after 30 days is available. Responsibilities include designing enterprise data models, defining data pipelines, and enabling analytics, AI,