Blue Acorn iCi Logo

Blue Acorn iCi

Data Architect (Remote, Contract)

Posted 18 Days Ago
Remote
Hiring Remotely in United States
Expert/Leader
Remote
Hiring Remotely in United States
Expert/Leader
Leads secure, scalable customer data architecture across Adobe Experience Platform and cloud environments. Designs data strategies, models, governance frameworks, ingestion and integration solutions, migrations, and real-time customer profiles. Partners with data engineers, Adobe, and clients to address data quality, security, privacy, performance, and regulatory requirements. Uses SQL, scripting, APIs, and Postman to support implementation and automation while providing technical leadership across multiple customer projects.
The summary above was generated by AI
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.

Blue Acorn iCi New York, New York, USA Office

261 Madison Ave, 8th Floor, New York, NY, United States, 10016

Similar Jobs

46 Minutes Ago
Remote or Hybrid
45K-85K Annually
Junior
45K-85K Annually
Junior
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Handles inbound calls and warm leads, consults customers on insurance needs, recommends appropriate coverages and products, and converts leads into policyholders. The role includes paid training and Property & Casualty licensing support, customer relationship management, sales conversion, and representing the Liberty Mutual brand. Employees work remotely on a fixed weekday and weekend schedule and must maintain a dedicated home workspace with reliable wired internet.
Top Skills: Cable InternetDsl InternetFiber InternetPcWired High-Speed Internet
47 Minutes Ago
Remote or Hybrid
125K-177K Annually
Senior level
125K-177K Annually
Senior level
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Owns product vision, strategy, roadmap, backlog, prioritization, and delivery for a workers compensation transformation program. Partners with business and technology stakeholders, leads Agile ceremonies, defines actionable user stories, manages KPIs, resolves delivery barriers, evaluates costs and feasibility, and ensures compliance with industry constraints. Drives customer-focused design, usability testing, stakeholder alignment, and value delivery across squads and portfolios.
Top Skills: Agile
54 Minutes Ago
In-Office or Remote
East Brunswick, NJ, USA
29-52 Hourly
Junior
29-52 Hourly
Junior
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Coordinates nursing home-to-community transitions for Medicaid members. Supports applications, documentation, transportation, housing placements, household needs, and state reporting. Collaborates with members, care managers, nursing facilities, housing providers, and community organizations; monitors transition progress and ensures timely follow-up. Requires experience serving behavioral health or long-term-care populations, community provider knowledge, Microsoft Office proficiency, regional travel, a driver’s license, and reliable transportation.
Top Skills: ExcelMS OfficeMicrosoft OutlookMicrosoft Word

What you need to know about the NYC Tech Scene

As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.

Key Facts About NYC Tech

  • Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
  • Key Industries: Artificial intelligence, Fintech
  • Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
  • Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account