Data Architect Consultant

Blue Acorn iCi

AEP Data Architect Consultant at Blue Acorn iCi partnering with clients on Adobe Experience Platform data strategies. Leading architectural decisions and optimizing client investments.

Posted 7/23/2026full-timeRemote • 🇺🇸 United StatesSeniorLead💰 $135,000 - $185,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates extensive expertise in enterprise data architecture, including ETL/ELT processes, data modeling, and cloud-based data solutions. Proven ability to mentor teams, manage client engagements, and provide strategic guidance on Adobe Experience Platform and data governance.

Highest-signal resume keywords

Enterprise Data ArchitectureETL/ELT ProcessesAdobe Experience PlatformSQL and NoSQL Data ModelingData Governance Standards

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

ETL/ELTData ModelingSQLNoSQLEnterprise Data WarehousingDataOps PracticesXDM Schema DesignIdentity Resolution StrategiesData Quality FrameworksGDPR/CCPA Compliance

Soft Skills

Business Requirements GatheringOrganizational SkillsCommunication SkillsMentoringProactive Customer Focus

Tools & Technologies

Adobe Experience PlatformAzure Cloud Technologies

Industry Keywords

Data GovernanceCustomer 360Data Lifecycle ManagementLarge-Scale Data ProcessingTechnical Architecture

Tech Stack

Tools & technologies

AzureCloudETLNoSQLSQL

About the role

Key responsibilities & impact

Lead client discovery sessions to gather business and technical requirements, define project scope, and manage stakeholder expectations throughout engagements.
Provide strategic guidance on Adobe Experience Platform adoption, enterprise data strategy, and solution architecture.
Partner with clients to assess data maturity and recommend scalable architecture solutions aligned with business objectives.
Serve as a trusted advisor by translating complex technical concepts into actionable recommendations for both technical and non-technical stakeholders.
Review and validate enterprise data architectures, XDM schema designs, identity resolution strategies, activation plans, and technical specifications.
Provide recommendations across the entire data lifecycle, including data ingestion, ETL/ELT processes, transformation, governance, quality, archival, and lifecycle management.
Guide customer identity mapping and Customer 360 initiatives through effective SQL and NoSQL data modeling strategies.
Promote enterprise data governance standards and repeatable best practices across Adobe Experience Platform implementations.
Review technical design documents and architecture specifications to ensure alignment with Adobe best practices and enterprise standards.
Mentor Data Architects and cross-functional engineering teams by providing architectural oversight and technical leadership.
Collaborate with software engineering consultants, data scientists, and delivery teams to guide scalable data workflows and machine learning operationalization.
Act as the senior data architecture advisor across multiple client engagements, ensuring technical excellence throughout project delivery.
Successfully manage multiple client engagements while balancing competing priorities and maintaining project governance.
Contribute reusable templates, playbooks, frameworks, and Center of Excellence initiatives that strengthen the Adobe consulting practice.
Develop client-facing documentation, presentations, architecture recommendations, and implementation guidance.
Maintain accurate project documentation, workload estimates, and project tracking throughout engagements.
Stay current on Adobe Experience Platform capabilities, Azure cloud technologies, and emerging enterprise data architecture trends.
Identify opportunities to improve delivery methodologies and recommend innovative solutions that address evolving client needs.
Continuously expand technical expertise while contributing knowledge and best practices across the consulting organization.

Requirements

What you’ll need

7+ years of experience in enterprise data architecture with expertise in ETL/ELT, large-scale data processing, and enterprise data strategy.
5+ years of experience designing data models across relational, dimensional, columnar, and big data environments.
Experience working with Adobe Experience Platform (AEP), including XDM schema design and identity resolution strategies.
Strong expertise in SQL, NoSQL, enterprise data warehousing, and cloud-based data architecture.
Experience designing customer-centric datasets spanning CRM, marketing, call center, point-of-sale, and offline data sources.
Strong understanding of DataOps practices, enterprise data governance, GDPR/CCPA compliance, and data quality frameworks.
Experience reviewing technical architecture documents, solution designs, and data models while providing strategic recommendations.
Proven ability to mentor technical teams and provide architectural guidance across complex enterprise initiatives.
Strong business requirements gathering and structured analysis skills, with the ability to communicate technical concepts to both technical and non-technical audiences.
Demonstrated ability to manage engagement scope, govern project boundaries, and align client expectations to defined deliverables.
Exceptional organizational skills with the ability to manage multiple concurrent client engagements in a fast-paced consulting environment.
Self-managed, proactive, customer-focused, and capable of delivering high-quality work independently.

Benefits

Comp & perks

Medical, dental and vision insurance
Life insurance
Disability
Paid time off
401(k)