Data Architect (Remote, Contract)

Position Overview

The Data Architect leads the design and delivery of secure, scalable data architectures that support enterprise digital marketing and customer experience solutions. The role defines data strategy, data models, SQL-based solutions, and governance practices to unify customer information across Adobe platforms and cloud environments, enabling trusted profiles, segmentation, journeys, and campaigns.

Working closely with clients, data engineers, and cross-functional teams, this consultant evaluates source systems and data flows, designs ingestion and integration approaches, and guides implementation of Adobe Experience Platform (AEP) capabilities. The role also supports performance optimization, large-scale data migration, data quality, security, and regulatory compliance.

Location: Remote - United States Please note this is a contract role.

Key Responsibilities

Data Strategy, Architecture & Modeling

• Design secure, scalable data solutions across Adobe products and cloud platforms, aligned with enterprise data strategy and client business objectives.
• Lead customer data discovery, assessing source systems, business processes, data movement, granularity, relationships, and formats.
• Unify sales, CRM, analytics, and other customer data; develop conceptual, logical, and physical data models for multi-solution delivery.
• Define strategic data architecture blueprints and collaborate with cross-disciplinary teams to resolve technical challenges and integration constraints.

Data Governance, Security & Quality

• Apply standards and frameworks for data quality, master data management, data services, governance, modeling, security, and privacy.
• Address applicable regulatory and sensitive-data requirements, including PII, PCI, HIPAA, and GDPR considerations.
• Ensure solutions follow platform guardrails and support growing data volumes, tools, and integration needs.

Adobe Experience Platform & Data Integration

• Build Adobe platform data lake and real-time customer profile foundations to support ingestion and activation.
• Design batch and streaming ingestion for online and offline data in AEP, partnering with data engineers on ETL/ELT collection and extraction pipelines.
• Use REST APIs, Postman, and scripting to automate implementation and configuration activities.
• Optimize query performance and model design across platforms, following technical guidelines and product constraints.
• Plan and drive large-scale data migration, transformation, and modernization while protecting data quality, integrity, and compliance.

Required Skills & Experience

Data Architecture & Technical Expertise

• 10+ years of experience in data architecture, data modeling, SQL, and customer-facing work.
• Expertise designing customer-centric database models and datasets spanning CRM, call center, marketing, offline, point-of-sale, and related systems.
• Strong knowledge of relational and hierarchical data approaches, including RDBMS, columnar systems, data warehouses, BI, document and semantic models, data lakes, and OLTP/OLAP.
• Advanced SQL development skills, including functions, transformations, arrays, joins, stored procedures, and data analysis.
• Experience translating business requirements and data workflows into scalable architecture through structured analysis.
• Hands-on use or administration of Adobe Experience Platform (AEP), including available AI tools.
• Experience with Python or Bash scripting and planning or executing large-scale data migrations.

Consulting, Domain Knowledge & Education

• Degree in Computer Science, Information Systems, Data Science, or a related field, or equivalent experience.
• Strong organization, verbal and written communication, and the ability to balance multiple customer projects.
• Deep knowledge of at least one relevant industry, such as retail, telecommunications, healthcare, automotive, cloud, or streaming platforms.

Preferred Skills & Experience

• Real-Time Customer Data Platform (RTCDP) certification.

Role Expectations

• Provide technical leadership and client-facing guidance across data architecture, modeling, integration, migration, governance, and implementation activities.
• Partner with Adobe and customer teams to resolve complex data challenges while maintaining secure, scalable, reliable solutions aligned with business and platform requirements.

About Blue Acorn iCi

Blue Acorn iCi, a business unit of Infosys Nova Holdings, LLC, is a digital experience partner helping global brands design, build, and optimize the future of customer engagement. We blend data, design, and technology to deliver connected commerce and content solutions that drive measurable results.

Specializing in the Adobe Experience Cloud, we provide end-to-end services across commerce, content, analytics, and customer insights. Backed by Infosys, we’re growing fast - and we’re looking for exceptional talent to grow with us.

Our teams work at the intersection of strategy and execution - solving complex challenges for industry leaders in healthcare, retail, manufacturing, and beyond. From large-scale digital transformation programs to platform implementations and ongoing optimization, we bring deep expertise and a collaborative mindset to every engagement.

Why Join Us?

Blue Acorn iCi is a place for curious thinkers, smart builders, and digital pioneers. We’re more than a consultancy - we’re a team of innovators helping the world’s top brands shape the future of digital.

Here, you won’t just contribute to a project - you’ll drive meaningful outcomes, collaborate with cross-disciplinary teams, and grow your skills in a high-impact, high-growth environment. We believe great work starts with great people, and we’re committed to creating a culture where talent thrives, ideas spark change, and results speak for themselves.

If you’re ready to push boundaries, deliver real value, and help shape the next generation of digital experiences - this is your place.

***For US based roles, candidates must have unrestricted authorization to work in the United States without the need for employer sponsorship now or in the future. Infosys Nova Holdings, LLC does not provide immigration or visa sponsorship for this position (including H4 EAD, H‑1B, OPT, CPT, TN, O‑1, E‑3, or J‑1 visas).***

Full Time, Non-Temporary Employees enjoy a competitive benefits package that includes medical, dental and vision insurance, life insurance, disability, paid time off, 401(k), and more!

Blue Acorn iCi is an equal opportunity employer and all qualified applicants will receive consideration without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, spouse of protected veteran, or disability.

Please click to read EEO Law and Pay Transparency Act and IER Right to Work Document and Privacy Notice.

Blue Acorn iCi will endeavor to make a reasonable accommodation to the known physical or mental limitations of a qualified applicant with a disability unless the accommodation would impose an undue hardship on the operation of our business. If you believe you require such assistance to complete this form or to participate in an interview, please contact us at: careers@blueacornici.com.

California applicants: Please click here for CCPA disclosures.