Lead Data & Solutions Architect

MRE Consulting, Ltd.; Houston (TX); On-site; USD 140,000 - 190,000; Full time

Job summary

MRE Consulting’s Data Strategy & Cloud Enablement practice is seeking a Lead Data & Solution Architect to serve as a senior technical authority across client engagements, spanning multi-system integrations, data management platform implementations, and key data initiatives.

In this client-facing role, you will translate ambiguous business needs into technical roadmaps, design data platforms, and provide architectural guidance to sales and delivery teams across engagements.

Qualifications

• 10+ years in data architecture, data engineering, or solution architecture roles, with lead capacity.
• Experience across multi-system integrations and data platform implementations.
• Strong communication skills for client-facing and sales conversations.

Responsibilities

• Lead architecture and design of data platforms, integration strategies, and analytics solutions for client engagements.
• Design, enhance, and modify enterprise data warehouses to support analytics and BI needs.
• Build ETL/ELT pipelines to support data integration, migration, and analytics initiatives.
• Serve as senior technical resource in pre-sales and scoping conversations with stakeholders.
• Design data architectures for M&A integration, including consolidation and harmonization.
• Architect data solutions for investment firms (portfolio data, reporting, operations).
• Apply AI tools to enhance data platform delivery and governance.
• Develop data governance, quality standards, and modeling practices.
• Work with APIs to manage and monitor data flows across systems.
• Design and build data pipelines using Boomi, Celigo, Workato, or MuleSoft.
• Architect near-time, real-time, and streaming data solutions for low-latency analytics.
• Oversee delivery teams, provide architectural guidance and QA.
• Produce client-ready architecture diagrams and executive roadmaps.
• Stay current on data platforms, AI tooling, and practice development.
• Mentor junior architects and engineers.

Skills

Data architecture

Data engineering

Solution architecture

ETL/ELT pipelines

Data governance

Cloud platforms

AI / generative AI

Pre-sales / client-facing

Mentoring

Event-driven architecture

Tools

Boomi

Celigo

Workato

MuleSoft

Job description

Role Overview

MRE Consulting’s Data Strategy & Cloud Enablement practice - part of our Project Delivery Services division - is seeking a Lead Data & Solution Architect to serve as a senior technical authority across client engagements, spanning multi-system integrations, data management platform implementations, and key data initiatives. This is a client-facing, firsthand architecture role: you will design data platforms and solutions, translate ambiguous business problems into technical roadmaps, and function as the trusted technical voice in sales and delivery conversations alongside our consulting leads.

This role suits someone who is equally comfortable in a team whiteboarding session, strategy session with a client’s CTO, CIO, or CDO, and in the granularity of a data model or pipeline design - and who enjoys the variety of a boutique consulting environment where every engagement looks different.

Key Responsibilities

Lead the architecture and technical design of data platforms, data integration strategies, and analytics solutions for client engagements.

• Design, enhance, and modify enterprise data warehouse environments to support evolving client analytics, reporting, and business intelligence needs.
• Design, build, and optimize ETL/ELT pipelines to support data integration, migration, and analytics initiatives across client environments.
• Serve as the senior technical resource in pre-sales and scoping conversations, partnering with practice leadership, and accounting teams to shape solutions and estimate delivery approaches.
• Design data architectures supporting M&A integration efforts, including data consolidation, migration, and harmonization across disparate source systems.
• Architect data solutions tailored to the needs of investment firms (e.g., portfolio data aggregation, deal data management, reporting/analytics for fund operations)
• Apply AI and generative AI tools to enhance data platform delivery - e.g., AI-assisted data engineering, automated data quality and documentation, and Copilot-style development acceleration - ensuring data foundations are fit for purpose.
• Develop data governance, data quality, and data modeling standards and advise clients on adoption.
• Comfortable working with APIs to manage, build and monitor data flows across integrated systems.
• Design and build data pipelines using integration platforms such as Boomi, Celigo, Workato, or MuleSoft
• Architect near-time, real-time and streaming data solutions using event-driven and pub/sub patterns to support low-latency analytics and reporting.
• Oversee technical delivery teams during implementation, providing architectural guidance and quality assurance.
• Produce client-ready architecture diagrams, technical roadmaps, and executive-level presentations.
• Stay current on emerging data platforms, integration, and AI tooling, and bring point-of-view to clients and internal practice development.
• Mentor junior architects and engineers within the practice.

Solution Areas You’ll Deliver

As Lead Data & Solution Architect, you will design and lead delivery across the following practice offerings:

• Data Integration / Migration (+ Analysis): Source-to-target analysis, integration design, and migration execution across complex, multi-system environments
• Data Governance Implementation: Standing up governance frameworks, stewardship models, and policy enforcement for clients.
• Data Warehousing / Data Lakehouse Strategy: Designing warehouse and lakehouse architectures, including but not limited to Medallion structure (bronze/silver/gold layering)
• Master Data Management (MDM): Leading end-to-end MDM offerings - domain modeling, match/merge strategy, stewardship workflows, and platform implementation
• Data Analytics & Reporting / Real-Time Analytics & Dashboards: Designing analytics architectures and real-time, streaming-based dashboard/reporting solutions
• Power Platform: Architecting solutions using PowerApps, Power BI, Power Query, and related Microsoft Power Platform tools
• Platform & Software Evaluation & Selection: Leading client stakeholders through evaluation and selection processes for applications, tools, and platforms - including data platform/tool evaluations and vendor selection
• System Integration: Architecting integration between disparate client systems as part of broader data or platform initiatives
• Data Security & Compliance: Designing data protection, access control, and privacy/compliance safeguards appropriate to regulated client environments

Preferred Experience

• 10+ years in data architecture, data engineering, or solution architecture roles, with several years in a lead or principal capacity
• Prior