Insurance Data Engineer Jobs in Farmington, MI (NOW HIRING)

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.

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.

• 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

• 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

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.