Data Platform Architect (Data 360)
Posted 1
view
Summary
Remote consulting role at Coastal Cloud: own end-to-end technical solution design centered on Salesforce Data 360 (D360), building ingestion/streaming pipelines, identity resolution, and lakehouse/warehouse integrations for clients. Requires 5+ years in cloud data architecture plus SQL, Python, and Salesforce dev skills.
Data Platform Architect (D360)
We are looking for a Data Platform Architect to help us support our continued growth. The Data Platform Architect is responsible for owning the overall design of the technical solution as well as recommending best practice solutions based on client needs. They provide technical guidance to the development of Salesforce.com and other SaaS applications to support business and product strategies, with a heavy emphasis on maximizing the Salesforce Data 360 (D360) ecosystem.
A Data Platform Architect facilitates discovery sessions to understand client processes and challenges and translates findings into technical requirements supported by a documented solution design. They provide thoughtful leadership and communication to project and client team members in order to build the foundation as a trusted partner.
Role Responsibilities:
We are looking for a Data Platform Architect to help us support our continued growth. The Data Platform Architect is responsible for owning the overall design of the technical solution as well as recommending best practice solutions based on client needs. They provide technical guidance to the development of Salesforce.com and other SaaS applications to support business and product strategies, with a heavy emphasis on maximizing the Salesforce Data 360 (D360) ecosystem.
A Data Platform Architect facilitates discovery sessions to understand client processes and challenges and translates findings into technical requirements supported by a documented solution design. They provide thoughtful leadership and communication to project and client team members in order to build the foundation as a trusted partner.
Role Responsibilities:
- Data Architecture Design:
- Enterprise D360 Harmonization: Develop and implement data architectures that align with business needs and leverage Salesforce Data 360 (D360) capabilities for unified profile management, data democratization, and real-time activation.
- Modern Cloud Integration: Design and implement data solutions that bridge enterprise cloud data platforms (Data Lakes/Warehouses) with the Salesforce ecosystem to address specific business needs, such as Business Intelligence (BI), ETL/ELT, and AI/ML.
- Legacy Migration: Assist with the migration, ingestion, and mapping of customer data from legacy systems and siloed databases into the Salesforce D360 platform.
- Governance & Trust: Ensure data accessibility, data privacy, granular security controls, and compliance with relevant regulations (e.g., GDPR, CCPA) and industry standards within the customer data ecosystem.
- Data Modeling & Pipeline Design:
- Ingestion & Streaming Pipelines: Design and implement real-time streaming and batch data pipelines for ingesting, transforming, and loading high-volume enterprise data into Salesforce D360 from various cloud sources and APIs.
- D360 Identity Resolution: Design and implement scalable data models and metadata architectures within Salesforce D360, expertly defining identity resolution rules, reconciliation rules, and unified data graphs.
- Performance Optimization: Monitor and optimize query performance, calculated insights, identity resolution runs, and data transformation processes within the Salesforce D360 and underlying lakehouse environment.
- Technical Leadership and Collaboration:
- Cross-Functional Collaboration: Collaborate with key stakeholders—including business users, data engineers, data scientists, and CRM IT teams—to understand requirements and deliver unified data solutions.
- Ecosystem Evaluation: Evaluate and select appropriate tools, connectors, and zero-copy/Zero-Data-Movement technologies for seamless data integration, transformation, and activation within the Salesforce D360 ecosystem.
- Technical Guidance: Provide technical leadership, architectural oversight, and best-practice guidance to data engineering and CRM development teams.
Experience/Skills Required:
- 5+ years of experience in solutions architecture or technical consulting for cloud data platforms with multiple enterprise workstreams.
- Deep Understanding of Salesforce D360 (Data Cloud) Architecture & Capabilities: Expert knowledge of the data model (DMOs, DSOs), identity resolution, data spaces, calculated insights, and activation targets.
- Data Modernization Advocate: Passionate about modern data architecture methods, including lakehouse architecture, zero-copy data sharing, and real-time data activation.
- Broad Data Ecosystem Experience: Comprehensive range of experience in enterprise database technology, cloud data warehouses (e.g., Snowflake, Databricks), ETL/ELT tools, data engineering pipelines, and data science principles.
- Elite Communication: Strong verbal and presentation abilities, capable of effectively communicating complex data architecture concepts to stakeholders and prospective clients at all levels of an organization.
- Strategic Roadmap Leadership: Demonstrable experience leading strategy and digital roadmap projects in a complex business environment. Proven ability to guide clients toward optimal standard solutions when initial custom designs are not a fit.
- Technical Tooling & Development: Experience with data-centric programming languages (such as SQL and Python) as well as Salesforce application development components (Apex, Flow, LWCs, MuleSoft).
- Advanced Architecture Patterns: Deep understanding of enterprise architecture patterns, API management, and real-time data streaming technologies (e.g., Kafka, Amazon Kinesis).
- Structured Data Modeling: Mastery of data modeling methodologies (such as Kimball dimensional modeling, Star/Snowflake schemas, or Medallion Bronze/Silver/Gold structures) and how they map into a canonical Customer 360 model.
- US Authorization: Must have full-time permanent US work authorization.
Additional Preferred Experience/Skills:
- Bachelor’s Degree preferred, or equivalent experience.
- Salesforce Certified Data Cloud Consultant or Accredited Professional designations.
- Hands-on experience with core Salesforce CRM technology like Sales Cloud, Service Cloud, or Industry Clouds (e.g., Financial Services Cloud, Health Cloud).
- Hands-on experience deploying AI/ML solutions like Salesforce Einstein, AWS Sagemaker, or Google Vertex AI, alongside a solid understanding of Generative AI patterns (e.g., Retrieval-Augmented Generation / RAG).
- Experience designing data architectures on cloud platforms like Amazon Web Services, Microsoft Azure, or Google Cloud Platform.
- Hands-on expertise with analytics and visualization tools like Tableau, CRM Analytics, PowerBI, or Looker.
- Open to travel based on client and business demands.
Why Coastal, and what we offer:
- Flexible working hours with an emphasis on a life-work balance (in that order!)
- Remote flexible work; plus company office locations in Palm Coast, FL; Atlanta, GA; Tysons, VA & Lexington, KY; travel as required to client locations
- Unlimited Paid Time Off (RTO), 401K with Company Match, and Medical, Vision, & Dental coverage
- Competitive quarterly bonus opportunities
- Continuing education and certification reimbursements, specifically within the Salesforce and Snowflake ecosystems; plus occasional in-house competitions with spot bonuses
- A flexible and fun team culture! We value transparency, support, flexibility, growth, teamwork, fun, and so much more
- Frequent team and culture activities, virtual & in-person, including Lunch and Learns, Happy Hours, team-building events
- Monthly All-Hands calls to bring the company together, and an open-door leadership policy with access to mentorship and guidance
- Opportunities for accelerated growth, networking, and career guidance and support
- Trust, transparency and respect across all levels of the company
Coastal provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.
Skills
- Accessibility
- AI
- Analytics
- Apex
- API
- AWS
- Azure
- Ccpa
- Cloud
- CRM
- Data Engineering
- Data Modeling
- Data Pipelines
- Data Science
- Databricks
- Dimensional Modeling
- ELT
- ETL
- GCP
- Gdpr
- Generative AI
- Kafka
- Kinesis
- Lakehouse
- Looker
- Machine Learning
- Mulesoft
- Networking
- Power BI
- Python
- RAG
- SaaS
- SageMaker
- Sales Cloud
- Salesforce
- Snowflake
- Solution Design
- SQL
- Tableau
- Vertex AI