Salesforce Data Cloud - Senior Business Consultant

About the role

We are seeking a Senior Business Consultant in Salesforce Data Cloud to join our Kelley Austin Perficient Salesforce Team. Perficient is an AI-First consultancy that partners with innovative enterprises to deliver real business results through AI.

Responsibilities

• Design and implement Data Cloud solutions including DLO/DMO mappings, data stream configuration, identity resolution, batch transforms, and activation.
• Architect ingestion patterns across batch, streaming, and API-based connectors, and know when to use each.
• Build and troubleshoot batch transforms, including diagnosing silent failures, write-mode conflicts, SQL dialect limitations, and NULL propagation issues.
• Define unified profile strategies: determine primary keys, hash key discipline, and how identity resolution resolves across source systems.
• Lead data modeling sessions with clients, establishing what belongs in the canonical data model vs. what stays in source-specific DLOs.
• Translate business requirements into technical design documents that a junior consultant can actually implement.
• Push back on requirements that are architecturally incoherent and propose alternatives with clear tradeoffs.
• Support pre-sales scoping on Data Cloud opportunities, including effort estimation and risk identification.

Qualifications

• 4+ years in data, analytics, CRM, or enterprise systems consulting, with at least 2 years hands-on in Salesforce Data Cloud or a comparable CDP (e.g., Segment, Adobe RTCDP, mParticle).
• Demonstrated experience with DLO-to-DMO mapping, data stream setup, and canonical data model design in Data Cloud.
• Solid understanding of identity resolution: how match rules work, ruleset ordering, and when unified profiles break in unexpected ways.
• Hands-on experience building batch transforms and debugging them, including familiarity with the platform's known limitations (zero-row output failures, UPSERT vs. OVERWRITE write modes, unsupported SQL operators).
• Comfortable reading and reasoning through SQL and JSON: you don't need to be a developer, but you need to understand what a query is doing and why it's returning wrong results.
• Experience working directly with clients in a delivery or advisory capacity, running working sessions, presenting design decisions, managing scope conversations.
• Able to produce clear technical documentation: data flow diagrams, field mapping specs, design decision logs.

Preferred / Nice To Have

• Salesforce Data Cloud Consultant certification (or actively pursuing).
• Experience with Salesforce Marketing Cloud or Personalization and how they consume Data Cloud segments and activations.
• Familiarity with Agentforce or Data Cloud's role in grounding AI agents with unified profile data.
• Experience integrating Data Cloud via MuleSoft, Boomi, or Celigo.
• Prior consulting firm experience (big 4, boutique SI, or similar).

What Makes Someone Successful Here

You are comfortable saying "that requirement doesn't make sense" and then explaining why, calmly, with alternatives. You can hold a whiteboard session with a client's data architect in the morning and write a field mapping spec in the afternoon. You know the difference between a platform limitation and a design mistake, and you've been burned by both enough to build that awareness into your delivery habits. You don't need a rigid process to stay organized. You do need the judgment to know when to escalate, when to just decide, and when to slow down and ask a better question.

Salary Range

The salary range for this position is $90,000 to $140,000. Please note that the salary range posted reflects the base salary only and does not include benefits or any variable compensation programs.

Benefits Overview

Information regarding the benefits available for this position are in our benefits overview.

Equal Employment Opportunity

We believe in developing a workforce that is as diverse and inclusive as the clients we work with. We’re committed to actively listening, learning, and acting to further advance our organization, our communities, and our future leaders… and we’re not done yet.

About Us

Perficient is the global AI and technology consulting firm disrupting the traditional consulting model. Powered by our 7,000+ advisors, engineers, and designers, Perficient implements AI-first solutions that break conventions and deliver outcomes that matter. Proudly serving clients that represent the world’s most innovative brands, and in collaboration with our powerful technology partner ecosystem, we bring deep industry expertise and data-driven design to redefine how businesses run and succeed.