Data Architect

Data Architect

Remote

Long Term Contract

As a Data Architect consultant for the client, you will lead or support the development of advanced, secure data solutions for our innovative digital marketing platforms. Need to craft data strategy, architecture, SQL and governance for customer solutions, including end-to-end profiles, segmentation, journeys, and campaigns!

What You'll Do

• Provide deep experience to build data relocations across multiple client products and cloud platforms aligned with enterprise data strategy.
• Engage closely with customers and client team to facilitate data discovery by evaluating systems and business processes. Analyze customer sources, data movement, data granularity, relationships, data format, etc.
• Unify disparate data (e.g., sales, CRM, analytics data, etc.) to meet customers' digital marketing use cases. Lead and develop conceptual, logical, and physical data models for multi-solution delivery.
• Showcase and follow frameworks for data quality, define standards, master data management, data services, data governance, data modeling, tools, data security, privacy, and compliance with industry regulations (PII, PCI, HIPAA, GDPR, etc.).
• Engage with cross-disciplinary groups and Client professionals to identify customer demands. Provide data layout and strategic blueprints, advocating for scalable, secure resolutions. Assume the role of a liaison to promptly tackle technical obstacles.
• Provide solutions for growing data volumes, tools, and integrations, while aligning with customers' objectives.
• Deliver Adobe platform data lake and real-time customer profile to get ready for data ingestion and activation. Employ REST APIs, Postman, and basic scripting to automate and streamline the implementation and setup.
• Develop and construct data ingestion solutions for streaming and batch processing, online and offline data within AEP. Collaborate with data engineers to develop and implement ETL/ELT pipelines for data collection and extraction.
• Improve data query performance across platforms by tuning models and adhering to guidelines and ensure product guardrails are followed and deployed in solutions
• Drives end-to-end data migration initiatives, transforming and migrating large-scale datasets while maintaining data quality, integrity, and compliance.

Requirements

• Degree in Computer Science, Information Systems, Data Science, or a related field or equivalent experience.
• 10+ years of data architecture, modeling, SQL, and working with customers!
• Expert proficiency in crafting customer-centric database models, datasets (e.g., CRM, Call Center, Marketing, Offline, Point of Sale, etc.) with relational, hierarchical (e.g., RDBMS, Columnar, Data Warehouse, BI, Document, Semantic layer modeling, Data Lakes, OLTP & OLAP, etc.).
• Advanced skills in SQL development (e.g., functions, data transformations, arrays, joins details, stored procedures, data analysis).
• Deep experience in translating business requirements into scalable data architecture by conducting structured analysis of data workflows and processes
• Demonstrate outstanding organizational skills and ability to balance customer projects concurrently with strong verbal, written communication skills and previous experience with customer-facing engagements
• Hands-on use or administration of Client Experience Platform (AEP) including the available AI tools
• Deep domain expertise in one or more industries (Retail, Telecom, Healthcare, Automotive, Cloud and Streaming platforms, etc.)
• Experience with programming languages (e.g., Python or Bash scripting)
• Experience in planning and executing large-scale data migrations, enabling organizations to modernize systems and unlock trusted, actionable data.
• Good to have RTCDP certification