Horizontal Digital is an experience-forward consultancy. So, what does this mean? We help organizations not only meet ever-increasing customer expectations but set the bar higher in the process. And we deliver on this promise by putting customers at the absolute center of everything we do, helping them build stronger possibilities with our clients in the process. Our solutions are driven by strategy, creativity and execution - powered by MuleSoft, Salesforce and other enterprise platforms. Get a deeper look at our expertise by visiting the Work section of our website.

But enough about us. Let’s talk about you.

As a Salesforce Data Architect at Horizontal Digital, you will lead data strategy, architecture, governance and migration for clients’ Salesforce and connected data platforms. The Data Architect plays a critical role for the team and will lead data migration strategy and implementation on Salesforce projects. Hands-on Informatica expertise is a mandatory requirement for this role.

What you’ll do:

Work with functional and business clients to determine solutions that drive additional business value and lead data strategy, design robust data models, and optimize data infrastructure to support the company's needs.

Work with Salesforce products: Informatica, Mulesoft, Sales, Service and Marketing Cloud

Make Data Strategy decisions related to the Salesforce environment

Work creatively and analytically with clients to understand business needs and create technical solutions in a problem-solving environment

Develop solutions for scalability, while ensuring that they conform to long-term strategic priorities

Evolve and shape the strategy, architecture, platform and standards for the integration team

Create the strategy around the Data capture and migration to enable enterprises host clean, valuable data in their instances.

Be involved in pre-sales activities

Define the enterprise data strategy and target-state data architecture across operational, analytical and AI use cases, spanning Salesforce, ERP, data warehouse and lakehouse platforms

Architect Salesforce Data 360 solutions, including data streams, data model objects, identity resolution, calculated insights, segmentation and activation, and zero-copy integration with platforms such as Snowflake, Databricks, Google BigQuery and Amazon Redshift

Design master data management and Customer 360 solutions, covering golden-record strategy, match and merge, survivorship rules and reference data management

Build conceptual, logical and physical data models, including Salesforce data models designed for large data volumes (data skew, selective queries, indexing, archiving and Big Objects) and their sharing and security implications

Establish data governance operating models, including data ownership and stewardship, metadata management, data catalogues, lineage, data classification and retention policies

Set up data quality frameworks covering profiling, quality rules, scorecards, monitoring and remediation workflows

Own the data migration strategy end to end: choose the approach (big-bang, phased by wave or region, or trickle with a coexistence period), sequence loads by object dependency, and select tooling such as Informatica IDMC, MuleSoft, Talend or Azure Data Factory based on volume, complexity, reuse and licensing

Design the migration architecture on Informatica IDMC or comparable ETL tools, with a staging layer, reusable parameterised mappings, orchestrated taskflows, external ID and cross-reference strategies, and pre-load cleansing and deduplication using Informatica Cloud Data Quality

Optimise and safeguard data loads through Bulk API 2.0 tuning, avoidance of record locking and controlled bypass of automation, handling complex data such as files, history, owner mapping and multi-currency, while keeping sensitive data masked and staging access restricted

Lead migration execution and sign-off through mock loads and dress rehearsals, automated reconciliation (record counts, checksums and field-level checks), cutover with freeze windows, delta loads and rollback plans, and hypercare, including legacy CRM migrations and Salesforce org consolidations

Shape analytics and reporting architecture across CRM Analytics, Tableau and downstream data warehouse feeds

Define data archiving, backup and recovery strategies for Salesforce and connected platforms

Prepare AI-ready data foundations for Agentforce and Einstein, including grounding data, unstructured data ingestion, vector search in Data 360 and the data quality needed for trustworthy AI outcomes

Lead a data community of practice, mentoring data engineers and consultants and driving reuse of standards, models and accelerators across projects

Modern ways of working with GenAI:

Use GenAI assistants (e.g. Informatica CLAIRE, Agentforce, Claude, GitHub Copilot) to speed up data profiling, source-to-target mapping, transformation logic and SQL/SOQL authoring, with architect-level review of the output

Apply GenAI in discovery to analyse legacy schemas, data dictionaries and sample extracts, producing field-level mappings, data inventories and migration plans faster

Use GenAI to draft and maintain data architecture artefacts such as ERDs (e.g. Mermaid), data dictionaries, data standards and governance policies

Bring AI into data quality through anomaly detection, suggested quality rules, duplicate and match recommendations, and generation of synthetic or masked test data

Use AI-assisted reconciliation and validation reporting during migrations to spot gaps and data issues earlier

Define and role-model responsible AI and data practices: approved tools only, no client or personal data in unapproved tools, use of the Einstein Trust Layer where relevant, human review of AI output and clear lineage for data feeding AI models

Who you are:

Experience designing and implementing a project’s technical & data architecture

Could work closely with clients to define and derive the solutions

Ability to guide the Development team

Good understanding of Salesforce Deployment/Physical architecture

Experience working with different file standards

Experienced with Object Oriented Architecture and RESTful Architecture

A pragmatic, business-outcome-focused architect who treats data as a product and can explain data trade-offs to executives and technical teams alike

Comfortable leading data decisions across Salesforce and non-Salesforce platforms rather than limiting the design to a single tool

An early adopter of AI-assisted data engineering who brings the team along, balancing speed with accuracy, privacy and governance

What you bring:

Mandatory – Informatica: Strong hands-on experience with Informatica Intelligent Data Management Cloud (IDMC), including Cloud Data Integration (mappings, mapping tasks, taskflows, Secure Agent, pushdown optimisation), Cloud Data Quality and the Salesforce connectors, with working knowledge of Informatica MDM, Cloud Data Governance and Catalog, Cloud Application Integration and PowerCenter-to-IDMC modernisation

Experience defining the structure of the system, its interfaces and the principles that guide the client

Strong skills in system documentation (ERD’s, process flows, etc)

10+ years of client-facing consulting/professional services experience.

7+ years of experience designing, refining and implementing data migration using Informatica and other equivalent platforms

Experience working within cross-functional project team to understand requirements and deliver solutions

Evaluate and recommend data management technologies, tools, and platforms to support the organization's data strategy.

Expertise in planning and executing enterprise data migration projects, including data mapping, data cleansing, and data transformation using native Salesforce tools and third-party ETL tools (specifically Informatica and MuleSoft, including DataWeave), minimizing downtime, blackout and data loss during migration processes. Informatica is a must have.

Proven track record leading large-volume Salesforce migrations end to end using Informatica or comparable ETL tools (e.g. Talend, Jitterbit, SSIS, Azure Data Factory), including legacy CRM migrations and org consolidations, backed by strong SQL for staging, profiling and reconciliation

Prior experience in migrating and integrating data from various sources, including external systems, databases, and files while ensuring data quality during the process.

Oversee data integration processes between systems, enabling seamless data flow across applications and platforms.

Experience in designing and developing complex data models, including custom objects, fields, and relationships to support business processes.

Experience in establishing and maintaining data governance policies and standards.

Experience in monitoring data quality and implementing data cleansing procedures.

Experience in implementing robust data security measures, including data encryption, access controls, and data masking.

Hands-on Salesforce Data 360 implementation experience

Experience with cloud data platforms such as Snowflake, Databricks, Google BigQuery or Amazon Redshift, with strong SQL skills

Knowledge of data modelling techniques, including third normal form, dimensional modelling and Data Vault

Experience designing for large data volumes in Salesforce, using Bulk API 2.0, Data Loader and related tooling

Working knowledge of data privacy regulations and how they translate into data architecture controls

Practical experience using GenAI tools in data work, with an understanding of AI-ready data concepts such as retrieval-augmented generation (RAG), vector search and unstructured data

Preferred certifications: Salesforce Certified Data Architect, Salesforce Data 360 Consultant (formerly Data Cloud Consultant), Informatica IDMC certifications, or Snowflake/Databricks certifications

The above description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

Data Architect- Salesforce/Informatica

Start with your email