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. If you are looking for a challenging and rewarding career in a friendly environment, please submit your resume by visiting the Careers section of our website at wadetrim.com . Wade Trim does not accept unsolicited resumes, candidate profiles, or CVs from third-party recruiters or employment agencies. Any submission made without a valid, signed agreement and an approved engagement request from Wade Trim’s People Services Team will be considered the property of Wade Trim. Wade Trim reserves the right to pursue and hire any candidate submitted through unsolicited means without any financial obligation to the recruiter or agency. A valid agreement can only be signed by the Director of People Services. Resumes or candidate profiles submitted at the request of a Wade Trim employee who is not authorized by the People Services team do not constitute a valid engagement. Recruiters and agencies must have a current, written agreement authorized by the Director of People Services to be considered an approved vendor. Wade Trim is an Affirmative Action/Equal Opportunity Employer.

Requirements

Must-haves

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
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

Nice-to-haves

Exposure to the Architecture, Engineering, and Construction (AEC) industry is preferred

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlaiazure

Platform: lever
Effort: quick

Benefits

Benefits detected in the listing.

Dental

Vision

401(K)

Wellness

Professional Development