Data Architect

This is a fully remote position, open to applicants in United States.

📋 Description

• Design secure and scalable data solutions across Adobe products and cloud platforms, ensuring alignment with enterprise data strategy and client business objectives.

• Lead the discovery of customer data by evaluating source systems, business processes, data movement, granularity, relationships, and formats.

• Integrate sales, CRM, analytics, and other customer data into a cohesive framework.

• Create conceptual, logical, and physical data models for the delivery of multiple solutions.

• Define strategic blueprints for data architecture.

• Collaborate with cross-disciplinary teams to address technical challenges and integration limitations.

• Implement standards and frameworks for data quality, master data management, data services, governance, modeling, security, and privacy.

• Address regulatory and sensitive data requirements, including considerations for PII, PCI, HIPAA, and GDPR.

• Ensure solutions adhere to platform guidelines and accommodate increasing data volumes, tools, and integration needs.

• Build data lake and real-time customer profile foundations on the Adobe platform to support data ingestion and activation.

• Design batch and streaming ingestion processes for both online and offline data in AEP.

• Collaborate with data engineers on ETL/ELT collection and extraction pipelines.

• Utilize REST APIs, Postman, and scripting to automate implementation and configuration tasks.

• Enhance query performance and model design across various platforms.

• Plan and lead large-scale data migration, transformation, and modernization initiatives while ensuring data quality, integrity, and compliance are maintained.

• Provide technical leadership and client-facing guidance across architecture, modeling, integration, migration, governance, and implementation.

• Work alongside Adobe and customer teams to navigate complex data challenges while delivering secure, scalable, and reliable solutions.

⛳️ Requirements

• Unrestricted authorization to work in the United States without the need for employer sponsorship, either now or in the future.

• Over 10 years of experience in data architecture, data modeling, SQL, and customer-facing roles.

• Proven expertise in designing customer-centric database models and datasets that encompass CRM, call center, marketing, offline, point-of-sale, and related systems.

• Strong understanding of relational and hierarchical data methodologies, including RDBMS, columnar systems, data warehouses, BI, document and semantic models, data lakes, and OLTP/OLAP.

• Advanced skills in SQL development, including functions, transformations, arrays, joins, stored procedures, and data analysis.

• Experience in translating business requirements and data workflows into scalable architecture through structured analysis.

• Hands-on experience with or administration of Adobe Experience Platform (AEP), including its available AI tools.

• Proficiency in Python or Bash scripting.

• Experience in planning or executing large-scale data migrations.

• A degree in Computer Science, Information Systems, Data Science, or a related field, or equivalent experience.

• Strong organizational abilities and excellent verbal and written communication skills.

• Capacity to manage multiple customer projects simultaneously.

• In-depth knowledge of at least one relevant industry, such as retail, telecommunications, healthcare, automotive, cloud, or streaming platforms.

• Preferred: Certification in Real-Time Customer Data Platform (RTCDP).

🏝️ Benefits

• Medical, dental, and vision insurance.

• Life insurance.

• Disability insurance.

• Paid time off.

• 401(k).

• Competitive benefits package available for full-time, non-temporary employees.