Blue Acorn iCi Logo

Blue Acorn iCi

Data Architect (Remote, Contract)

Posted 16 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.

Similar Jobs

23 Minutes Ago
Remote
California, USA
49K-77K Annually
Junior
49K-77K Annually
Junior
Aerospace • Information Technology • Software • Cybersecurity • Design • Defense • Manufacturing
Maintains and repairs factory machinery and industrial equipment on a third shift, including troubleshooting mechanical, hydraulic, pneumatic, electrical, and electronic systems. Develops preventative maintenance plans, performs inspections, rebuilds, modifications, and testing, interprets schematics, manages replacement-part inventories, responds to repair requests, and follows safety procedures. The position is fully onsite in Sylmar, California and requires U.S. person status for export-control compliance.
Top Skills: Automated Handling EquipmentBlueprintsElectrical SystemsElectronic ComponentsHydraulicsIndustrial MachineryLaser EquipmentMechanicsPneumaticsRobotic EquipmentScba Supplied-Air EquipmentSchematic DiagramsSemiconductor Processing EquipmentThermal ChambersVacuum Systems
27 Minutes Ago
In-Office or Remote
United States
90K-105K Annually
Mid level
90K-105K Annually
Mid level
Big Data • Information Technology • Software • Analytics • Energy
Administers and analyzes sales compensation programs, including commission payout processing, data auditing, dispute resolution, plan modeling, reporting, and dashboard maintenance. Partners with sales, finance, and HR stakeholders to ensure accurate, compliant compensation operations and support plan improvements. Requires strong Excel modeling, CRM and incentive compensation platform experience, analytical ability, communication skills, and independent judgment.
Top Skills: CaptivateiqExcelPerformioSalesforceVaricentXactly
29 Minutes Ago
Remote or Hybrid
ME, USA
17-25 Hourly
Entry level
17-25 Hourly
Entry level
Artificial Intelligence • Automotive • Greentech • Information Technology • Machine Learning • Software • Cybersecurity
Processes, codes, audits, indexes, and rebills invoices for fleet services. Contacts service providers about discrepancies, verifies approval limits, completes workflow steps, handles purchase order inquiries, and performs VMRS coding and costing. The role requires accurate, high-volume data entry, strong attention to detail, and effective communication in a fast-paced billing environment.
Top Skills: TmcareVmrs

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account