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,…