Senior IT Data Architect - #3003

Wade Trim; Taylor (MI); Hybrid; USD 110,000 - 170,000; Full time

Benefits offered by this job

401(k)

Performance bonuses

Employee stock program

Education reimbursement

Hybrid schedule

Job summary

Wade Trim is seeking a Senior IT Data Architect to join our Taylor, Michigan-based IT team. The role requires at least five years in data architecture, data engineering, database design, and enterprise integration, with a BS in a related field and strong SQL skills.

You will develop data roadmaps, maintain enterprise data models, ensure data quality, and collaborate with Data Engineers to deliver scalable, model-ready datasets across Wade Trim's applications and analytics initiatives.

Qualifications

• Bachelor's degree in a data-related field is required.
• 10 years of experience in data management.
• 5+ years in data architecture/engineering/database design/enterprise integration.
• Strong SQL, data modeling, and data integration experience.
• 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.
• Excellent communication and cross-functional collaboration skills.
• AEC industry exposure preferred.

Responsibilities

• Develop a roadmap for data projects with business units.
• Design and maintain enterprise data models, integration patterns, and architecture standards.
• Provide curated, governed, model-ready datasets for development, analytics, and AI.
• Collaborate with Data Engineers on source-to-target mappings and data pipelines.
• Translate business needs into scalable data architecture requirements and designs.
• Analyze data sources to identify standardization opportunities.
• Establish data quality, metadata, and lineage practices.
• Support dashboards, reports, apps, automations, and AI use cases with trusted data.
• Develop repeatable data delivery and integration workflows.
• Develop data access protocols with business units.
• Maintain a safe working environment.

Skills

SQL

Data Modeling

Data Integration

Azure

Microsoft Fabric

NoSQL databases

Enterprise Data Architecture

Semantic Modeling

ETL/ELT

Stakeholder Communication

AEC domain

Education

Bachelor's degree in Data Architecture, Computer Science, Information Systems, Data Science, Engineering, or related field

Tools

Azure Data Factory

Microsoft Fabric

Job description

What We Offer:

Our excellent salary and benefits package includes medical, dental, vision, life insurance, short and long-term disability coverage, education reimbursement, 401(k), performance bonuses, and an employee stock program. Employee Resource Groups and Programs offered include the Young Professionals Group, Women at Wade Trim, Diversity, Equity and Inclusion, Professional Development, Leadership Development, Mentor Program, Sustainability Program, and Wellness Program.

Position Description:

We are looking for a Senior IT Data Architect to join our IT team in Taylor, Michigan. Candidates must be able to work out of the Taylor, Michigan office and should have at least five years of experience in data architecture, data engineering, database design, enterprise application integration, or related data platform roles. Candidates should also have a bachelor's degree in data architecture, computer science, information systems, data science, engineering, or a related field with strong SQL and applicable data integration experience. A flexible, hybrid remote schedule is available after 30 days of employment.

Typical responsibilities include:

• 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

Education:

• Bachelor's degree in Data Architecture, Computer Science, Information Systems, Data Science, Engineering, or related field is required

Skills/Experience

• 10 years of experience in data management
• 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

About Wade Trim:

Wade Trim is committed to maximizing the value of infrastructure investments. We've been solving complex engineering challenges for a century. We customize our work approach to fit each project using a collaborative, friendly style to deliver solutions our clients can stand behind.

Our supportive culture recognizes and strives to fulfill collective client, company, and individual needs. Mentoring and building skills of Wade Trim staff is a priority. Frequent interaction among staff is encouraged, company leadership is easily accessible, and opportunities are provided for staff to help shape the firm's future through strategic planning. Work/life balance is supported through a flexible, hybrid work schedule that brings team members together in the office at least three days a week and connects them virtually when working from home.

To solve our clients' toughest challenges, we've devoted ourselves to delivering innovative solutions. Our Office of Applied Technology (OAT) is dedicated to seeking new technologies or ways to apply existing technologies to enhance value to our clients and positively impact communities. All staff are encouraged to share ideas and suggestions for innovative technologies or processes to adopt. This open-minded approach enables us to advance technology, foster innovation, and stay ahead of our clients' needs.

Wade Trim's success is shared by the employees that make it happen. Since our beginning, our firm has been 100% employee owned. This cultivates an ownership mindset that benefits our work approach, collaborative culture, and ability to deliver client solutions. We believe employee ownership drives the sustainability and growth of our firm and provides all our employees with opportunities for financial success.

Wade Trim is an Acquittive Action/Equal Opportunity Employer.