Data Architect/W2/USC-

Stellent IT LLC; United States; Remote; USD 120,000 - 180,000; Full time

Job summary

Stellent IT LLC is seeking a Data Architect for a remote contract on W2 in the United States. You will lead data strategy, architecture, SQL, and governance for customer solutions across enterprise marketing platforms.

Responsibilities include building end-to-end data models, integrating disparate data sources, ensuring data quality, privacy, and security compliance, and collaborating with clients to deliver scalable data solutions using AEP and related tools.

Qualifications

• Data architecture and modeling experience.
• Strong SQL proficiency.
• Customer-facing consulting experience.
• Adobe Experience Platform familiarity.
• Ability to lead secure, governed multi-solution data design.

Responsibilities

• Lead or support advanced, secure data solutions for digital marketing platforms.
• Craft data strategy, architecture, SQL and governance for customer solutions.
• Develop data models across multi-solution delivery.
• Define data quality standards, master data management, and data security practices.
• Collaborate with cross-functional teams to address customer needs and obstacles.
• Design data ingestion and ETL/ELT pipelines for streaming and batch data.
• Optimize query performance and ensure governance and compliance.

Job description

Data Architect

Remote

Contract on W2

USC

Core requirements:Data architecture, modeling and SQL; customer-facing consulting; hands‑on Adobe Experience Platform experience; ability to lead secure, governed multi‑solution data design

As a Data Architect consultant for 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 solutions 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 Client 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