Senior IT Data Architect

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

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

• 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 affirmative action/Equal Opportunity Employer.